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+?
I guess this blog by Thomas and Mani would answer your question and would help you explore CMS DB as well.
We plan on moving to 4.2 SP 3 next year, but we are currently on 4.1 SP 7.
I don't think there is any other way to decode CMS database except going through Query Builder.
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
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
