Is there are way to get the list of reports data and the column details used in reach report

Abhilash Kothakonda

I want the list of reports using XYZ column. We used to get this in Onpremise installation from Catalog, but i am unable to export the list of reports and their path and details of those reports.

Dimple-Nagesh-Support-Oracle

Hi There,

Please try the download the list of reports from the below link in the Documentation:

https://www.oracle.com/docs/tech/sales-reports.xls

Hope this helps

Shalini-Kumari-Support-Oracle

sales-reports.xls

Hello,

Thank you for posting about OTBI Reports

Please review the attachment. It contains list of Sales and Incentive Compensation Analytics.

Hope it helps.

If my response has answered your question, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

Regards,

Shalini Kumari

Abhilash Kothakonda

Hi Shalini,

I want to know the list of reports which are present in our catalog.

I dont want the lost of OOTB reports. So please understand the requirement properly and share us the details else will raise an SR.

Without giving any solutions, you are closing the SRs. I will share this in social media about the oracle support the way they are dealing the SRs. If you cannot offer solution, dont sell the products. I already told you that, this was present in previous versions, but now you didnt give option to download the required details. Ask you development team to provide this.

Thanks,

Abhilash.K

Dimple-Nagesh-Support-Oracle

Hi Abhilash,

We understand your concern, but CATALOG MANAGER still offers an option to download custom reports as per your requirement.

Catalog Manager is a Client Tool which you have to download from Oracle and setup your environment to create a report on the specific catalog folder. More details on how to download and use : https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/start-catalog-manager-and-open-catalogs.html#GUID-65D7594D-6F3D-4AD8-9002-F9A2C4503A03

Once downloaded, install the Oracle Analytic Catalog Manager and follow the below steps to Open Your Catalog :

1. Open Catalog Manager, from the File menu, select Open Catalog.
2. Complete the necessary fields, as described in the following list:

• Type — Select Online.
• URL — Enter the URL in the following format:
• https://hostname/analytics-ws/saw.dll
• User — Enter the user name for the host URL.
• Password — Enter the password for the specified user.
• Locale — Select the locale.

View Only Mode — Select this field to open the catalog in view only mode.3.Click OK.

Sample report from Catalog Manager is attached below where in I tried pulling below fields : "Column"   "Name"   "Owner"   "Path"   "Subject Area"

The report looks like:

Hope this helps.

Thanks

Dimple Nagesh

Abhilash Kothakonda

I am talking about OTBI cloud. I want the same feature on OTBI cloud. We are using OSC, please check our environment and let me know whats need to be done to download the reports.

I want the same output from OTBI.

Thanks,

Abhilash.K

Nathan CCC

Have you tried to archive a snapshot of the catalog in OTBI, then unarchive it to a local instance of the same version of OBI that you have installed on your own machine on-premise (like a virtual machine on your laptop), then use catalog manager to report?

Dimple-Nagesh-Support-Oracle

Hi Abhilash,

As per the cloud policies, SAAS customers will not have RPD access, but to get the column name and the list of custom reports as per your requirement, you can still use Catalog Manager.

I downloaded : Oracle Business Intelligence Developer Client Tool (12.2.1.4.0) using below link : https://www.oracle.com/br/middleware/technologies/business-intelligence-v12214-downloads.html

and follow the instructions on how to download and use : https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/start-catalog-manager-and-open-catalogs.html#GUID-65D7594D-6F3D-4AD8-9002-F9A2C4503A03

You can see the sample which I have provided in my above thread

Hope this helps.