Post reply

Data Modeling Question

  • January 7, 2009 at 7:39 am

    #204719

    I have 2 tables from a relational database (an orders table and an invoice table) that I loaded into 2 fact tables (OrdersFact and InvoiceFact). Both fact tables share the same dimension tables (DimSaleRep, DimArchitect, DimProduct, DimTime, DimRegion, DimCustomer).

    There are architects in the DimArchitect table that are associated to orders and architects in the dimension table that are associated to invoices. Most architects are associated to records in both fact tables. That is, not all architects in the DimArchitect table are associated to the OrdersFact table and not all architects in the DimArchitects table are associated to the InvoiceFact table.

    Does anyone see a problem with this? Do I need separate dimension tables for the architects? I want one SSAS cube for both fact tables. Any problems with this?

    Thanks.

  • January 8, 2009 at 6:12 am

    #923245

    I don't see any issues with that setup.

  • January 8, 2009 at 10:26 am

    #923516

    Thanks, Frank.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply