Archives of the TeradataForum
Message Posted: Thu, 05 Dec 2002 @ 23:02:04 GMT
I had a similar issue with Oracle Express, we were recalculating 30 Gigs every night but our load window was only 2am-6am. With Express it is really easy to connect across multidimensional databases (the variables are essentially like views in an RDMBS). We started recalc'ing the existing data at 5pm with the new dimensions. We had a separate db that loaded only the most recent day's data when it became available at 2am, it would only take 20 minutes to run. You'd need a db for each time increment, so it's not continuous update. Essbase has some net change rollup capability too, but I've never played with it.
You could connect data on the front end. With Business Objects you can run a report that hits both an Essbase cube and an rdbms. You'd have rolap performance on the rdbms piece, but if it was a small "net change" table it might not be bad.
Finally, a Teradata aware rolap tool (Microstrategy) might not be bad as long as you're not trying to pull an enterprise view. You could do the same "net change" trick on Teradata, have the previous days aggregates stored in one table and load the new day's changes into another, combine them in a view using "union all".
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|