Home » Fusion Middleware & Colab Suite » Business Intelligence » Oracle answers pivot table grand total problem
Oracle answers pivot table grand total problem [message #320266] Wed, 14 May 2008 08:21 Go to next message
sanamojdeh
Messages: 2
Registered: May 2008
Location: Greensboro, NC
Junior Member
Hi All,

I am working with OBI dashboard. I have a problem in creating a pivot table. To make it simple assume I have 3 columns: Sales, Target Sales, and %Diff. I added a total row but the problem is the total for %Diff is actually the average of the column instead of the %Diff between "total Sales" and Total "Target Sales". The aggregation rule for %Diff is set to Avg. and "Show data as" is set to Value.
I have seen the same problem here before. Can anybody help me on this?
Thanks
Sana

Report message to a moderator

Re: Oracle answers pivot table grand total problem [message #320339 is a reply to message #320266] Wed, 14 May 2008 14:18 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
I have seen the same problem here before
So, what did those people say?

Report message to a moderator

Re: Oracle answers pivot table grand total problem [message #320342 is a reply to message #320339] Wed, 14 May 2008 14:29 Go to previous messageGo to next message
sanamojdeh
Messages: 2
Registered: May 2008
Location: Greensboro, NC
Junior Member
no clue,
I just know I should set agg. value to Default not Avg. in pivot page and the same for the column in Criteria page.

Report message to a moderator

Re: Oracle answers pivot table grand total problem [message #321180 is a reply to message #320342] Mon, 19 May 2008 06:19 Go to previous message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
The aggregation rule should not be average in this case. Try Complex or Server Aggregate.

Report message to a moderator

Previous Topic: Log On to BI (XML) Publisher
Next Topic: few questions .. Oracle BI, Oracle BI Application,Hyperion,Hyperion-Essbase
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 17 18:30:25 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.