Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Action link not working in Direct database request(OBIEE 11g)
My Requirement is
From direct db request .. i need to navigate to detail report and it should be display the results(detail report results) based on the value,which user click's on the summary report.
Summary report(geneareted from Direct database request) columns:
year,week,state,total sales,
i)i had provided action link on state column
Detailed report (is genearted from the analysis) columns are
year,week,state,city,total sales
when i am clicking on particular state in the summary report it is navigating to summary report but it's not filtered based upon state value provided in the detailed report and
it is showing the all the data in the summary report.
Is action link works on direct database request or not?
If any one having any ideas pls share me ..
Thanks in advance.
Answers
-
The action link works ! You said it yourself ...
7f401ba3-8aa5-4c11-a8a6-5dff16af5aef wrote:...when i am clicking on particular state in the summary report it is navigating to summary report ...
One question for you: how do you think OBIEE is supposed to know that "State" coming from a Direct Database Request is the same as "State" coming from a subject area?
It's the job of the RPD to provides the metadata required to know that a column is the same in 2 different analysis and so an action link can send the values from one to another.
Writing a Direct Database Request you bypass the RPD, so you can't expect to get any RPD metadata related to the columns of your result.
0 -
Hi,
if two reports share the same subject area and the target report is filtered 'IsPrompted' then it should catch the prompt from the source.
if the situation is not as straight forward then you may have to find a way to bind the variable(s) (using presentation variables typically) and place an associated filter on your target, referencing it using the syntax {MyVariableNameHere}{DefaultValueHere} - this can get more complex if you need to pass numerous values.
Hope this helps,
Robert.
0
