Is there official documentation that shows the CMS database schema?

[Former Member]

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+?

[DellSC]

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

[former_member198519]

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+B...

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

[Former Member]

We plan on moving to 4.2 SP 3 next year, but we are currently on 4.1 SP 7.

[former_member198519]

I don't think there is any other way to decode CMS database except going through Query Builder.

[former_member198519]

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

[former_member182521]

Here you go. This is in BI42sp3