a month ago
How to access data in prod from QA Test system?
#Sap , # QA , # Prod , # Access
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.