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

Can we create OBIEE connection pool information as a BI Report

Received Response
1
Views
2
Comments
3292571
3292571 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:46PM in Oracle Analytics Cloud and Server

We are trying to create a report to know which subject area is pointing to which environment.

So trying to create a OBIEE connection pool information as a BI report. Does this data be stored anywhere on server or table where we can use for building report.

Connection pool information as a BI Report

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Not directly.

    The info is only available in the RPD, and the idea of "which subject area is pointing to which environment" is not as simple as you write it as a subject area come from a single business model, but the business model can use physical sources coming from multiple connection pools and of different kinds (federation of DB with a cube for example), so it's a 1-to-N relationship between subject area and environment.

    But you can extract these informations in few way, by webservices and probably also by the query repository tool, generating the metadata dictionary or even executing LSQL queries and "process" the result to connect pieces.

    So it's doable, require some work and not as simple as "creating an analysis on an existing source somewhere".

  • 3292571
    3292571 Rank 3 - Community Apprentice

    Thanks Gianni for the info.

    I will try to look into generate metadata dictionary using query repository tool and see what type of data is present there and move forward.

    Thanks