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!

BI Answers: Problem using filter in Dialog "Edit Column Formula"

user600503Oct 16 2007 — edited Feb 22 2010

Hi,

In the "Edit Column Formula" dialog I wanted to set a filter on the fact attribute
Fquality to filter the data where Fquality is set to 1. But I always get the following error message:

[nQSError: 10058] A general error has occurred. [nQSError: 22032] Function FILTER requires at least one measure attribute in its first argument. (HY000)
SQL Issued: SELECT "Production Dimensions"."Recipe number", "Production Facts".Fquality, FILTER("Production Facts".Fquality USING ("Production Facts".
Fquality = '1')) FROM FLPKSJ_DWH

What is going wrong ? Fquality is part of the fact table and is a measure - or not ?
What exactly is a measure ?

Any help is appreciated.

Thanks
Volker

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2010

Added on Oct 16 2007

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

4 comments

1,104 views