Hi all,

I have some questions about how to approach various problems on SSAS:

1. Measures in a specific cube (day-by-day evolution data) are only
valid at leaf level of Time dimension (eg. Date). At Month or Year level the
aggregations are not making sense. Which is the best way to instruct the
SSAS not to deal at all with the non-leaf cells for Time dimension, meaning
not only to have Null values through a script calculation, but also not to
execute any aggregation for Month and Year ?
Showing LastPeriod values at month or year level is not a
requirement.
In the calculations, the script

(Time.Month) = Null;
(Time.Year) = Null;

will end up with Null cell values for Month and Year, but the
processing will skip the aggregations for Month and Year attributes ? For a
large cube, i hope for a processing time saving here. Should i consider
semi-additive measures ? How ?

2. In the cube calculation script there is a Calculated Member with a
complex formula. Among the news in SSAS 2005, there are persisted
calculations. Considering that changing the formula is not the first option,
can i use this new feature to actually persist (meaning store, right? ) the
calculation before users start using it ? How ?

Thanks a lot,
rud