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!

Add Filter to measure within analysis

McEntyreMAug 27 2014 — edited Aug 28 2014

Hi All,

I am trying to add the measure on the one analysis to display three different sets of data depending on the scenario and year. I have added the measures and applied a column formula "filter" to each data column to filter the column by a Scenario and Year but no data is coming through on the results. If I remove the filter, data will appear. I have normal filters setup within the criteria to filter the year (2013, 2014), and scenario (Actual, Budget). The measure is called: "HFM#1"."Data"

The filter is as follows:

FILTER("HFM#1"."Data" USING (("Scenario"."Gen2,Scenario" = 'Actual') AND ("Year"."Gen2,Year" = '2014')))

FILTER("HFM#1"."Data" USING (("Scenario"."Gen2,Scenario" = 'Budget') AND ("Year"."Gen2,Year" = '2014')))

FILTER("HFM#1"."Data" USING (("Scenario"."Gen2,Scenario" = 'Actual') AND ("Year"."Gen2,Year" = '2013')))

Is there anything else that is required? Any settings within the RPD before you can use filters?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2014

Added on Aug 27 2014

#11g, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #column, #filter, #obiee

9 comments

2,581 views