Oracle Analytics and AI

How to display graph and table dynamically using dashboard prompt in OBIEE 12c

Hi , below is the client requirement. Could someone let me know if this is possible in OBIEE.

Dashboard prompt : Report has a prompt called Metric

Report columns : Reports has a column Period(which would be a month Jan-18,Feb-18 etc) and 15 measure columns.

Report contains a Line graph and table.

User wants all these 15 measure columns as drop down in the Metric prompt. NOTE : These 15 column have custom names and they are derived using some logic in column formula and not direct presentation columns.

User can select one or multiple values from metric prompt.

Based on this selection, he wants graph and table to show data only for selected values from the Metric drop down.

Can this be achieved in analysis. Is it possible to provide such prompt and to dynamically show the graph and table only for those selected values in prompt.

+ other measures in this prompt

Graph for two values selected in Metric prompt.

Table only for those two selected values in Metric prompt. If user selects 10 values, then the table should show 10 column for those.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Manoj0408 wrote:User wants all these 15 measure columns as drop down in the Metric prompt. NOTE : These 15 column have custom names and they are derived using some logic in column formula and not direct presentation columns.User can select one or multiple values from metric prompt.Based on this selection, he wants graph and table to show data only for selected values from the Metric drop down.

Long story short you want to have the dashboards behave like a custom GUI instead of having your people use Answers.

PLUS you don't even want to use the prepared semantic layer of the RPD and you do post-calculations and logic for the column formulas in the front-end.

Simple question: Why are you using OBI at all in this case if anyway anyone should be able to change anything anywhere?

Manoj0408

Hi Christian, the above mentioned was explanation for the requirement given by client.

All I wanted to know was whether this type of functionality is possible in OBIEE report.

Neither column selector nor presentation variable is working.

So just wanted to know whether it is possible to achieve this somehow?

Manoj0408

Hi Christian, the above mentioned was explanation for the requirement given by client.

All I wanted to know was whether this type of functionality is possible in OBIEE report.

Neither column selector nor presentation variable is working.

So just wanted to know whether it is possible to achieve this somehow?

[Deleted User]

Yes it is possible but no, it isn't worth the effort of building a convoluted solution that you have to maintain afterwards, which will be error prone because it isn't pure out-of-the-box functionality but a finicky construct.

It is never wrong or wastes time to try and educate your client about HOW to do things.

Just getting a sheet of paper and implementing every single thing written there is not "consulting". It's "executing without thinking" and that's not adding any value to your client's business.

Jerry Casey

If you still just need to get it done, the Column Selector view will work. If you set up a selector for both your Period and Metric columns,
it could operate something like this one, where I have several options for both the column and row categories:

The Column Selectors will drive every view you create off of your analysis. Within the Selectors, you will have to re-create the formula that define your measures.

I'm working in 11.1.1.9.5, and assuming this holds true in 12C.