Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spdhiva
Starting Member
13 Posts |
 Posted - 2006-10-13 : 16:00:50
|
| Hi,I have a cube(s), Which holds 10 years worth of data and I have a Harizondal partition tables by year. Each year table has 25 Mil rows.I created cube with DISTINCT function along with 20 Dim tables. I have 8 Partition by year and Qtrly partitions for the latest 2 years.I couldn't create any Aggrigation due to memory issue. If I creates even 50 Agg and I get 'Out Of Memory' error message. So, I kept 0 Agg and Processed the cube. When the users try to browse the cube through excel and It takes lot of time to pull the data and Somtime it hangs.Am I doing anything wrong?Is there any other way to improve the Cube browser perf?Note:I stored the snapshot of all the Customers by monthly along with their status on each year.Example:Name Date StatusCustomer1 01/01/2006 ActiveCustomer1 02/01/2006 ActiveCustomer1 03/01/2006 ActiveCustomer1 04/01/2006 ActiveCustomer1 05/01/2006 ActiveCustomer1 06/01/2006 ActiveCustomer1 07/01/2006 ActiveCustomer1 08/01/2006 ActiveCustomer1 09/01/2006 ActiveCustomer1 10/01/2006 ActiveI have 2 mil customers status for past 10 years.Any help would be Appreciated. |
|
|
|
|
|
Cube Perf issue with Excel