Traditional web-based reporting with SAS BI tools

Information map Filter values

Contributor RSB
Posts: 72

Information map Filter values

I have a Values 'Group','Entity X','Entity Y' that are values in the Prompt applied to the column Entity_Name(Only Entity X and Entity Y are values in Entity_Name), if the values Entity X or Enity Y are selected the data should be a filtered based on the the value, but if the value 'Group' is selected data should return for both Entity X and Entity Y).

Is there a way to do this using the information map?

Thanks in Advance.

Message was edited by: RSB Message was edited by: RSB
Posts: 0

Re: Information map Filter values

Yes this can be done in a information Map studio.
There are 2 ways to do this.

1- If you are not using a stored process and simply working on Map studio then you can refer this-

In this, 'All employee' could be your GROUP and the values that go under Group would be Entity X and Entity Y.
You can go through this link and try it in the Maopstudio. This should work.

2-If you sre using stored process and your prompts are getting called from the stored process (that gets attached to the information Maps), then you can use this method. This is something that I am doing. In this you can write the desired Code and check the condition for 'grouop' selection.
Let me know if you are using this approach as may be i could help you with the coding.

All the best.

Contributor RSB
Posts: 72

Re: Information map Filter values

Thanks Neha, That was helpful.
Ask a Question
Discussion stats
  • 2 replies
  • 2 in conversation