none
Create key for dimension using 2 columns

    Question

  • Hello,

    I have table which unique id are two columns. For example:

    A    B

    -1   1

    -1  -1

    2    -1

     

    In the fact table these columns also appear. I would like to ask if it is possible to create dimension in SSAS using these two columns or I have to create real unique one column.

    Wednesday, February 01, 2012 6:28 AM

Answers

  • Yes but i would suggest to create physical primary key by including both column if possible otherwise you can also do by logical in DSV .

    Mukesh
    Wednesday, February 01, 2012 7:35 AM
  • Yes you can, In data source view set these 2 columns as logical primary key. And relate these columns to fact.

    Thanks

     

    Wednesday, February 01, 2012 7:15 AM

All replies

  • Yes you can, In data source view set these 2 columns as logical primary key. And relate these columns to fact.

    Thanks

     

    Wednesday, February 01, 2012 7:15 AM
  • Yes but i would suggest to create physical primary key by including both column if possible otherwise you can also do by logical in DSV .

    Mukesh
    Wednesday, February 01, 2012 7:35 AM