BookmarkSubscribeRSS Feed
jplarios
Quartz | Level 8

Hello:

I am trying to see if there is a drill-across solution in VA like below:

lets say one object table is showing the head of Dept A , the instructors under Dept A, in particular Joe below, hist course and the  campus and the measure:

Dept Instructor course campus measure1
A Joe Math SE 20%

now I want the head of Dept A to drill across for that faculty, joe and compare the measure for math but for all dept. and campus:

Dept instructors course campus  measure1
All All Math collegewide 34%

 

What would be the options for the above drill across in VA.

2 REPLIES 2
PetriRoine
Pyrite | Level 9

Hello @jplarios 

 

Could you please provide a little bit more information to help understand the need.

- A sample data set?

- Which version of VA you have?

- Maybe some kind of sketch of the report page and how you want it to work?

 

Best regards,

Petri

 

FredrikE
Rhodochrosite | Level 12

Hi!

Hope I understand your problem correct 🙂

 

I did a test using sashelp.class. You can try it yoursellf by importing sashelp.class into VA.

This is the outcome:

FredrikE_0-1599731655226.png

 

 

On the report there are 2 button bars and 1 cross-tab. All measures are set to average aggregation. I have created 2 new dimensions that are used in the cross-tab. I also created 2 dimension for the choices in the button bars.

I use the button bars to select level of detail for sex and name (using parameters). Depending on their values the drill level will change:

FredrikE_1-1599731736450.png

 

 

FredrikE_2-1599731784077.png

 

 

FredrikE_3-1599731830565.png

 

 

 

Then create a new report and add the data set.

 

Then create 2 new dimensions (*_dim, 2 new level choice (*_choice) and 2 paramters (*_level):

FredrikE_0-1599730800774.png

Set default value for the parameters to 'Sex' and 'Name'.

Define the sex_dim as:

FredrikE_1-1599730919332.png

 

Create name_dim as:

FredrikE_2-1599730935609.png

Create level choice as:

FredrikE_3-1599730965410.png

 

FredrikE_4-1599730975708.png

 

Add two button bars and assign them as:

FredrikE_5-1599731017343.png

FredrikE_6-1599731027914.png

 

Add a cross-tab and assign as:

FredrikE_7-1599731049279.png

 

Set all the measures to average aggregation and start testing 🙂

 

//Fredrik

 

 

 

 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 496 views
  • 0 likes
  • 3 in conversation