NOTE null is 'All' only is you have a lov and you tell it do do so
https://us.v-cdn.net/6037859/uploads/1OF4WYQE6PE1/image.png
Yes you can do that either in your data model or in each layout using a condition (if).
In data model for example by adding a column to your data model with a calculation
for example if physical sql where parameter is text (if number or date then cast to character to_char)
select all … , (case when (coalesce(null,:p) is null) then 'All' else :p end) as s_p from …
Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Cloud Fusion Multi Select Parameters Errors Out When two or more items are selected
Answers
-
So I'm trying to implement this and it's failing when I select two items. It says it's missing a parenthsis. I know your original comment is recommending to set to text field has comma seperated values. I'm wondering if this is counting on that being true. This is a Menu Parameter Type though, because I want it to be based on a list of values from the system.
0 -
Like this?
0 -
Can you try below in your RTF file?
<?If:PARAMETER_NAME = ''?>All<?end if?> to print All explicitly?
Thanks.
0