I am trying to create a condition in the universe which will prompt the users to select either a single value, multiple values or type the work ALL to get all of the values but am getting an error. - Please help!
The syntax I am trying is (error is missing right parenthesis)
DECODE(@prompt(āEnter Profile(s) or ALLā,āCā,āRisks\Risk Profileā,multi,constrained),āALLā,āALLā,RISK_PROFILES.risk_profile_name)
=@prompt(āEnter Profile(s) or ALLā,āCā,āRisks\Risk Profileā,multi,constrained)
If I replace the @prompt with an @variable statement (below) it works but the users donāt get a LOV and there are thousands of values in the list.
DECODE(@variable(āEnter Profile(s) or ALLā),āALLā,āALLā, RISK_PROFILES.risk_profile_name) = @variable(āEnter Profile(s) or ALLā)
No ALL is not a value. I means when the prompt is displayed (when the report is refreshed) and the āValuesā button is selected then all of the values that the column contains appear to the user.
I assume that is because teh parameter āRisks\Risk Profileā is present. Based on this what else would a customer LOV give me unless I only wanted a subset of the values to be available?
Yes, of course, you will get all the customer values in the database, unless you have any row restrictions.
Let me clarify 8), you wish the users to also be able to select āALLā, or ā*ā, or whatever, to show all records, correct?
The second link shows you how to insert the ALL into your Customer LOV, so the user can still pick this as a choice from the list, even though it is not a value in your DB column.
This, of course, may not be important for you, or your users, but it can be for othersā¦
Right Iāve got you. Yes I want them to be able to view all records is required but not too bothered about it being from a list - iām sure typing a * is easy enough!
Use ful to have the link though incase I need in future - Thanks
Have you exported the LOV with the universe, this is under the objects properties, in Designer?
Deski will be using a local copy on your PC.
To be honest, one of this size will take a long time to refresh anyway, especially, if it comes from a non-dimension table.