BookmarkSubscribeRSS Feed
SanderEhmsen
Quartz | Level 8

Hi all

 

 

I am getting involved in a project where we want to create multiple reports - but we want to link the reports to where they belong in the  supply chain. So on different locations I want to state how many of an item is in this location. And from different drop down menues I want to filter the data, so the numbers in the flow chart change.

 

Futhermore I want to be able to click on these numbers getting moved to more detailed data. 

 

Is this possible in the SAS environment? 

 

IMG_0003.JPG

4 REPLIES 4
PetriRoine
Pyrite | Level 9

Hello SanderEhmsen,

 

Yes, it's possible. Basically you need only two things.

 

  1. The main view (section)
    All you location specific KPIs (number of items) arranged according to your supply chain. Each KPI object is linked to a sub-view so when you double click the KPI your details view is opened. Plus some control objects for filtering as needed.

  2. Sub-views (sections)
    A detailed view for location specific data.

 

Best regards,

Petri

 

 SC_Main_view.PNG


SC_Main_view.PNG
SanderEhmsen
Quartz | Level 8
Hi Petri

Thanks a lot for your quick reply.

Is the presentation done i SAS VA? If yes, then what type of object is it you have put your data into?
PetriRoine
Pyrite | Level 9

Hi @SanderEhmsen,

 

The KPIs here are actually Piecharts (I just hid the pie by eating it 😃 or perhaps I adjusted pie colors to be similar with the background). Let me know if you need more information how to do this. I'm using here VA7.2

I know that Dynamic KPIs are much more comprehensively supported in the newest release SAS Visual Analytics v7.4. You can utilize it for example for single-value metrics, to display the date when the data was last updated, display a value of a parameter, etc etc...

 

The background I did in PowerPoint to give it a nice visual touch.

 

Easy steps to do this: 

1. Create a new report section and define Layout = Precision mode
(You find this under the Properties tab when your Section is selected from the right top corner drop-down box.)

 

 

2. Add Text object for the title. Work your magic with the fonts, sizes and colors.

 

3. Add KPIs of your selection and arrange them so that they remind your Supply Chain. Work your magic with the styles. Like stated above, I used pie charts. 

Here's a link to a nice example how to do KPI in older versions of SAS VA.

http://support.sas.com/kb/58/288.html

 

4. Define Links to your detailed view sections by right clicking each KPI -> Add Link -> Section Link.

 

I hope this helps.

 

Best regards,

Petri

 

SC_Main_view_2.PNG

SanderEhmsen
Quartz | Level 8

Hi Petri

 

Thanks for your guide which has brought me forward. 

I am not in a situation where I again need some assistance. 

If possible it would make a world of difference, if I can bring my flow chart more alive by adding some nice images to it.

Here is a try: 

 

 

 

 

CPE_flow_v1_simple.png

 

 

But my problem is the ever returning lack of scaling in SAS VA. I want my image to scale to the users screen so that the text boxes follow the location on the background image. Maybe just locking the internal location between image and boxes?

Do I reach you? And what are your thoughts? 

 

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!

Discussion stats
  • 4 replies
  • 2518 views
  • 4 likes
  • 2 in conversation