Cross-subject area prompts on dashboard

Charles M

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

Joel

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

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

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

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

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

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

Select the Presentation Variable option

Enter he name of your variable in the Variable Expr field

Charles M

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

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

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

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

@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