Answered by:
Multiple fact tables in SSAS 2005

Question
-
Answers
-
Are you talking about multiple fact tables as base for partitions or different measure group. In other words, are your fact tables have exactly the same structure? Or the structure is different and every fact table has it's own set of key columns?
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.- Marked as answer by Ed Price - MSFTMicrosoft employee, Owner Friday, May 1, 2015 10:06 PM
-
I do not have a link to an article.
If you are aware of the design in AS2000 you know that you can use one fact table in each cube. This is referred as a physical cube because it has an fact table tied to it.
On the other hand you can join two or more cubes(physical) in virtual cubes.
In AS2005(or SSAS2005) a cube can include one or many fact tables and each fact table becomes a measure group in this cube.
The concept of virtual cubes have disappeared in SSAS2005 but you can say that a cube with many fact tables(more than one) is a virtual cube in the old AS2000 meaning.
Most recent findings and post regarding using more than one fact table / measure group in SSAS2005 say that you should be careful about this.
Regards
Thomas Ivarsson
- Marked as answer by Ed Price - MSFTMicrosoft employee, Owner Friday, May 1, 2015 10:06 PM
All replies
-
Are you talking about multiple fact tables as base for partitions or different measure group. In other words, are your fact tables have exactly the same structure? Or the structure is different and every fact table has it's own set of key columns?
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.- Marked as answer by Ed Price - MSFTMicrosoft employee, Owner Friday, May 1, 2015 10:06 PM
-
I do not have a link to an article.
If you are aware of the design in AS2000 you know that you can use one fact table in each cube. This is referred as a physical cube because it has an fact table tied to it.
On the other hand you can join two or more cubes(physical) in virtual cubes.
In AS2005(or SSAS2005) a cube can include one or many fact tables and each fact table becomes a measure group in this cube.
The concept of virtual cubes have disappeared in SSAS2005 but you can say that a cube with many fact tables(more than one) is a virtual cube in the old AS2000 meaning.
Most recent findings and post regarding using more than one fact table / measure group in SSAS2005 say that you should be careful about this.
Regards
Thomas Ivarsson
- Marked as answer by Ed Price - MSFTMicrosoft employee, Owner Friday, May 1, 2015 10:06 PM