nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Dashboard prompt should refresh only particular in obiee 12c dashboard

s234

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

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

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?

User_RWPWI

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.

Robert Angel

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.

Joel Acha

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").

Robert Angel

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?

[Deleted User]

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.

[Deleted User]

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.

Joel Acha

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...

Robert Angel

Agreed - I was more trying to understand if I had understood your trick correctly.