Page 1 of 1

replace an element in mdx with a variable

Posted: Mon Oct 09, 2017 3:03 pm
by Analytics123
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

Re: replace an element in mdx with a variable

Posted: Mon Oct 09, 2017 4:19 pm
by Wim Gielis
vMDX =
‘{
ORDER(
{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER({[Months].[FY2017]}, ALL, RECURSIVE )},0)}
, [testcube].([Sales Measures].[Full Revenue],[testcty].[‘ | vCountry | ‘]), BASC)
}’;