Thanks a lot Valek,

that was really helpful.

there are lot many aggregations and so have decided to go for an MOLAP storage.

I would take your advice on this and...