locked
linking dim to fact RRS feed

  • Question

  • Can I link a dimension to the fact using non key attribute column in the dimension?
    MG
    Tuesday, September 20, 2011 8:21 AM

All replies

  • A regular dimension relationship between a cube dimension and a measure group exists when the key column for the dimension is joined directly to the fact table. This direct relationship is based on a primary key–foreign key relationship in the underlying relational database, but might also be based on a logical relationship that is defined in the data source view.

    Can you explan your business scenario?

     

    Wednesday, November 9, 2011 12:12 PM