Switch between dashboards using prompt in OBIEE 11g

3355141

Hello.

Can you switch between dashboards using a prompt in OBIEE 11g? For e.g, you make a dashboard prompt, display it on a plain dashboard and use it to move to another dashboard. Please note that both prompts have the same columns.

asim cholas

Try Javascript

Andrew Fomin.

What business task do you try to solve by this?

It's often that what you really need is not the same as you think you need if the question is that far from the normal tool behaviour.

3355141

I want to show a prompt on a dashboard. Once the user selects the options from the prompt, it will take the user to the next page where the dashboard will be shown having the same prompts at the top now. Point is, the first page should only contain the prompts and the next page should display the dashboard,

asim cholas

Keep two dashboard pages and make one hidden. Keep prompt in both the pages. and prompt level should be dashboard. Use javascript for navigation.

I dont know if you can use other methods. Like Condition in Section and show the report after selecting the values from prompt. It will ideally satisfy the requirement. Or display dashboard links when you select values from prompt and click on the links to navigate to the new dashboard.

Andrew Fomin.

I understand what you want to do, my question is about why you want to do it.

This requirement looks strange for me. And I've noticed that 3/4 of strange requirements typically originates from a blind following of other tools approach, or what users ask, or lack of knowledge of OBIEE features. The purpose of my asking is to understand what business task you need to solve and maybe offer you a more standard and straightforward solution. While JavaScript hacks look cool support of a system with a lot of such things is a pain. It is hard to implement, hard to support, hard to upgrade such a system.

rmoff

+1 to what @Andrew Fomin. said.

JS hacks are just technical millstones around your neck that really become a nuisance every time you move code between environments, backup, patch, upgrade, etc.

Sometimes, they're necessary, to work around a product limitation for a very valid business requirement.

Far too often, they're used as a lazy option by developers taking requirements too literally, not challenging them sufficiently, nor making the business aware of the *risk* of a hack-based solution.

what business task you need to solve 

This, right here. That's the question you need to answer.

Thomas Dodds

+Infinity to @Andrew Fomin. and @rmoff

IF there's no analytical, informational or decision-support value in the requirement ... how did it get passed? 

The request is adding additional steps therefore prolonging the 'trip' to information ... it seems counter to the intent of Business Intelligence.

Gianni Ceresa

I of course agree with @Andrew Fomin. , @rmoff and @Thomas Dodds on the main concept.

But still curious about something: how many pages does your dashboard have? (so how many values/entries in your prompt?)

If you answer < 8-10 then go back to what the people mentioned above posted. If you have > 20 then I can at least see why you asked for that.