Page 1 of 1
Creating TI to add attributes to cubes
Posted: Wed Apr 21, 2010 1:43 am
by appleglaze28
I was thinking of creating a subset for the }Cubes dimension for non-control cubes, what syntax is there to use to like be able to use "}" as my basic determinant of control cubes...but I'm not sure how EQUAL or LIKE syntax would be for TI.
Re: Creating TI to add attributes to cubes
Posted: Wed Apr 21, 2010 2:49 am
by lotsaram
Hi appleglaze,
For some reason I feel like your personal TM1 tutor lately
This should do the trick to generate a subset of just your "user defined cubes."
Code: Select all
{EXCEPT(
{TM1SUBSETALL( [}Cubes] )},
{TM1FILTERBYPATTERN( {TM1SUBSETALL( [}Cubes] )}, "}*" )}
)}
Phil Bichard's MDX primer is a good resource!
If you want to process all members of the }Cubes dimension in TI then you can just test the first character with sub string eg.
Re: Creating TI to add attributes to cubes
Posted: Wed Apr 21, 2010 3:11 am
by appleglaze28
Thanks Lotsaram, truly appreciate it...just a bit too hard to go through all the manuals not knowing if they have the stuff you need or not.