Skip to Content
avatar image
Former Member

Is there official documentation that shows the CMS database schema?

Dec 22, 2016 at 05:30 PM | 307 Views

I've spent quite a while searching through community questions, official SAP documentation, and other BI blogs, but can't seem to find any official documentation showing the CMS database schema.

The closest I found is on the wiki:

https://wiki.scn.sap.com/wiki/display/BOBJ/How+to+browse+CMS+repository

This is of course outdated and refers to only the following:

Product versions:
BusinessObjects Enterprise XI R2
BusinessObjects Enterprise XI 3.0
BusinessObjects Enterprise XI 3.1

Is there anywhere that lists the schema either via text or diagram from SAP for 4.1+?

SAP BusinessObjects Business Intelligence platform
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Kuldeep Ghosh
    Dec 22, 2016 at 08:04 PM

    I guess this blog by Thomas and Mani would answer your question and would help you explore CMS DB as well.

    https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+BI+4.2+SP3

    https://blogs.sap.com/2016/09/02/my-first-look-at-cms-database-data-access-driver-bi-42-sp3-new-feature/

    Add comment
    10|10000 characters needed characters exceeded

    • Kuldeep Ghosh Kuldeep Ghosh
      Dec 23, 2016 at 06:12 PM

      Try and use this sql against your CMS database. See if you get any help

      select objectid, parentid, LastModifyTime, replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(translate(replace(substr(objname,1,instr(objname,'!;')),'BE','.'),')+-/13579;=?ACEGIKMOQSUWY]!"{','ABCDEFGHIJKLMNOPQRSTUVWXYZ'), '`|>','1'), '`|@','2'), '`|B','3'), '`|D','4'), '`|F','5'), '`|H','6'), '`|J','7'), '`|L','8'), '`|N','9'), 'M|N','_'), 'M|Z','-'), '@',' '), '`|<','0'), 'B~P','/'), 'M}Z',':'), 'B|C','('), 'B|D',')'), 'B~K','@') as Decoded,typeid, decode(typeid,1,'Folder',262,'WebI',314,'DeskI',266,'Universe',299,'Connection',342, 'Word',323,'PDF',336,'Text',285,'Excel',324,'PPT',20,'Group',16,'Service',24, 'License',typeid) objtype from CMS_INFOOBJECTS6

  • avatar image
    Dell Stinnett-Christy
    Dec 23, 2016 at 04:59 PM

    You shouldn't directly access the database. Most of the relevant information is in a Blob field and you'll need to use either Query Builder, a program written with one of the SDKs, or, for 4.2 SP3 and newer, the new universe that's available here: https://archive.sap.com/documents/docs/DOC-74580.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Manikandan Elumalai
    Dec 22, 2016 at 06:12 PM

    Here you go. This is in BI42sp3

    Add comment
    10|10000 characters needed characters exceeded