Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Filter view on union report in OBIEE 11g

Received Response
31
Views
2
Comments
Harshith
Harshith Rank 1 - Community Starter
edited Aug 13, 2024 5:29PM in Oracle Analytics Forum

Hi All,

We have union report which contains filter on same columns in both criteria's but when use filter view   no data showing in filter .

I did few workaround like

1.static/narrative view using presentation variables but hardcoded text is visible in report without selecting the any prompt criteria and what as similiar as standard functional behavior.

2. Created separate report for title and filter view and passed the presentation variables  and  it working as expected in dashboard but the issues is when you export the report into excel or others  only report is exporting with title and filter view.

Can any one help on this  issue.

Thanks in advance

Ragards.,

Harshith.CC

Answers

  • 3607295
    3607295 Rank 2 - Community Beginner

    Hi,

    Did you try to make the filter as a prompt for desired column in each union and then put this analysis with it's prompt on a dashboard.

    please check this solution then feed me back with your results.

    Thanks

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    Hi @Harshith

    Could you maybe explain what your issue is with some images/screenshots of what you're actually trying to achieve? I don't quite understand what your issue is.