Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dynamically hide a column
Hi,
I have a requirement where I have some metrics columns as well as attributes and I have created a pivot layout after applying the necessary filters.
Now I want to hide some columns dynamically if it does not have any data. is this possible out of the box.
I have put a attribute in a section so the pivot report has got lets say 4 sections. In this some columns have values in one section but is null in the other section.
My requirement is to hide these null columns dynamically.
Thanks in advance.
Answers
-
One way to achieve this is to create 2 compound layouts; one with the column and one without the column in the same analysis.
The second step would be to create a dashboard with 2 sections that have conditions on them. The first condition would be a count of the column > 0 for the compound layout with the column and the 2nd condition would be a count of the column = 0 for the compound layout without the column.0 -
Hi Joel,
Thanks for the reply. My question was more related to dynamically hide the columns.
Pivot table By Section:
Section1 Attr 1 Attr 2 Attr 3 Attr 4 Measure Col1 Measure Col2 section2 Attr 1 Attr 2 Attr 3 Measure Col1 Measure Col3 Measure Col4 Section 3 Attr1 Attr3 Measure Col1 Measure Col4 0 -
Within a view using section this will not be possible as the rendering is fully dynamic. What you ask for isn't possible.
Remember that you are doing analytics and not pixel-perfect reporting. That's why there is an own product called BI Publisher which does that.
0
