Pivot table showing NULL row in OBIEE12c

User_79XD5

We have a report with multiple pivot tables , each showing the measure based on a different dimension value.

But even after setting properties in "Pivot Table Properties" for (Null Values - Include rows with only Null Values is unchecked) we are still getting a NULL row in the pivot table. we are trying to find an efficient solution to overcome this issue.

The pivot table shows a null dimension value with column values, which is not relevant to the dimension i have used in the pivot table.

Sample:

select a.dim1,b.dim2, c.dim3, a.measure1 from a,b,c,d where a.dim0 =b.dim0(+) and a.dim0=c.dim0(+);

i have 2 pivot tables.

pivot table1:

	a.dim1 -val1	a.dim1 -val2
b.dim2 - val1	a.measure1 val1	a.measure1 val3
b.dim2 - val2		a.measure1 val4
b.dim2 - val3	a.measure1 val5
	a.measure1 val6
Grand Total	a.measure1 Total	a.measure1 Total

c.dim3 is excluded from pivot table1 even though it is part of the query.

similarly, we have pivot table 2, which will be calculated based on c.dim3 but b.dim2 is excluded from it.

So we are getting NULL dim value rows with some measures as show in the table above (a.measure1 val6).

tried to search for similar issue found the below ,

But the post is old and there weren't any answers.

Is this how the pivot table feature is expected to work ? we have all our tables with outer join scenarios. I am looking to eliminate the NULL row.

Am I missing any thing to avoid the NULL row? Appreciate the help.

Regards

Eswari