topic SAS VA - Control / Parameter that you can change on multiple pages and have all pages reflect change in SAS Visual Analytics

SAS VA - Control / Parameter that you can change on multiple pages and have all pages reflect change

MikeBsocal — Wed, 09 Nov 2022 20:12:13 GMT

Hi All

I have 5 pages in a VA report. They are displaying different aspects of what we call health "markets" (eg. diabetes, allergies, Multiple Myeloma, etc). On Page 1, I have a Control / Parameter that allows me to select one market from the many we have available in the data. I want that Market selection to filter 2 other pages (which I know how to do by filtering on the Parameter from Page 1). However I want to be able to change the market selection on Page 2 as well -- and if I do, I want Page 1 and Page 3 to change to the Page 2 Market. Same thing for Page 3 -- if I change the market here, I want it to be reflected on Pages 1 & 2.

*Note that I have 2 other pages that CAN'T be filtered for Market so a Report Filter isn't an option.

Anybody know how to do that?

Thanks!

@Sam_SAS @HunterT_SAS

Re: SAS VA - Control / Parameter that you can change on multiple pages and have all pages reflect ch

acordes — Thu, 10 Nov 2022 09:37:24 GMT

I think that it's not possible.

I deal with this by placing the selector and the parameter, in your case related to 'market', on a specific report page for customizing.

In my opinion this drawback is justified because parameters should be unique and autonomous by nature and what you're trying to do is make them dependent by each other.

Re: SAS VA - Control / Parameter that you can change on multiple pages and have all pages reflect ch

HunterT_SAS — Thu, 10 Nov 2022 14:38:18 GMT

I also do not believe you can do this with separate filters on each page, but there are maybe two alternatives.

Instead of having pages 1, 2, and 3 as separate pages, have you considered using a Stack Container on page 1, and essentially move the contents of these pages into separate "stacks". Then you can get by with a Page prompt for Market on Page 1 that filters the entire stack container, but being a Page prompt it wouldn't touch pages 4 and 5.

A slightly more complicated alternative is to change it so pages 4 and 5 are using a different datasource (assuming they aren't already, and even if it's just a duplicate of the datasource used by pages 1, 2, and 3), and then use a Report Prompt for Market but do not map it to the second datasource. That way when you change it, it will filter pages 1,2,3 but won't do anything to 4 and 5. However might be confusing to end users looking at page 4, seeing the Market prompt, and the prompt not actually doing anything.

Re: SAS VA - Control / Parameter that you can change on multiple pages and have all pages reflect ch

MikeBsocal — Thu, 10 Nov 2022 16:26:52 GMT

Thanks HunterT and acordes for your responses. I may try the stacked container approach. I haven't used those yet.