![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
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.
| |