replace an element in mdx with a variable
Posted: 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
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