BookmarkSubscribeRSS Feed
tejeshwar
Calcite | Level 5
Hi,

I am fairly new to the SAS BI Dashboard functionality and have been reading couple of research papers lately on how to create an effective BI Dashboard. I think if I have to summarize one key learning from the content that I read was emphasis on the underlying data feeding a BI Dashboard which is basically different depending upon every business requirement and the indicator one plan to use.

Our organization has multiple portfolios and multiple products for every portfolio. Our first requirement would be to indicate Actual Vs Op Plan across these portfolio and their products. Similarly we would need to create an indicator for different time (for ex: week, month, YTD). I want to create an indicator based on a percentage (%) of how far ahead or behind we are against the OP PLan. I have data summarized at Portfolio and Product and also at week, rolling upto month and year. I created a the % variable in the Information Map(Calculated Variable) . So while creating an indicator only at product level, I am keeping only the calculated attribute, however the problem is that even if I change the aggregation to avg, its an arithmetic mean. Usually our OP PLan numbers are different for every portfolio and every product and for every week they might differ and hence the avg needs to be weighted. Also, the weight needs to be assigned based on at what level the data is being aggrgated (by product would be different vs by portfolilo). I was wondering if there was an alternative, possibly taking the Actual and OP Plan to the data model and if an indicator can calculate the difference in a % automatically and I can just create a range. Any help would be appreciated.

Thanks,
Tej Message was edited by: tejeshwar

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
  • 0 replies
  • 649 views
  • 0 likes
  • 1 in conversation