I'm trying to define a Picklist for the user for selecting one of his own, non system, cubes.
I know, I find the names in the }Cubes dimension. But there are also all system cubes, beginning with "}".
Now I want to create a subset with all non }-cubes using a MDX statement.
Unfortunatly I didn't get a solution.
TM1FILTERBYPATTERN is filtering positive, so anything like '}*' will be in, but I need the others!
Code: Select all
FILTER( {TM1SUBSETALL( [}Cubes] )}, NOT StrToMember([}Cubes].CurrentMember.Name).StartsWith("}") )
BTW:
Code: Select all
FILTER( {TM1SUBSETALL( [}Cubes] )}, [}Cubes].CurrentMember.Name = '}Cubes' )
Also my attempt to use SUBSTRING() was unsuccessful. I read an article for defining a rule doing the SubString there, but I can't believe that this would be the solution today.
So any hints for me?
BR
Dirk