TI or Rule function to check if element exists in dimension

[harrytm1]

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!

[Alan Kirk]

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.

[harrytm1]

thanks Alan! it works!