replace an element in mdx with a variable

Post Reply
Analytics123
Posts: 88
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

replace an element in mdx with a variable

Post by Analytics123 » Mon Oct 09, 2017 3:03 pm

Hi,

I have this mdx .

{
ORDER(
{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER({[Months].[FY2017]}, ALL, RECURSIVE )},0)}
, [testcube].([Sales Measures].[Full Revenue],[testcty].[usa]), BASC)
}


here instead of [testcty].[USA], I have to replace a user variable vcountry from my variable tab in a ti process.
Can anyone tell me the syntax for the same

Thanks

Wim Gielis
MVP
Posts: 1571
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: replace an element in mdx with a variable

Post by Wim Gielis » Mon Oct 09, 2017 4:19 pm

vMDX =
‘{
ORDER(
{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER({[Months].[FY2017]}, ALL, RECURSIVE )},0)}
, [testcube].([Sales Measures].[Full Revenue],[testcty].[‘ | vCountry | ‘]), BASC)
}’;
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

Post Reply