Page 1 of 1
Mdx Interval definition
Posted: Mon Oct 10, 2011 10:43 am
by bskalli
Hello everybody,
how can I define in MDX a subset with the interval 000 -* to 999 -* ?
Thanks
Re: Mdx Interval definition
Posted: Mon Oct 10, 2011 11:03 am
by lotsaram
Code: Select all
{FILTER(
{TM1SUBSETALL( [DimName] )},
[DimName].CurrentMember.Name >= "000" AND [DimName].CurrentMember.Name <= "999"
)}
Re: Mdx Interval definition
Posted: Mon Oct 10, 2011 11:19 am
by bskalli
many thanks Lotsarm,
I am going to test it with the strings '000 -' to '999 -'
Re: Mdx Interval definition
Posted: Tue Oct 11, 2011 9:42 am
by bskalli
The complete solution looks like :
{FILTER(
{TM1SUBSETALL( [RLS_Tarif] )},
[RLS_Tarif].CurrentMember.Name >= "000" AND [RLS_Tarif].CurrentMember.Name <= "999"
)}
{TM1FILTERBYPATTERN(
{TM1SUBSETALL( [RLS_Tarif] )},
"??? - *")}
It´s the first time i use CurrentMember.
Thanks