Forum Discussion

initpro's avatar
initpro
Regular Visitor
9 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
Super User
9 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
9 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
    Super User
    9 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
      9 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.

      • HarrisMalik's avatar
        HarrisMalik
        Continued Contributor
        9 years ago

        initpro What is the reason of having a filtered table with exactly the same dimension tables? what you are trying to achieve?

         

        Regards

        Harris