Categories
- All Categories
- 143 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
OBIEE combines subject areas Include rows/columns with Null values not available

Good day everyone
I created an OBIEE analysis which consists of a combination of 2 subject areas using "Combine results". I however noticed afterwards that you cannot use the "Include rows/columns with Null values" option in the pivot properties as it is greyed out/not available.
Is there a Oracle patch/enhancement available for this or a workaround that some can suggest?
Thank you.
Johan
Answers
-
-
Hi Christian
We are using OBIEE 12.2.1.4.0.
I am referring to combining 2 results sets as in a union. See screenshots below:
In the pivot properties "Include rows/columns with Null values" is not available:
In your example it is showing all lines as the intersection with the Paid Amount column has data. I want the whole row to show even if there is not a single value in the whole row.
0 -