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 |
|
MorrisK
Yak Posting Veteran
83 Posts |
 Posted - 2008-05-15 : 16:21:44
|
| I'm diving into Analysis Services. I'm looking at tables in the sample db, foodmart 2000.mdb.I've noticed that most of the sample fact tables are specific to a year, for example sales_fact_1998 and inventory_fact_1998. There is at least one that is not - expense_fact. It has information that spans more than one year.My question is this - if I'm going to have a fact table that spans years should I also periodically remove old records and archive them somewhere else? For example, keep 2007 and 2008 data and put 2006 data in it's own fact table by itself? Just looking for ideas. Thanks,Kevin |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 21:43:43
|
| Not really, depends on how you build cubes and how big the table is. You can partition fact table and cube for each year. |
 |
|
|
MorrisK
Yak Posting Veteran
83 Posts |
Posted - 2008-05-16 : 12:21:34
|
| Thanks for the reply. Unfortunately, I'm only on SQL Server Standard Edition. BOL says "You can create multiple partitions in a cube only if you install Analysis Services for Microsoft® SQL Server™ 2000 Enterprise Edition." I tried it to confirm.Since I don't have this ability does this change your response?Also, I'm using a single server which contains other production databases and I expect the table to initially contain 220,000+ rows.Thanks,Kevin |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-17 : 17:04:14
|
| Fact table is not that big, should be ok with single cube. |
|
|
|
MorrisK
Yak Posting Veteran
83 Posts |
Posted - 2008-05-28 : 09:38:42
|
| Thanks again.Kevin |
|
|
|
|
|
|
Fact table strategy