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 |