Categories
- All Categories
- 72 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 39 Oracle Analytics Trainings
- 58 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
OTBI Spend Analysis - how to link dashboard prompt to graph prompt
Hi All,
I am new to OTBI and am trying to create a dashboard to allow users to analyse spend by product category. My business has set up a hierarchy with 2 levels.
The report needs to be able to be run for any department (which we are using the cost centre field for).
On the two graphs, the only way i can display results by department is to put the cost centre description field as a graph prompt, however i would like the user to be able to run the report via the dashboard filter, then what they select for cost centre description also populates the graph prompt - if that makes sense? Is this possible?
I previously had cost centre description as excluded on both graphs, but when i searched by cost centre nothing populated...any ideas?
Thanks!
Answers
-
Hi CarolineH ,
Thank you for posting about linking dashboard prompt and graph prompt.
You need to make sure the same prompt field in the analysis as a filter with operator "is prompt. This is described in the documentation.
If my response has answered your question, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer.
Regards,
Priscila Terazawa
0 -
Hi CarolineH ,
Thank you for posting about linking dashboard prompt and graph prompt.
You need to make sure the same prompt field in the analysis as a filter with operator "is prompt. This is described in the documentation.
If my response has answered your question, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer.
Regards,
Priscila Terazawa
0 -
Hi CarolineH ,
Thank you for posting about linking dashboard prompt and graph prompt.
You need to make sure the same prompt field in the analysis as a filter with operator "is prompt. This is described in the documentation.
If my response has answered your question, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer.
Regards,
Priscila Terazawa
0 -
Hi CarolineH ,
Thank you for posting about linking dashboard prompt and graph prompt.
You need to make sure the same prompt field in the analysis as a filter with operator "is prompt. This is described in the documentation.
If my response has answered your question, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer.
Regards,
Priscila Terazawa
0 -
Hi CarolineH ,
Thank you for posting about linking dashboard prompt and graph prompt.
You need to make sure the same prompt field in the analysis as a filter with operator "is prompt. This is described in the documentation.
If my response has answered your question, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer.
Regards,
Priscila Terazawa
0