Oracle Analytics and AI

3292571

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

Gianni Ceresa

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".