I have a confusion in my mind about MDDB servers.
Why do we need a MDDB server like Oracle Express, MS Analysis Server, Hyperion Essbase, et all. I can understand the advatages of basic things like aggregation, pre summarised data, faster access, cube related security features, building and storing multiple cubes, etc but there is also a cost involved in terms of pushing the data physically to a MDDB server (ETL,/code).
But we can get the same features through a reporting cube, which also gives MOLAP or ROLAP, perhaps at a much less cost!! And if scalability of cubes is the problem, we can also build multiple reporting cubes. Also, one more thought, even if we have a MDDB server, we may still need these OLAP tools and then again build a cube in them. Isn't this sort of duplication and extra work??
Why do we need a MDDB server like Oracle Express, MS Analysis Server, Hyperion Essbase, et all. I can understand the advatages of basic things like aggregation, pre summarised data, faster access, cube related security features, building and storing multiple cubes, etc but there is also a cost involved in terms of pushing the data physically to a MDDB server (ETL,/code).
But we can get the same features through a reporting cube, which also gives MOLAP or ROLAP, perhaps at a much less cost!! And if scalability of cubes is the problem, we can also build multiple reporting cubes. Also, one more thought, even if we have a MDDB server, we may still need these OLAP tools and then again build a cube in them. Isn't this sort of duplication and extra work??
