Dashboard Prompt is not working on 2 dashboards — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Dashboard Prompt is not working on 2 dashboards

Received Response
22
Views
6
Comments
Rico
Rico Rank 3 - Community Apprentice
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

Hi,

I have a dashboard prompt with presentation variable type (pDate) and i use it in 2 dashboards (A and B). Each analysis on the dashboards have same date filter (set equal to @{pDate}).

The dashboards are connected by action links (navigate to BI content).

The prompt is working fine if I open each dashboard from dashboard menu.

The prompt is not working on dashboard B if I :

1. Open dashboard A, apply the date prompt to 24/12/2017, the result is ok ( data is filtered base on date prompt - 24/12/2017).

2. Click some value on dashboard A and go to dashboard B automatically.

3. The data on dashboard B is filtered to 24/12/2017 and the prompt on dashboard B is automatically set to 24/12/2017 - this is expected result.

4. But if i try to change or re-apply the prompt on dashboard B to 25/12/2017 or any date, nothing happen - as if the data is frozen to the prompt on dashboard A

What did i miss, is that possible to create such scenario?

Regards,

rico

Answers

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

    Hey Rico,

    First question: do you absolutely HAVE to use variables?

    We see variable issues all over the place all the time in the forum and maaaaany cases are simply wrong usage of the tool and could be achieved with standard functionality.

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    Print @{pDate} in the analysis header to check what date is getting passed. You need to make sure that it is presentation variable is really getting used to filter the analysis not column filter. You can test that  by checking "protect filter' in the analysis.

    My guess is two analysis has two different column where you are applying the filter.

    Thanks

    Arijit

  • Gianni Ceresa
    Gianni Ceresa Mod

    Did you look on MOS? I guess I remember a bug related to that, where dashboard do not react to prompts anymore or something like that ...

  • Rico
    Rico Rank 3 - Community Apprentice

    Hi Berg,

    when I used column prompt I get DD/MM/YYYY HH:MI:SS format on calendar value.

    But when I used variable prompt I get DD/MM/YYYY on calendar value.

    I cant find a way to make it DD/MM/YYYY in column prompt.

    regards,

    rico

  • Rico
    Rico Rank 3 - Community Apprentice

    Hi ArijitC,

    The analysis has same column.

    The pDate keep shows filter value on Dashboard A

    regards,

    rico

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

    What is the datatype of your column which you are using in the column prompt?