Oracle Communities

Oracle Analytics and AI

Child Item

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

Find more posts tagged with

Accepted answers

All comments

Robert Angel

One way is detailed here ->

https://it.toolbox.com/question/display-page-in-obiee-answers-092911

RBol

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.

Robert Angel

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?

Robert Angel

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.

Robert Angel

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.

RBol

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?

Robert Angel

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?

Robert Angel