Hi,

maybe anybody could help me with this?

In my sales cube, I have a date dimension with levels year, quarter,
month and day.
The granularity of my fact data is day but our forecast is on a monthly
level so
I have a fact table line with the whole month value set to the first of
the month.
I would like to equally spread the forecast on each day of the month so
I'm
doing something like (yearmonth is a hierachy in my date dimension):

freeze(valuetype.plan, date.yearmonth.month.members);

scope(valuetype.plan, date.yearmonth.day.members);

this = date.yearmonth.currentmember.parent /
date.yearmonth.currentmember.parent.children.count ;

end scope;

I now had the (perhaps naive?) hope that AS would perform this
calculation due to freeze only if
my querys touch the day level but by switching on and off the
calculation i recognize a significant
performance difference even if I analyze on a monthly or higher level.
Can anybody tell why?

Thanks Peter