Question on granularity of OLAP cubes

Hi. all experts here,

Thank you very much for your kind attention.

As we all know one of the most significant benefits of OLAP cubes are to preaggregate the data based on different levels of the OLAP cubes. Therefore, in order to optimize the query performance against the huge OLAP data source, we can design the granularity for a OLAP cube and when necessary we can refer back to the underlying relational database sources. But the question here is: Is there any best practices on granularity of the OLAP cubes?

Hope my question is clear for your kind advices and help.

And I am looking forward to hearing from you shortly for your kind advices and thanks a lot in advance.

With best regards,

Yours sincerely,

Hi Helen,

U need to go through with OLAP Design Best Practices for Analysis Services 2005 or Data Warehouse Design Considerations

Bhudev

Question on cube granularity again

Hi, all,

Again, I wonder is it a good idea to design the granularity level of the cube as the same as in its underlying relational database e.g the most detailed level as it is in its fact table and its dimension table.

I am looking forward to hearing from you for any advices.

Thanks a lot in advance.

With best regards,

Yours sincerely,

It really depends on your requirements. I would say you probably should make the granularities the same unless it's going to cause serious performance problems with the processing and/or querying of your cube - it just means you have all the data your users might want available. Changing the granularity of your cube once you've gone into production would also be a bit messy.

Chris

|||

Hi, Chris,

Thanks a lot for your advices. Very good point.

With best regards,

Yours sincerely,