AMO Class library: MdxScript Commands

Hi,

I have a question regarding the AMO Class MDX script.

As desribed here http://msdn2.microsoft.com/en-us/library/microsoft.analysisservices.mdxscriptcollection_members.aspx there seems to be a collection with several MDX scripts and a marker for the active script collection...

Does anyone know if BIDS always uses collectionitem(o) from the enumeration?
or is it possible to handle more than one item of the collection in BIDS? and if it is possible - where is the button to change the shown item in BIDS?

Thanks in advice!

Cheers,
Markus

I'm not sure about the first part of your question, but I do know that it isn't possible to see more than one item from the collection in BIDS. Sorry...

Chris

|||

Hello Chris,

thanks for the answer - hope that someone could clarify, the usage of the collection...

Have you seen this?

http://www.european-pass-conference.com/

Hope that we will meet there...

Cheers,

Markus

|||

hello Markus,

if in your cube, you have an MDXScript object with DefaultScript property set to true, then Calculations tab in BIDS's Cube Editor, should pick up that script. In case there is no such script, then then first script in the collection, would be chosen. It is not possible to switch to a different script in BIDS. BIDS will never create multiple scripts itself.

hope this helps,

|||

No, I hadn't seen that - thanks! I'm pleased to see that PASS Europe is back, and I'll definitely try to be there.

Chris