ERROR :hierarchy cannot be determined from the expression(src:TM1/Cognos10.2.1)

[ersin.gulbahar]

Hi everyone,
I want to create filter expression like this:

filter( [measure] , [other_measure] is not null)

how can I solve this error?

thanks in advance

[MFGF]

Hi everyone,
I want to create filter expression like this:

filter( [measure] , [other_measure] is not null)

how can I solve this error?

thanks in advance

Hi,

You haven't given us a lot of information to go on here. From the subject we can see you have a TM1 cube? This means it's a dimensional package.

Can you explain to us what you're trying to achieve? The expression you posted up doesn't seem to make any sense. Which set of members are you filtering? What filter expression do you need to use to reduce the set?

MF.