none
multiple fact table and dimensions RRS feed

  • Question

  • Hi,

    I have 2 fact tables and 2 dimensions (one of them is time).

     

    fact1  ---- pk-fk ------ fact1-details-table

    (date)                        |

       |                           Dimension.

       |

    TimeDim

     

     

    Is there a way to define measure group on  fact1-details-table using TimeDim. Date info is only in fact1 table and not in details table.

     

    Is namedquery joining the 2 fact tables the best solution in this case? There is so much redundancy using one fact table, so underlying sqldb uses 2 tables.

     

    Thanks,

    Chandra.

    Thursday, May 22, 2008 1:05 AM

All replies

  • Try to edit Named query and join there tables. The result will be one fact table with time dimension
    Thursday, May 22, 2008 8:24 AM