Hi, I'am new with MDX and I'am looking for a way to define and set a MDX parameter within the MDX context (MDX script ?). Afterwards I want to be able to use the MDX parameter in a MDX query.

Example:
This is (a simplified version of) my MDX Query:
SELECT ( STRTOSET(@MyParameter, CONSTRAINED) ) ON COLUMNS FROM [MyCube]

How can I define the parameter @MyParameter and set it to e.g. '[Resources].[Resources].[Group Name].&[ILI].&[ID].&[157].&[385]' ?

Thanks to all for any help :-)

Timmo


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

STRTOSET(SELECT(STRTOSET(@MyParameter,
CONSTRAINED)).ITEM(0).UNIQUENAME)


Timmo ha escrito: