Search functionality in Hiearchy Report

Ronny_Dsouza — Wed, 22 Jun 2016 21:54:18 GMT

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.

Ron

Re: Search functionality in Hiearchy Report

TriciaAanderud — Thu, 23 Jun 2016 11:05:58 GMT

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

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

topic Re: Search functionality in Hiearchy Report in SAS Visual Analytics

Search functionality in Hiearchy Report

Re: Search functionality in Hiearchy Report