Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

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 Cloud and Server

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
    Joel Rank 8 - Analytics 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.