Skip to Main Content

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!

filtering OBIEE report

2657149Dec 7 2015 — edited Dec 10 2015

Hi All,


We have 10 reports with regards to the same requirement.

I have recently got a enhancement request to modify these reports to display the records based on a new condition that is to be added.

The requirement is to get a new custom dashboard prompt with Specific values 'Op' and 'Fis'

When the user selects 'Op', all the records except the ones with a column value having Corporate Operations should not be present on the report.

When the user selects 'Fis', all the records should be shown.

We have several prompts on the dashboard.

The filter Op/Fis should work on top of the other existing prompts on the dashboard.

It should be like all the records to come up from the database for all the applicable prompts that has been entered by the user-- (1)

When Op is selected, all the records from (1) should be displayed taking out the ones with a field value = Corporate Operations.

When Fis is selected, all the records from (1) should be displayed.

Hence, I am looking for an option which can control the result set retrieved and then apply the filter 'Op'/'Fis' as required.

Thanks

Shravan

This post has been answered by Thomas Dodds on Dec 10 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details