Filter view on union report in OBIEE 11g

Question

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

Joel Acha · Answer

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.

3607295 · Answer

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