none
Multiple fact tables in SSAS 2005 RRS feed

  • Question

  • Can someone please provide me with a link to an article, which explains the concept of multiple fact tables in SSAS 2005?

    Thanks in advance,

    Saurav

    Monday, July 24, 2006 11:15 AM

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.

    Tuesday, July 25, 2006 12:39 AM
  • 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

    Tuesday, July 25, 2006 5:43 PM
    Moderator

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.

    Tuesday, July 25, 2006 12:39 AM
  • 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

    Tuesday, July 25, 2006 5:43 PM
    Moderator