Hello Lin
What tools are you using to model your data and build your OLAP cube? If I
were building a cube which required data from 15 fact tables which only
differed in that they contained a different years data, I would model the
15 tables so they appeared as one using something like Cognos
Lin,
I've had mixes results but you might have better success. As John mentioned,
there are a couple factors that you need to take into account.
How much data are you talking about (physical size and number of rows). I know
you say 15 years of data but is that 100's of millions of rows?
At 09:49 AM 4/29/2009, you wrote:
Hi
I have a table that stores huge rows in 15 years, now we have to do some
analysis about these row in Time dimension.To gain performance,at begining,
i've extrait the data according to years from my DB to build my fact table.
But since I have 15 fact tables,
