Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 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
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.
Answers
-
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?
0 -
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?
0 -
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?
0 -
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.
0 -
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.0