cancel
Showing results for 
Search instead for 
Did you mean: 

mandatory filter which value depends on user choice

Former Member
0 Kudos

I've just start my experience with SAP BO, and I have big problem to solve. Iu2019m using Universe Designer and I need a mandatory filter, which can have one of two values. The value of filter depends on user choice. Filter should have default value. Eg. when user choose "internal view" filter will add expression tabe.column = 'X' to a query, when user choose "external view" filter will add expression table.column = 'Y'. The main problem is that chosen value should be remembered in report. So user cannot be prompted every time to choose a value. Does anyone has any idea how to solve this problem? The best solution would be when one filter could reference to another. Or to use internal report variable, but I think there is no such thing. Thanks for any advice.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

It should be solved by using an @prompt in the mandatory filter.

eg. table.column = @Prompt('Select internal or external','A',{'internal view','external view'},Mono,Constrained,Persistent)

Answers (0)