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
Hi ,
ReplyDeleteI 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.