Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Search functionality in Hiearchy Report

Posts: 42

Search functionality in Hiearchy Report

Hi ,


Engaged with a client who is into Energy trading, and using PowerPivot,   wherein they access most of the report via Excel,  one of the functionality which is provided is a search for value with a dimension, the client is also looking for a similar functionality when he is viewing an hiearchical report in SAS VA,  


I thought that we had the filters avialable in the report, but some how i couldnt see the same in my report,  


Please do guide if i have got it wrong, or any possible approach.




Frequent Contributor
Posts: 130

Re: Search functionality in Hiearchy Report

Posted in reply to Ronny_Dsouza

Here's my suggestion and I realize there are some issues with this one - but you can figure out a way to overcome them.


  1. Build the hierarchy.
    Mine is Product > Problem Code > Resolution Code.
  2. Added two Text Input objects - 1 for Problem Code and 1 for Resolution Code.
  3. Now the hierarchy collapses and you can see your choices.




Tricia Aanderud
Zencos Consulting
Twitter: @taanderud - Follow me!

Ask a Question
Discussion stats
  • 1 reply
  • 1 like
  • 2 in conversation