BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Surya_Ravindran
Fluorite | Level 6

Hello,

 

We would like to use report prompts to filter out data in a report but want certain objects to be static and not be affected by the filter. 

 

An example would be a report that displays sales KPIs that can be filtered by agent, but also has an object that displays the total sales of all agents together.

 

I am not able to see any options to unlink a specific object from a report prompt filter.

 

Would anyone know the solution to this please?

1 ACCEPTED SOLUTION

Accepted Solutions
FredrikE
Rhodochrosite | Level 12

Hi!

If you add prompts in the report/section area they will automatically filter all object with the same data source.

If you want full control over the interactions you will need to add the prompt to the report area.

 

 

One way that might work to get around this is to have a two data sources with the same data. Then you can add prompts with one of the data sources and objects using both.

The objects using the same data source as the prompt will automatically be filtered but the other objects will not.

 

When you do this you will get a question to link the prompt to the other objects, answer no on this and the linking will not be assigned.

 

Happy trying 🙂

//Fredrik

View solution in original post

4 REPLIES 4
FredrikE
Rhodochrosite | Level 12

Hi!

If you add prompts in the report/section area they will automatically filter all object with the same data source.

If you want full control over the interactions you will need to add the prompt to the report area.

 

 

One way that might work to get around this is to have a two data sources with the same data. Then you can add prompts with one of the data sources and objects using both.

The objects using the same data source as the prompt will automatically be filtered but the other objects will not.

 

When you do this you will get a question to link the prompt to the other objects, answer no on this and the linking will not be assigned.

 

Happy trying 🙂

//Fredrik

Sam_SAS
SAS Employee

Another (clumsy) workaround might be as follows:

 

1. In the report prompt, use a dummy table that only contains the values for the prompt. By itself, this won't do anything.

 

2. Assign a parameter to the prompt. I believe you will also need to set the prompt as "required" in the options.

 

3. For each object that will be filtered by the prompt, add an advanced filter with an expression like, 'Region'n = 'Parameter 1'p

 

This does work, although it is not ideal.

 

Besides being cumbersome, this approach is limited in that the prompt values are not dynamic. Possibly you can solve that in your data preparation of the dummy table? I am not an expert in data preparation.

 

I hope this will help,

Sam

Surya_Ravindran
Fluorite | Level 6

Thankyou Fredrik and Sam, both approaches worked for me 🙂

 

I was able to get around the issue by creating an aggregated data source with the fields I want and delete any mapped fields between the source table and aggregated table.

 

This seems to work and gives me the correct values.

 

Kind Regards,

Surya

Sam_SAS
SAS Employee
Ah! Great idea to use an aggregated table. Thanks for following up with us 🙂

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 4 replies
  • 1988 views
  • 5 likes
  • 3 in conversation