Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem creating IFNULL( )

613701Jan 21 2008 — edited Jan 22 2008

Hi
We are tyring to create the following logical columns but getting some error.Can anyone tell me how to get the functionality of IFNULL if OBIEE.

IFNULL( SUM( CASE WHEN "Printing Key Indicators"."Key Indicator Measures".KEY_IND_CODE_ACCT_TY IN ('NACC', 'RACC') AND "Printing Key Indicators"."Key Indicator Measures".FACT_TYPE_ACCT_TY = 'REGULAR' THEN 1 ELSE 0 END ), 0)

i created a duplicate column for the highlighted one and tried using Aggregation -> Based on Dimension -> Other to recreate the above expression in logical column but getting following error ' You must use standard aggregate functions.'

Can anyone please tell me how to get this done.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 19 2008

Added on Jan 21 2008

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

980 views