BookmarkSubscribeRSS Feed
tejeshwar
Calcite | Level 5
Hi,

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.

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

http://mysasbiblog.blogspot.com/2011/04/set-up-event-based-interactions-between.html

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 1 reply
  • 880 views
  • 0 likes
  • 2 in conversation