 |
 |
Archives of the TeradataForum
Message Posted: Thu, 11 Apr 2002 @ 12:26:12 GMT
| Subj: | | What is the difference between Database cubes and Reporting Cubes |
| |
| From: | | Rohit Revo |
I need some clarity 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??
Also most of these tools connect using database API's (making them faster) like Microstrategy and Teradata V2R4.
Why this question on a Teradata forum? Well I wanted to see what we are loosing because of the non availability of MOLAP option in
Teradata.
| |
