Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 09:12:24 GMT

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

Subj:   Re: Real-time OLAP
From:   Robert Doss


It is possible, but not simple to use Microsoft Analysis Server to do this. The product gives you a few possible architectures that can be used to do it.

I have helped put together architecture and implementations at a couple of Teradata sites that could support this - but since the data is sourced from the operational system to Teradata on a nightly basis we update the multidimensioal (MOLAP) database right after the nightly data warehouse load. If the data warehouse were updated more frequently we could gear up the MOLAP update cycle to match it. The multidimensional databases have current and historical transaction state history almost to the detail level.

There used to be a white paper on MSDN that described a ROLAP architecture for doing this - I did a quick search and couldn't find it - it had a title something like 'Real Time OLAP'.

If you would like more details please contact me off-list.


Bob Doss

  <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: 28 Jun 2020