Aggregations from Middle of Hierarchy

Hi everyone,

Does AS2005 aggregate based on a hierarchy if the lowest grain of the fact is in the middle of the hierarchy?

For example, I have a standard date dimension (with hierarchy of year, quarter, month, week, date). My sales data is at the lowest level (date). I have target sales data on a month level. If I map the target sales data to the dimension with the month ID and query at the year level, will the data return information from the pre-aggregations?

Thanks for any thoughts!

Jessica

If you've actually built the aggregations on your target sales measure group, and you've set up your attribute relationships correctly, then the fact that the granularity attribute (ie Month) is not the same as the key attribute (ie Date) shouldn't matter. But it all depends on whether you've built the right aggregations and set up your attribute relationships correctly... for more information on how to do this, take a look at:

http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!907.entry

and the AS Performance Guide:

http://www.microsoft.com/technet/prodtechnol/sql/2005/ssas2005perfguide.mspx

HTH,

Chris