ssas - String to MDX code -


i have following scenario:

i have mdx code in cell in dimension.

e.g. [mdxcode].[code].[code] contains string:

"([gl account].[gl account code l1].&[abc],[measures].[amount]) + ([gl account].[gl account code l1].&[xyz],[measures].[amount])" 

now want cell evaluated mdx code.

i tried strtomember , totuple not working. e.g.

strtotuple([mdxcode].[code].[code]) 

however if limit example ([gl account].[gl account code l1].&[abc],[measures].[amount]) works. if add tuple sum both not..

try this:

strtovalue([mdxcode].[code].currentmember.name) 

edit upon further info. if can make mdx formula property of ratio name:

strtovalue([finance ratio].[ratio name].currentmember.properties("mdx formula")) 

Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -