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.
Tagged:
0