TM1 Forum

hi all,

i look through the reference guide and found TI functions to check if cube or dimension exists. however, i could not find any function to check if an element exists in a dimension and return 1 or 0.

any idea how i can achieve this check? many thanks!

harrytm1 wrote:hi all,

i look through the reference guide and found TI functions to check if cube or dimension exists. however, i could not find any function to check if an element exists in a dimension and return 1 or 0.

Use the DimIx function. If DimIx returns 0, you can return 0 yourself from an If() function. It it doesn't, you can return 1.

thanks Alan! it works!