Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 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
Opening detail report on same page

Hi all,
I am trying to create an action link that doesn't open the detail report on another page, but adds it on the same page as the master report. I want it to be invisible at first and want it to appear whenever someone clicks on a value. I know it's possible because I've seen it before, but I can't find it anymore. To be clear: I don't want a traditional master-detail construction, because then the detail report is already visible.
Any help will be much appreciated!
Kinds regards,
Lianne
Answers
-
One way is detailed here ->
https://it.toolbox.com/question/display-page-in-obiee-answers-092911
0 -
Hello Robert,
Thanks for your reply. I'm afraid I haven't been very clear in describing my wishes. I would like the original report to remain on the page and the detailed report to appear on the same page (in a different section/column/...). So I don't want to navigate to a separate page.
0 -
There proposed solution is that you replicate your entire page but with the additional analysis, then set it all as hidden.
So your action link takes you to what looks identical to the current page but with the additional section visible.
Make sense?
0 -
Btw - do give yourself a user friendly display name, long time users are more likely to engage with you than if you just leave it as the default.
0 -
Hi again Lianne,
the other thing that you could try is making your report invisible based on another report not returning data.
Use a filter with a presentation variable with a default which will never return data, like Month = @{MyPresentationVariable}{NoMonth}
Then have your presentation variable setting to another value in the dashboard prompt change, you can use case logic to change another value than NoMonth to the All Months like this; -
case when @{MyPresentationVariable}{NoMonth} then 'NoMonth' else YourTimeDimension.MonthHere end
The above is just me illustrating the concept.
0 -
Hi Robert,
I'm not sure I understand your presentation variable solution, but that could just be me because I'm unfamiliar with using them.
Your first tip worked :-) only I'm also using column selectors and my added columns disappear...because it's a different dashboard. Do you maybe have a solution for that as well?
0 -
No, sorry, I do not know of a means of synchronizing your column selectors too.
On the presentation variable idea it is; -
1. Section visible or not based on an analysis
2. Variable drives visibility by defaulting to value that would always yield no rows via a filter on the analysis in question
3. On selection of a dashboard prompt the variable is changed so the analysis would have rows and the hidden section becomes visible
Hope this makes more sense?
0 -
-
Did you find your answer?
If so would you mind closing the question and marking correct / helpful as appropriate.
If not do you still need any help?
0