Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ersin.gulbahar on 04 Feb 2015 03:52:07 AM

Title: ERROR :hierarchy cannot be determined from the expression(src:TM1/Cognos10.2.1)
Post by: ersin.gulbahar on 04 Feb 2015 03:52:07 AM
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
Title: Re: ERROR :hierarchy cannot be determined from the expression(src:TM1/Cognos10.2.1)
Post by: MFGF on 04 Feb 2015 08:45:27 AM
Quote from: cognoset on 04 Feb 2015 03:52:07 AM
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.
Text only | Text with Images