BusinessObjects Board

BO Repository table relationship

general discussion
#1

Hi,

Can anyonce able to guide or explain for the table and field relationship in BO Repository Data Mart for version BO XI R2?

The list of table name as:

  1. Application_Type
  2. Audit_Details
  3. Audit_Event
  4. CMS_Aliases5
  5. CMS_IdNumbers5
  6. CMS_InfoObjects5
  7. CMS_Relations5
  8. CMS_VersionInfo
  9. Detail_Type
  10. Event_Type
  11. Server_Process

Thanks

Onn

onnonn (BOB member since 2003-11-03)

#2

The ones that start with CMS are for … well, the CMS. You will NOT be able to use these tables directly. See this post … Querying the CMS … for an explanation. The remaining tables are used by the auditing function. The schema is explained in the Auditor guide available (along with all documentation) here. That said, there is already an audit universe built for these tables included in the default installation.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#3

Do you know which document has the schema for CMS tables ?
Thanks in advance.

zack :us: (BOB member since 2007-08-02)

#4

As Dwayne indicated, you CANNOT query the CMS tables directly. Most of the data is stored in a proprietary format in BLOB fields. Follow the link he provided in his post for information about how to get to the data that’s in the CMS tables.

-Dell

hilfy :us: (BOB member since 2007-04-16)