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

Where are OBIEE analysis reports physically stored?

Received Response
124
Views
4
Comments
Dennis Hancy
Dennis Hancy Rank 5 - Community Champion
edited Aug 13, 2024 6:07PM in Oracle Analytics Cloud and Server

In our OBIEE environment, we have a number of analyses created.

Where are these physically stored?  Mostly I am asking for documentation purposes.

I can see the list in the OBIEE application itself; but let's say I wanted to copy this list to Excel or notepad.  How would I go about doing that?

I haven't been able to find an "export" option anywhere, so I thought maybe it's stored in Unix somewhere?

Thanks!

Dennis

Answers

  • nm.Mani
    nm.Mani Rank 6 - Analytics Lead

    Hi

    Using Catalog manager, you can do this. Tools utility in Catalog manager actually helps you to export a report in csv with selected set of analysis/agents....

    Check this,

    http://www.oracle.com/technetwork/middleware/bi/documentation/bieqt-1911962.pdf

    Configuring and Managing the Oracle BI Presentation Catalog

    https://docs.oracle.com/cd/E23943_01/bi.1111/e10541/prescatadmin.htm#BIESG1374Thanks

    M

  • Dennis Hancy
    Dennis Hancy Rank 5 - Community Champion

    Thanks!

    Now all I need to know is the User and Password.  I'll do some more digging around the office.

    Thanks again.

    Dennis

  • Gianni Ceresa
    Gianni Ceresa Mod

    @nm.Mani pointed you in the right direction.

    Of course everything is stored in the filesystem, but you are never supposed to put your hands at that level, just because there are lot of metadata related to every single object in the OBIEE catalog which is managed and make sense only for the app and not at the filesystem level.

    As said the Catalog Manager, which you installed with the Admin tool, allows you to make exports and also reports with lists of objects and some properties etc.

    Having access at the filesystem level doesn't give you a lot as filenames aren't exactly the same name you see online, there are more folders than what you see and lot of info stored as binary into the .atr file (do not even try to edit these files by hand or you can already look for the backup you will have to restore).

  • Gianni Ceresa
    Gianni Ceresa Mod 
    3022965 wrote:
    Now all I need to know is the User and Password.

    For OBIEE?

    Ask the guy who installed it or the one who manage it, easier

    There are chances it has been integrated with your corporate LDAP / AD, so same user/password you already use for other things (assuming it's not just a sandbox).