How to group multiple measure in to one for search view

don21 — Wed, 03 Apr 2019 11:12:39 GMT

Dear all,

My data has many KPIs (56 to be exact). I have a requirement that I need to create a search box where if I type the name of KPI the corresponding cross tab must display that column data.

kindly let me know how can I achieve this..

Many thanks..

Re: How to group multiple measure in to one for search view

FredrikE — Wed, 03 Apr 2019 12:38:05 GMT

Hi!

One way to do this is by creating a parameter and connect it to a text input box.

Then create a calculated measure that checks the value of the parameter and then chose the corresponding kpi, ie:

if [parameter] = 'kpi1' then kpi1

else if [parameter] = 'kpi2' then kpi2

...

Then use this calculated measute in your cross-tab

One problem is that you can't change the format dynamically depending on the chosen kpi, they all get what you specify for the calculated measure.

Another is that the user must type the exact name of the kpi. One way to solve this is that the text box filters a list with your kpi's and the user selects kpi from this list, also you create another parameter used in the calculated measure.

Hope this can give you some inspiration 🙂

//Fredrik

topic How to group multiple measure in to one for search view in SAS Visual Analytics

How to group multiple measure in to one for search view

Re: How to group multiple measure in to one for search view