Forum Discussion

initpro's avatar
initpro
Regular Visitor
10 years ago

Copy relation from one table to another

Is there a way to copy the relations from one table to another table. I have a few filtered tables with the equal table structure and like to use the same dimension tables.   thanks for your suppo...
Need Help
BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
10 years ago

What do you meany by this? can you please elaborate and if possible post a data model.

  • initpro's avatar
    initpro
    Regular Visitor
    10 years ago

    I have one table t1 which includes data from different section.

    This table has a lot of relations to other tables.

    My filtered table t2 based on t1 and should have the same relations to the other tables.

     

    therefore I am asking for a convenient way to relate these tables

     

     

    • BhaveshPatel's avatar
      BhaveshPatel
      Icon for Super User rankSuper User
      10 years ago

      You can use Autodetect feature for relationships to be automatically defined. 

      For more information, Please refer to this documentation from microsoft here.

       

       

      Thanks & Regards,

      Bhavesh

       

       

      • initpro's avatar
        initpro
        Regular Visitor
        10 years ago

        thanks for the hint.

        I know this feature but even I let to detect auto relation then also other relations are made with no sense.

        It would be fine to autodetect relations onle from tables of my choice.