BookmarkSubscribeRSS Feed
Calcite | Level 5

My objective is to create a dashboard using the BI Dashboard 4.3 which will be a combination of 4 stored processes which will be used as a source to the indicators. Based on the objectives of what we are trying to create, the indicators are supposed to be filtered on certain attributes such as Time and type of comparision. 3 of the stored processes that are feeding 3 indicators on the dashboard needs to be filterd on exactly same attributes and the 4th one additionally needs to be filtered on TYPE of product.

My question is if it's possible to have users just filter the value once and the input is passed on to all the 4 stored processes for that dashboard rather than having users select the values seperately for each and every STP.

If their is not a simple way to do that, then I am directionally looking at couple of alternatives like creating a single stored process and outputting 4 different SAS datasets from it, each feeding a different indicator on the dashboard. The downside to that is the performance of the dashboard as it will take more time to get the results back to the indicators.... I am wondering if MP Connect can be used to create these 4 datasets simultaneously within a single stored process.

Calcite | Level 5 RSB
Calcite | Level 5
You can set up interactions between the indicators, check my attempt to explain this in detail.



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2 in conversation