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,
No comments:
Post a Comment