Forum Discussion

rsderidd's avatar
rsderidd
Frequent Visitor
2 years ago

Find the reports that use a relationship

Hello,   I want to make a change to one of the relationships in my model.. however I want to make sure I don't break any reports that use the current relationship. Right now, its a bi directional ...
Need Help
PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi rsderidd 

Please on the Dataset in the workspace
Then see the open Lineage view
It will show the all reports are using this dataset.
That means, it this dataset is used, the same relations also are in use. You have to check all reports before making any changes in relation.


If solved your requirement, please mark this answer as SOLUTION. appreciate your KUDOS 👍 ⬇️

Thanks
Pijush

  • rsderidd's avatar
    rsderidd
    Frequent Visitor
    2 years ago

    I know about the lineage to see all reports that use a dataset.. But imagine hundreds of reports that use a dataset.  I want to make a change to 1 relationship. I want to know which reports I need to test, after making that 1 change.  Likely only a couple reports of the hundreds, actually use that specific relationship.

    • Brunner_BI's avatar
      Brunner_BI
      Icon for Impactful Individual rankImpactful Individual
      2 years ago

      Measure Killer can show you that. The only thing you need to do is either download the dataset and all reports that are connected to it (and use the free version of the tool) or buy the paid version so the tool will find all connected reports automatically.

       

      Inside the output it will show you exactly which columns from which reports are consuming a certain relationship (or column).