Mandatory filters

[Former Member]

Hi folks,

I think this question may have been asked and answered before, but I could not find a match during my search.

I have a requirement to have a mandatory filter on a folder, which is well and good. Any time the users select objects from that folder, they get prompted. However, the problem is that sometimes they might manually drag the object(on which the filter is built) into the filter panel and enter a value. In this case, we do not want the filter to prompt when they run the query. Also there are reports built on top of this Universe and we don't want the filter prompts to show up when the managed reports are run.

I'm using Information Designer, BI platform 4.0 SP6.

Thanks

-Dev

[Former Member · Accepted solution]

Hi Dev,

I cant think of  a way where you can do both simultaneously, so I think you either have to compromise on forcing the filter at the folder level and train the users to drag and drop into query filters when they want to use prompt, while still having the flexibility of creating custom query filters with constant values etc on the base object.

Or you go with forcing the prompt  and make it as optional and ask them to use it for any query restrictions associated with it as prompts, else they can leave prompt unanswered and create the query filter on base object to perform their constant value filtering.

Thanks

Mallik

[Former Member · Accepted solution]

Thanks for the response, Mallik. I kind of figured that there is a limitation with this feature but I was hoping there is a more elegant solution to this and that it should be seamless to the users.

[Former Member · Accepted solution]

Hi Dev,

I could think of only the above mentioned. Lets hope someone comes up with some creative work around which is more seamless to users.

Thanks

Mallik

[former_member188911 · Accepted solution]

This is not an existing feature, you may wish to require an enhancement at http://ideas.sap.com , my suggestion is to give also the solution on what would make a class/folder force a set of prompts to be associated to all the objects it contains because in my opinion it would be too complicated, to not exclude the ramifications that security would bring with this...

Thanks

Simone