Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dashboard prompt should refresh only particular in obiee 12c dashboard

Hi All
I have created dashboard prompt with custom values like DTD, MTD, YTD. In the report level I have handled presentation variable with case statement like case when '@{DMYTD}{DTD}'= 'DTD' then Fact details.DTD_Actuals end.
After adding dashboard prompt and report in dashboard, if I change to DTD in prompt the enter dashboard page getting refresh because we can set dashboard prompt scope either page or dashboard level.
Is there any way to fix this only for particular report?
I have tried Inline prompt as well but it's was not working because that are custom values and Not available in table level
Regards
Ramesh
Answers
-
I am not sure I follow what you are asking for here.
Do you want the queries to not run again? Do you want to stop a page refresh in the browser? Do you want to not apply that one column prompt to one analysis?
0 -
Hi Berg,
The dashboard Page contains 6 reports and each report having different dashboard prompts, my question is, if I change prompt for individual report the entire page should not refresh and the only particular report should refresh.
0 -
Hi Christian,
I knew you were fast but I think you just broke the laws of space / time!!
There was a young lady called bright
Who travelled much faster than light
She departed one day in a relative way
And returned the previous night.
Seriously though, I think he is looking for a way to have his dashboard prompt ignored by some of the analyses on a page but not by others.
0 -
the "trick" I'd use in this scenario if I understand your requirement correctly would be to edit the column formula on the "analysis" which you don't want to change on the dashboard by adding a space for example:
"Finance Facts"."Revenue"||' '
This would ensure that the is prompted filters on the dashboard won't be affected by this analysis as the column ("Finance Facts"."Revenue"||' ') is no longer the same as your dashboard prompt ("Finance Facts"."Revenue").
0 -
My trick would be set presentation variables and use the filter lock to ensure that the right variable and the right variable only filters the analysis in question.
Doesn't your trick prevent indexes being used?
0 -
1.) "analysis". Not "report". A "report" is a BI Publisher object. Different product. Different technology.
2.) As Joel indicated the column prompts and prompted columns communicate over fully qualified names. So either use his approach of having a "modified" fully qualified column name or.
3.) Go for a "variable prompt" instead of a "column prompt" for that one prompt.
0 -
Robert Angel wrote:
Seriously though, I think he is looking for a way to have his dashboard prompt ignored by some of the analyses on a page but not by others.That was my guess as well, but the initial question had too much imprecisions so he could have meant anything.
0 -
very possible that indexes on this column will be ignored but we are speculating on the volume of data in OP's data source and if at all the column is indexed...
0 -
Agreed - I was more trying to understand if I had understood your trick correctly.
0