CODEWITHSUNDEEP
ssasmdx
OverflowStack
OverflowStack

Reputation: 259

String to MDX code

I have the following scenario:

I have my MDX code in a cell in a dimension.

e.g. [MDXCode].[Code].[Code] contains the string: 

"([GL Account].[GL Account Code L1].&[ABC],[Measures].[Amount]) + ([GL Account].[GL Account Code L1].&[XYZ],[Measures].[Amount])"

Now I want this cell evaluated as MDX code.

I tried with StrToMember and ToTuple but do not get it working. e.g.

StrToTuple([MDXCode].[Code].[Code])

However if I limit my example to ([GL Account].[GL Account Code L1].&[ABC],[Measures].[Amount]) it works. If I add another tuple to sum both it does not..

Upvotes: 0

Views: 1016

Answers (1)

GregGalloway
GregGalloway

Reputation: 11625

Try this:

StrToValue([MDXCode].[Code].CurrentMember.Name)

Edit upon further info. If you can make MDX Formula a property of Ratio Name:

StrToValue([Finance Ratio].[Ratio Name].CurrentMember.Properties("MDX Formula"))

Upvotes: 2

Related Questions