Oracle Analytics Server Repository Database Question — Oracle Analytics

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

Oracle Analytics Server Repository Database Question

Received Response
51
Views
6
Comments
dilek
dilek Rank 6 - Analytics Lead
edited Aug 13, 2024 5:15PM in Oracle Analytics Cloud and Server

Hi,

I have a question on OAS repository database. Is there any table on repository database including catalog manager data. For example, list of analysis (classis side) or projects (dv side) done. Or, source tables of analyses? If there is, my goal is to make a dynamic catalog management report.

Thank you for your interest.

Regards,

Dilek

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    The whole catalog is stored there in the BIPLATFORM schema.

    Don't have a DB accessible now, could maybe be the CSS_IS tables.

    Just remember: you aren't supposed to be there, SELECT isn't going to damage anything, but avoid changing things without using the official tools (catalog manager etc.).

    Everything is possible, the content isn't much different than what the catalog is like for many many years.

  • dilek
    dilek Rank 6 - Analytics Lead

    Thank you for your answer @Gianni Ceresa It really helped a lot. Actually, our need is accessing catalog objects automatically. As you know, from catalog manager, we take a snapshot (Create Report). We want to find unused reports / dashboards etc. We want to track our system utilization.

    Regards,

    Dilek

  • [Deleted User]
    [Deleted User] Rank 5 - Community Champion

    System utilization is best checked via Usage Tracking. You will find there a list of all objects accessed / queried.

    As Gianni said you should stay away from the DB table sand rather use standard APIs.

  • dilek
    dilek Rank 6 - Analytics Lead

    Hi @Christian Berg-Oracle ,

    Thank you for your additional comment. What I want to say is not usage tracking, I want to find non queried reports. For example, analysis & dashboards that are not used, how many reports are created etc. Is it possible via usage tracking?

    Regards.

  • [Deleted User]
    [Deleted User] Rank 5 - Community Champion

    UT shows you what's used. A catalog manager shows you what exists. If you have both data sets in DB tables you can simply run queries on those two data sets and do a minus. That gives you a good idea.

  • Gianni Ceresa
    Gianni Ceresa Mod

    What you are after requires both sides as Christian said. The catalog doesn't tell you anything about usage but can only tell you if an object exists or not. On the other side UT only tells you about objects being requested, not if one exists or not.

    Combine both and you get the full picture. Just like Sample App 607 does (they where using runcat.sh to get the catalog side of the story).