Archives of the TeradataForum
Message Posted: Thu, 11 Apr 2002 @ 12:26:12 GMT
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.
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023