Dashboard prompt should refresh only particular in obiee 12c dashboard — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dashboard prompt should refresh only particular in obiee 12c dashboard

Received Response
63
Views
9
Comments
s234
s234 Rank 3 - Community Apprentice

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    User_RWPWI Rank 1 - Community Starter

    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
    Robert Angel Rank 8 - Analytics Strategist

    Hi Christian,

    I knew you were fast but I think you just broke the laws of space / time!!

    pastedImage_0.png

    pastedImage_1.png

    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
    Joel Rank 8 - Analytics Strategist

    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
    Robert Angel Rank 8 - Analytics Strategist

    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]
    [Deleted User] Rank 2 - Community Beginner

    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]
    [Deleted User] Rank 2 - Community Beginner
    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
    Joel Rank 8 - Analytics Strategist

    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
    Robert Angel Rank 8 - Analytics Strategist

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