Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 186 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 63 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
One Prmopt For Multiple Views In Anlaysis Level
Hello,
I've a requirement from user to Build an analysis Where one prompt can impact multiple views. For example when we use YEAR As Pivot table/Graph prompt it will only impact the table/view it is related to but what I need is Single prompt at analysis level which can impact two or more Views.
PS:
1. I'm taking about the Prompt at analysis level in Results tab not a straight forward Dashboard Prompt.
2. I tried creating a view with in the pivot table but the problem here is pivot table and graph will have same columns. If I want to exclude one column from Graph and show it in Pivot table then it's not possible.
Thanks.
Answers
-
Hi,
Prompts exists only at 2 levels: dashboard prompt or analysis prompts.
You exclude the dashboard prompt as you want to stay inside the the analysis, so you can use the inline prompts.
When you open the analysis you will see the prompts, you select your values and then the analysis shows you the result. They work in the same exact way as dashboard prompt, but they are inside the analysis.
There isn't another prompt (the "prompt" section of views isn't a real prompt as it doesn't really filter the query, it just reduce what the screen display from the whole set of data received).
You could also explore master-detail inside the analysis between the various views, with one view sending the value selected or clicked to other views (which will have the columns in the prompt section of the view).
0 -
Gianni, Thanks for replying. What You said is true. Prompt section of the views reduces the set of data. Here The same way I want to have a prompt which will reduce Data set of Pivot table and Graph at a time. Inline prompts can't be displayed in Results tab, right?
0 -
No, because when you are in the views it's too late. Inline prompts will filter the query like dashboard prompts, so when you have your table, pivot, chart the dataset is already filtered by the values selected.
Give a try to master-detail, it's the only one which could still give you a similar filing as prompts in the view.
0
