dbTalk Databases Forums  

Parent Child Dimension Aggregates without CALCULATE in the script

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


Discuss Parent Child Dimension Aggregates without CALCULATE in the script in the microsoft.public.sqlserver.olap forum.



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

Default Parent Child Dimension Aggregates without CALCULATE in the script - 10-06-2006 , 06:13 AM






Hi all,

Does anyone know if this is the behaviour that was wanted by the
designers of MSAS:

I have a cube that i use to do forecasts. It has one parent-child
dimension called Object. I load data to leaf members and higher
members.

In the cube script, i removed the default Calculate statement, becuase
i don't want anything rolled up, it should behave differently (inherit,
extrapolate etc). This works for the other dimensions (Time and Value),
but the Object still rolls up, so that a non datamember is still the
sum of the children + the datamember.

Is this the way it should work? I would expect that without the
Calculate Statement, I should only get the figures that were actually
loaded to certain cells, i.e. that were in the source table.

I tried to set the Aggregate Funtion for the measure to none, but it
won't let be because apparently this is not possible for Standard
Edition.

I can work around it by first overwriting the
[Objects].[Object].Currentmember with it's datamember for the entire
cube. I was just wondering if this behavior is normal and that i'm
missing something or if it's a bug.

Regards,

John


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.