Use a filter in a dashboard prompt

Question

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

Adam Wickes · Answer

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.

Calcioscacchi · Answer

a) CASE WHEN in which filter? group_machine_xxxx?

thanks for your answer

[Deleted User] · Answer

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