Use a filter in a dashboard prompt

Calcioscacchi · Jan 31, 2020 6:01AM

Hi there!

I'm a OBI 11.1.1.9.160419 user. I have a question for you about a personalized dashboard prompt:

WHAT I HAVE NOW:

I have a dashboard that shows some KPIs for a group of machines.

In the first page of the dashboard, I have a prompt with 2 filters: year and month, and those filters affects all the dashboard pages. This is possible because i set the parameter year as "from prompt" in the analysis criteria.

Actually, all the analysis that I show in the Dashboard have a filter, for example Machine_group_2019 with machines 1,2,3,4, and Machine_group_2020 with machines 5,6,7,8.

If i want to change the machine group, i have to go inside any analysis, and change the filter.

WHAT I NEED:

I would like to have the possibility to build a prompt where i can choose Machine_group_2019, Machine_group_2020.... and my choice had to affect the dashboard pages with the machines that are in the filter.

So, if in the first page i choose year=2020, month=all, Group = Machine_group_2019, the analysis had to show data from the year 2019 and for the machines 1,2,3,4.

Possible?

Thanks

[Deleted User] · Jan 31, 2020 6:16AM

a) CASE WHEN in the filter

b) Put the year into a presentation variable and do Group = 'Machine_group_' || @{pYear}{2020}

Probably about 5 more possibilities

Calcioscacchi · Jan 31, 2020 7:16AM

a) CASE WHEN in which filter? group_machine_xxxx?

thanks for your answer

Adam Wickes · Feb 3, 2020 6:37AM

Apologies if I misunderstand what you're trying to do but can't you just create an extra column in your analysis which groups up the machines into your categories and then just prompt on that new column?

EDIT: You don't even need to display that calculated column. Just create it as a filter using a case/if expression.

Christian's methods would work fine as well.

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Use a filter in a dashboard prompt

Answers