Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dummy report for Dashboard section condtional format
Answers
-
Dear aPsikus,
Do you have privilege to create a new table?
If yes, please create a new table with just 1 column and populate that column with some sequence (ROWNUM - 1, 2, 3, 4, 5 and so on)
Create your dummy report using this column, apply a filter on this column using your presentation variable (this should be a valid number (using case statements, if required) and should also be present in the table you created in step 1).
The filter condition should be less than equal to (you can change the logic as per your conditions though)
That's all.... you are done...
Apply conditions with == operator and select whatever values you want...
I hope this helps.
0 -
Plan B: keep it simple !
Make as many condition analysis as you have values in the prompt ...
Basing conditions to display one of many sections on number of rows returned by a single condition analysis and trying to find dimensions having different (but fixed) number of rows is the best way to get in troubles in the next 2-3 or more months.
Make conditions which are just based on the values of the variable: if the variable match the value then there are rows returned, if variable doesn't match your value then there aren't any rows returned. You will have a condition analysis for every possible value of your prompt, and use these various condition analysis as condition to hide/show sections.
0 -
Dear aPsikus,
Please mark this thread as resolved if your queries are answered so that this can help other users as well...
0 -
Hi,
This is the requirement, but description from link do not work.
Case added after OR is returning error.
0 -
Martin,
What is simpler in this solution?
How to display correct subpage based on selection?
0 -
Jerry,
Many thanx
Simple, and works just great.
0 -
How to display correct subpage based on selection?
Well, By just selecting (clicking on) the sub page that you want to see. If only a single section should be displayed at one time, then why make it complex by putting them on the same page?
0
