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