Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Removing a Relationship

Hello

 

We have datasets linked through a semantic model. The semantic model is linked through an SQL to our underlying software. I have created a relation between two tables. I am unable to delete the relationship, as it is greyed out, but I created it!

 

Very confused.....

 

 

Any help is appreciated!

 

James

Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Hi Anonymous ,

     

    Depends where you have created the relationship, because if the relationship was created on the desktop you should be able to remove it, if it's coming from the original semantic model them you have to do it online.

6 Replies

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Hi Anonymous ,

     

    Are the relationship  coming from the semantic model or the SQL server ?

    If the relationship is from the semantic model to delete it you need to go to that semantic model delete it, you cannot edit the semantic model "locally".

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello Miguel

       

      Thank you, I suspect this will be the answer. I did not know I could not change locally. Useful to know you can add but not delete.

       

      James

      • MFelix's avatar
        MFelix
        Super User
        2 years ago

        Hi Anonymous ,

         

        Depends where you have created the relationship, because if the relationship was created on the desktop you should be able to remove it, if it's coming from the original semantic model them you have to do it online.

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi Anonymous - you can select the checkbox so that we can do modification on the top of the relationships

     

    Blue color box check that and modify the relationship

     

    Hope it works

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thank you! I should have said in my post what I had tried already. I attempted to click the box, still no joy.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello

     

    In that case I do not know what the error is, I did add the relationship on the desktop, it isn't part of the original semantic model but now it seems to be!!

     

    James