Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Apr 2002 @ 12:26:12 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


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.



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023