Relationship between fact table and Main table in ssas RRS feed

  • Question

  • Hi Expert

    I am unable to create a relationship between fact table and main table in ssas ,Its giving error:source column name and destination column name have different data type. i have already check the datatype in both table and its same.

    Saturday, May 14, 2011 5:06 AM

All replies

  • Are you using query binding for partitions of this fact?, if so check the query that you are using and if it is having appropriate output types.

    Thanks & Regards, Rahul Algude
    Monday, May 16, 2011 9:04 AM
  • Hi Rahul


    I am not using query binding for this partition .What i am using is Table binding.




    Monday, May 16, 2011 5:08 PM