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

Cross-subject area prompts on dashboard

Received Response
75
Views
10
Comments
Charles M
Charles M Rank 6 - Analytics Lead
edited Aug 13, 2024 5:26PM in Oracle Analytics Cloud and Server

Hi All,

We created a dashboard which is based on a cross-subject area analysis. The data looks good, but we have to use two dashboard prompts to get it that way (both on the column used for the cross-subject area analysis - one on each subject area, respectively).

Is there a way to have only one prompt on the dashboard, instead of two? Or, at the very least ... automatically populate the second prompt with the value of the first.

OBIEE 11.1.1.9.x (OBIA 11.1.1.10.1)

Regards,

Charles

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    instead of a column prompt, use a variable prompt which populates a presentation variable. You can then use the presentation variable in the filter of the analyses on your dashboard.

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi Joel,

    Thanks. Does this mean we still keep one of the prompts? And, use a presentation variable in place of the other one?

    Regards,

    Charles

  • Joel
    Joel Rank 8 - Analytics Strategist

    yep. Just use 1 variable prompt and in the filters of your analyses, you can use the presentation variable to pass the value/s selected in your dashboard prompt down to these analyses on your dashboard.

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi Joel,

    I've been experimenting with this, but haven't quite gotten it worked out yet. Any way you can break this down into a few more steps?

    Charles

  • Charles M
    Charles M Rank 6 - Analytics Lead

    I think this may be a relevant article: Using the presentation variable with date prompt between ... as we also have a date-between prompt here. I've lost some of the context to translation though

  • Joel
    Joel Rank 8 - Analytics Strategist

    Look at this to set up the variable prompt:

    https://gerardnico.com/dat/obiee/obips/presentation_variable_initialization

    You can then then reference your presentation variable in the filter of your analyses

    3DDA6D9F-D689-4E56-8FC6-F06F16FE0F24.jpeg

    Select the Presentation Variable option

    6750F44B-B388-458E-B4CC-97A52A688D00.jpeg

    Enter he name of your variable in the Variable Expr field

    306004D9-24EF-41B8-B591-95BBA5D838AE.jpeg

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi Joel,

    Thanks for the follow up! I am still working on this ... but, I think I'm almost there. One thing. Is there any way to test the value of the variable in real-time (see it somewhere inside the application or log)? I see a small data discrepancy and want to confirm what the value is.

    Regards,

    Charles

  • Joel
    Joel Rank 8 - Analytics Strategist

    Several ways. One of which is to go to the Manage > Sessions menu in the Admin tool. Just select your session and you’ll see a list of all variables and their actual values.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Add a text block to your dashboard and just print out the value of the variable with @{variable-name} .

    To see it in a log you would need to pass it to an analysis as parameter etc. would be longer and more complex than just display it.

    The same work if you add a text view in your analysis itself.

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Thanks Gianni. I was able to view that the variables were correctly being passed. In this case, I am getting both of them as dates, in the correct format (as it is a date prompt with the between operator).

    pastedImage_0.png

    @Joel Acha - I wasn't able to see them from the sessions ... but, thanks for the input.

    Still testing this out, but seems to be working as intended.

    Regards,

    Chalres