Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Posts
    97

    Unanswered: Cube with more that one facts Table

    Hello,

    I made an illustration, that describes the szenario. There is one Master, one dimension and a second facts table. The Master Table holds up all objects. Sometimes I have additional Information for some objects in Master Table. They are stored in extra tables like the table Optional_facts_for_villas.

    My question: How can I combine these two fact tables in Cube Designer without doing a Full outer Join in my Database?

    The reason why I want it this way, not all optional_fact_tables are necessary now for OLAP, but maybe later. So, I thought, easiest way would be, adding them later to the cube, without changing the database.
    Sorry for my english, its not the best

    Silas
    Attached Thumbnails Attached Thumbnails tables.jpg  

  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    You forgot to mention which version of SQL Server you are using. As far as I remember this should be possible by using SQL Server 2005, but not SQL Server 2000.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  3. #3
    Join Date
    Mar 2007
    Posts
    97
    Ok, it's 2000. I think I will use the full outer join

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •