You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL Query for Data Model objects from OTBI

Summary:

I am looking to perform a SQL query of Data Models from within OTBI and need to know which table to query.

Content (please ensure you mask any confidential information):

I am looking for the table in which Data Model objects found in OTBI would be stored.

I know that the GL_FRC_REPORTS_B table stores BIP Report data from OTBI, among other data.

I am also looking to be able to write a SQL query to pull the Data Models associated with BIP Reports in OTBI, so that ideally both BIP Reports and their associated Data Models could be pulled in a single SQL query. Ideally this would derive from the ApplicationDB_FSCM schema.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!