Friday, July 8, 2011

OBIEE Developing a Parent-Child hierarchy

Just some strange behaviour I noticed OBIEE doesn’t like me developing a Parent-Child hierarchy in online modus in 11.1.1.5. It seems to miss some settings during a consistency check. When I did it in off-line modus the consistency check showed the errors.

Till Next Time

1 comment:

anzy.m said...

Hi ,

I have a requirement to show null values for a calculated column in pivot table(calc column in the sense data is expressed as a % of page value).

Will you please help me to find a solution for this.

I have one more issue regarding pivot table customization.Let me explain this scenario.


suppose my data is like

for branch1:
doument ; #of request ; sum; percentage(%)
doctype1; 1; 2; 3; 0 ; 6 ; 12.76%
doctype2; 2; 3 ;4; 5; 14 ; 29.78%
Sum ; 3 ;5; 7; 5; 20 ; 42.55%

Total for branch1: 20
for branch2:
doument ; #of request; sum ;percentage(%)
doctype1; 4; 2 ;3; 0 ; 9; 19.14%
doctype2; 2; 7; 4; 5 ; 18; 38.29%
Sum ; 6 ;9; 7; 5; 27 ; 57.44%

Total for branch2: 27
Grand Total for two branch:47

The % column in the pivot table is the sum values expressed as a % of the grand total for two branches.

I am stuck at this point .How to generate this % column.
Please help to solve this issue.