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

Is there a way to export the search results (name, path, etc.) to excel or csv file?

Accepted answer
59
Views
5
Comments
Betty.ca
Betty.ca Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Hi,

I am using the Search icon in the catalog manager toolbar. How can I export the search results as a excel file with the name and Folder path?

image.png

Best Answer

  • Betty.ca
    Betty.ca Rank 3 - Community Apprentice
    Answer ✓

    Thanks everyone. I would say all the answers are great. The server is OAS however I used 12c catalog manager. I need to learn new feature of the OAS.

    Actually the Tools→Create Report works. It is base on the selected search results rows.

    Search→Select all the rows, go to menu Tools and Create Report, has to create the report by type, save as xls format.

    image.png

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Betty.ca - Try creating a report with content needed in catalog manager following steps below:

    1. From the Tools menu, select Create Report.
    2. Select the catalog object type for which you want to create a report.

    Then save it in excel format.

  • Betty.ca
    Betty.ca Rank 3 - Community Apprentice

    Thank you Sumanth. But it is not the answer I want. I want a list with 'Preemp' included in the xml. That's a long list like hundreds of files.

    image.png
  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hi @Betty.ca ,

    With current functionality, you cannot export the search results as a excel file with the name and Folder path.

    I searched the Ideas Lab for similar requests and do not see any so you could log a new Enhancement Request via the Ideas Lab by following the steps in the KM Article:

    How To Create An Enhancement Request In Idea Lab For Oracle Analytics (Doc ID 2662737.1)

    Regards,

    John

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi @Betty.ca ,

    That "search" feature is actually a "virtual" feature that does loop over all objects of the catalog, apply your filter criteria on every single one and see if it matches or not.

    There isn't a webservice method for search (the Catalog Manager is a GUI on top of the catalog webservice), there isn't a search if you use the CLI of Catalog Manager.

    Because of all that, your only options I see are:

    a) raise an idea as suggested above

    b) code the little piece of code doing the search by looping over the content via the webservice

    If you decide for a), I would say you better not expect your idea to ever be implemented. Why you may ask? Because the graphical interface of Catalog Manager is gone! In OAS 2024 there is no GUI anymore, it's only command line. https://docs.oracle.com/en/middleware/bi/analytics-server/whats-different-oas/index.html

    What product are you using? Because that's also a factor: a new feature will not be added to a old product, but if you are on OAC or plan to follow the releases of OAS, you could turn the idea into asking an export feature for the Content Management page in DV > Console.

    If you go for b), pick you favorite language and start calling the webservice: https://docs.oracle.com/middleware/1221/biee/BIEIT/methods.htm#i1009936 (older doc, but the WSDL didn't change between OBIEE 12c and OAS/OAC).