OBIEE 12c Conditional report selection issue

Lee Gledhill

Hello All,

I have an issue with a Dashboard I'm creating and am baffled as to why this is happening and how I can resolve.

I have conditional Sections in 2x Dashboard sub-pages, controlled by 2x different variable prompts and 2x different analysis (though from the same Subject Area)

The conditions are set by Analysis - when the number of rows in the condition is equal to the number of rows in the analysis.

Separately, both Dashboard pages work fine - when I select the report choice, the report appears, when I change the radio button in the Prompt, the report changes.

My issue occurs when I switch Dashboard sub-pages - the condition set in page 1 is carried over to page 2 IE:

If I select Report number 3 in page 1, when I click to switch Dashboard pages to load page 2, page 2 will show report 3 and the Prompt on Page 2 will not control the dashboard page. Page 1 remains operable when I go back to it.

I have ensured the prompts' scope is set to 'Page' - and there can't be anything wrong with the analysis as they work fine separately.

I wondered if it's browser cache but I'm not so sure?

Any help would be hugely appreciated!

Thanks, Lee

Robert Angel

Have you tried using presentation variables in conjunction with protect filter to achieve the same ends, then you can explicitly ensure that each report only responds to the prompts that you want it to.

Lee Gledhill

Thanks Robert, that has helped though unfortunately not solved the problem entirely.

The Reports on Page 2 now respond to the correct Prompt when I change the Radio Button, though the page still loads with the condition set in Page 1.

Thanks,

Lee

Lee Gledhill

I have other conditional settings on other Dashboard pages within, these are not affected by the same issue, so the issue seems to lie with the fact that the conditions are on 2 subpages of one Dashboard Page, if I separate the subpages into Dashboard header pages this will solve my problem but they're subpages for a reason, I don't want to have 50 Dashboard header pages.

Robert Angel

Do you have any prompt levels or master / detail in your page, I have also seen it where one analysis catches those types of filters as a side effect

My other suggestion would be (in a development environment) delete the analysis one at a time and repeat the test until you find the one that is driving the behaviour.

Robert Angel

Final suggestion would be give yourself a user friendly name, a lot of people ignore people on the forum who are newbies who have machine generated names, as they tend to take and not mark / close questions.

Lee Gledhill

Cheers, I've changed my username following signing up today, I'm assuming it just hasn't refreshed?

Lee Gledhill

Okay will do, thanks for your help!

Robert Angel

I think it is your display name you need to alter...

Adam Wickes

Have you tried altering the scope of your prompt to affect only the page it's on?

EDIT: Apologies. Just saw that you had indeed tried this.