I have a requirement where I have to navigate to a detailed level report when I click on the column. When I place the reports in the same subject area it works absolutely fine. But according to the requirement the reports cannot be in the same subject area. So when I click on the column, all the filters on the dashboard prompts pass through the main report in SubArea1 to Detail Report in SubARea2 but the attribute value that clicked on does not pass through as a filter. I see all teh records at a detailed level and not just that attribute's records.
We are trying to implement 'Navigate to BI content' Action link from one report to another.
Both these reports are not in the same subject area (Presentation layer) though. How can be make OBIEE pass the appropriate filters to show only the needed subset of data in the second report.
This is needed for our CL, PL and Agency details report. The dashboard is from one subject area, the detail report is from another subject area. We now want to pass what the user clicked in one to the other. Please note that the dashboard prompts would get passed correctly. It is only the 'attribute' on the left side that would not.
Master-Detail is the best for your requirements or else URL base navigation.
If helps pls mark
Edited by: Srini VEERAVALLI on Dec 5, 2012 10:14 AM Can you update this?
Edited by: Srini VEERAVALLI on Jan 28, 2013 1:13 PM
All the columns whose values you want to pass to the detail report should be prompted in detail report and the column names should be same.
If you are clicking on Period.Year column in master report then the detail report should have Period.Year column is prompted.
Subject Areas may be different but the presentation table name and column name should be different.