Mdx Interval definition

[bskalli]

Hello everybody,

how can I define in MDX a subset with the interval 000 -* to 999 -* ?

Thanks

[lotsaram]

Code: Select all

{FILTER(
  {TM1SUBSETALL( [DimName] )},
  [DimName].CurrentMember.Name >= "000" AND [DimName].CurrentMember.Name <= "999"
)}

[bskalli]

many thanks Lotsarm,

I am going to test it with the strings '000 -' to '999 -'

[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