Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Passing Multiple Filters on OBIEE 12c On Premise.
Hi All,
As i have requirement to pass filters from Report A to Report B .
I used navigation to implement this scenario, but it filters/pass only one column value but not multiple.
I verified the column definition or formula on both Report A and Report B , Everything is same. So not found any differences.
I verified the log as well it is filtering only one column value.
So i would request to all if any pointers or links or references pleased to share it, if anybody would have come up with this scenario.
Best Regards,
Guru
***Moderator note (Timo): removed private data/signature as this is not allowed here.***
Answers
-
Both are based on the same subject area?
The target has 'Is Prompted' filters on all of the columns you are trying to 'catch'?
There is nothing else filter wise on the same columns that could be blocking?
When you say 'navigation' do you mean an action link?
0 -
Hi,
This was just answered yesterday:
The gist of it is, when using an action link to pass multiple filters, use the "Navigate to a web page" option, not the "Navigate to BI content" option.
0 -
In addition to the good replies already posted above, it's worth nothing that action links do different things based on what/where they are applied. An action link on an attribute column will act in a very different way than an action link on a measure column.
As a general note you maybe want to have a look at and always post more details about your use case as there are tons of unknowns (starting from the version you talk about as things could work differently from a version to another).
0 -
802260 wrote:https://myoracle.webex.com/join/govardhana.gurmal
^---- Better remove that
0 -
Also as always:
1.) BI Publisher "Report" or OBI "Analysis"? Two different objects in two different technologies!
2.) HOW do you "navigate"? Navigate action? Manually constructed URL?
3.) IF it's an analysis - same Subject Area or different?
0 -
Yes Action Links.
0 -
Ok Let me try.Thanks for your replying.
0 -
Yes Same Subject Area.
0 -
Yes i constructed URL using the option GO URL Navigation to Web Page. But this navigations needs user to type required values.
let's say i have two dimension columns
1.Request Type --> It has mutiple types values --> KPI Actual & KPI Base
2.Workflow Status --> RUnning , Not Completed, Not Achieved, Partially Achieved.
So now user want to see based on Request Type values any of the Workflow status values
In HOrizontal Bar we have KPI ACTUAL as type with 4 workflow status values in different colors. As we click the each color/value it target report filter should filter with Type and Status.
0 -
You really don't need to use GO_URL if this is 'drill' behaviour on same subject area.
All you need is 'Is Prompted' on the target report and an action link for navigate to report on the data (not heading)
If you find that one column is ignoring the drill specific to the data then add a local dashboard prompt and use that to set presentation variable value, and filter based on the presentation variable instead on the target for that column. Once you get it to work you can then hide the dashboard prompt on the source page.
0
