dbTalk Databases Forums  

Aggregation by AS does not equal to total

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Aggregation by AS does not equal to total in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Arun
 
Posts: n/a

Default Aggregation by AS does not equal to total - 04-05-2005 , 06:46 AM






Dly Value
ItemGroup Item Year Total
Not Known Other (MTM) 2004 0
2005 0
Other (MTM) Total -60,136,777
Not Known Total 0


As you can see above, AS shows a sum of -60,136,777 but the value for
breakdown is 0. This occurs for other items too. Can some one explain
what is going wrong here.


Thanks,
Arun

Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Aggregation by AS does not equal to total - 04-05-2005 , 07:17 AM






have you some security setting up?
there is other years in the cube?

does your measure is a calculated one? (if yes, what is the formula)
does 1 of your dimension has a custom rollup formula?

have you reprocess your cube?

"Arun" <arun.ns (AT) gmail (DOT) com> wrote

Quote:
Dly Value
ItemGroup Item Year Total
Not Known Other (MTM) 2004 0
2005 0
Other (MTM) Total -60,136,777
Not Known Total 0


As you can see above, AS shows a sum of -60,136,777 but the value for
breakdown is 0. This occurs for other items too. Can some one explain
what is going wrong here.


Thanks,
Arun



Reply With Quote
  #3  
Old   
Arun
 
Posts: n/a

Default Re: Aggregation by AS does not equal to total - 04-05-2005 , 07:34 AM



No security has been set up. There are many years in the COB dimension
( 5yrs).

The measure that is in the above ex is not a calculated one (Although I
have another calculated member)

I do not have any custom rollup formula for any of the dimensions.

The cube is reprocess completly.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.