Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dependency of a saved filter

Received Response
11
Views
5
Comments
3592346
3592346 Rank 1 - Community Starter
edited Aug 13, 2024 5:53PM in Oracle Analytics Cloud and Server

Hi All,

1)we have one saved filter name xyz. I want to know which reports are using this saved filter xyz. i just want to do an impact analysis.

2)we have one dashboard page xy21. I want to rename that page to xy22. Here i want to find which reports navigating to this page xy21 from other dashboards.

Thanks,

Somi R Chinta.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    If you look into SampleApp 607 you find few scripts which extract data allowing you do that that kind of analysis...

    The idea is to search in the catalog (a XML search) the paths of the objects (your filter or your dashboard page), and there you get the list as OBIEE always use full absolute paths to link things.

    For example if in the catalog manager you do a XML search and replace and search and replace the same exact thing (to avoid destroying your catalog) and you use the full path to your dashboard page or filter you will get the list of the objects where a replace has been done (the important part here is: replace the path by the path itself or you better have a backup).

    You can also use webservices to get the catalog objects XML and search there inside yourself.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    On 2 if you use the option to keep references to the original name then other dashboards etc navigating in will still work, it is after all possible that people are landing on your dashboard from other systems.

  • 3592346
    3592346 Rank 1 - Community Starter

    Thanks Gianni,

    i will try the scripts in SampleApp 607.

  • 2709444
    2709444 Rank 3 - Community Apprentice

    Sorry to open a closed thread that has been marked answered. But, I would like to know if the question 1(Impact Analysis) can also be achieved by those scripts available in Sample App?

  • 3592346
    3592346 Rank 1 - Community Starter

    Catlog xml search will helps us to find the list of impacted reports.