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 relationship, and I want to make it 1 way.

But I'd like to see all the reports that currently make use of this relationship, so I can use them for testing.

 

Is there some way to get the list of reports that currently utilize this relationship?

Need Help

4 Replies

  • 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).

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi rsderidd 

    I don't think there are any automatic processes to check the list of reports that will break.

    You have to follow few steps
    Once you have the list of reports liked with Dataset
    Take a backup of the dataset
    Create a separate version modify the changes and publish.
    Check which reports are not working as expected.

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


    Thanks
    Pijush