Skip to Content
0

Is there official documentation that shows the CMS database schema?

Dec 22, 2016 at 05:30 PM

263

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Kuldeep Ghosh Dec 22, 2016 at 08:04 PM
1
Show 3 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0

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

0
Dell Stinnett-Christy Dec 23, 2016 at 04:59 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Manikandan Elumalai Dec 22, 2016 at 06:12 PM
0

Here you go. This is in BI42sp3

Share
10 |10000 characters needed characters left characters exceeded