Creating TI to add attributes to cubes

[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.

[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.

Code: Select all

IF( SubSt(sCube, 1, 1) @= '{' );

[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.