Oracle Analytics Cloud and Server

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

Categories

How to identify all analyses using a filter that is based on the results of another analysis

Received Response
3
Views
4
Comments
user11394838
user11394838 ✭✭✭
edited August 13 in Oracle Analytics Cloud and Server

How can I identify all analysis in the catalog that contains a filter that is based on the results of another analysis? Due to limitations on TimesTen, we need to remove all instances of the filter based on another analysis functionality completely.

Answers

  • Christian Berg-0racle
    Christian Berg-0racle ✭✭✭✭✭

    Either search the catalog using the catalog manager tool for the reference to the filter, do the search on the physical files in the file system or use SampleApp as a starting point and run the scripts needed for the "Webcat Analysis" dashboards for the Lifecycle&Admin part: http://slc02okg.oracle.com:7780/analytics/saw.dll?dashboard&PortalPath=%2Fshared%2F10.%20Lifecycle%20and%20Admin%2F_port…

  • user11394838
    user11394838 ✭✭✭

    Hi Christian


    Thank for your reply! It is not a single or named filter I'm looking for, rather a type of filter. I need to identify all instances of the use of filter type "based on the results of another analysis". It doesn't matter what the name of the filter is or where it is used, just that it is being used. I have a huge catalog and need to identify all the analyses that I need to go into and remove/alter the filter based on the result of another analysis.

    Catalog Manager only tells me if it is an Analysis or a Filter, not which type of filter is used inside the analysis. Or am I missing something?

  • rmoff
    rmoff ✭✭✭✭✭

    As @Christian Berg said: 

    do the search on the physical files in the file system

    From a quick test I think you want to be searching for <saw:filter><sawx:expr xsi:type="sawx:subQuery". Assuming you're on Linux, the grep would be: 

    oracle@demo:SampleAppWebcat () $ grep --files-with-matches --recursive '<saw:filter><sawx:expr xsi:type="sawx:subQuery"' /app/oracle/biee/instances/instance1/SampleAppWebcat
/app/oracle/biee/instances/instance1/SampleAppWebcat/root/users/prodney/filter_test
/app/oracle/biee/instances/instance1/SampleAppWebcat/root/shared/demos+marketing/es5_3
/app/oracle/biee/instances/instance1/SampleAppWebcat/root/shared/demos+marketing/es5
/app/oracle/biee/instances/instance1/SampleAppWebcat/root/shared/demos+marketing/es5_2
/app/oracle/biee/instances/instance1/SampleAppWebcat/root/shared/06%2e+dashboard+design/prompts/indirect+prompting/results+report
/app/oracle/biee/instances/instance1/SampleAppWebcat/root/shared/10%2e+lifecycle+and+admin/webcat+statistics/dependency/analysis+to+dashboards+lookup

    From this you can identify the affected analyses.

  • user11394838
    user11394838 ✭✭✭

    Exactly what I needed, thank you!!!