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 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 760 views
  • 0 likes
  • 3 in conversation