Hi all,
just one small question: Is there any way to create a universe on CMS to make reports out of CMS information. Right now we need to get information about all Design Studio Bookmarks. No problem in Excel, but how to use it in a WebI document?
thx
Florian
fschwaiger (BOB member since 2016-08-25)
SAP have just released one as part of 4.2 SP3
It uses a new data access driver see http://scn.sap.com/docs/DOC-74580
Hayden_Gill 
(BOB member since 2002-08-15)
many thanks… unfortunately we installed recently SP2… 
fschwaiger (BOB member since 2016-08-25)
Ok, I just checked the universe. Unfortunately that is not too much we can do (only si_infoobjects is used as far as I can see). So maybe we have to stay on the Excel tool for the moment.
fschwaiger (BOB member since 2016-08-25)
SAP is treating the new CMS universe and data connector like they did the new Audit universe that’s available here: http://scn.sap.com/community/bi-platform/blog/2015/07/15/unlock-the-auditing-database-with-a-new-universe-and-web-intelligence-documents-for-bi41. They’re basically crowd-sourcing testing and requests for new features through the blog and they’ll continue to develop it with customer assistance until it’s ready to add to an official release.
This worked VERY will with the audit universe, so I’m very hopeful this one will be as robust as that is.
-Dell
hilfy 
(BOB member since 2007-04-16)
Did you start using this tool and if so any comments or pros\cons you wish to share.
We do not use anything and wondering if this Bolton is worth looking into… 
BOETL2012 (BOB member since 2012-08-27)
Wait, there is an actual universe for the CMS in 4.x where you can actually see detail stuff!?
Hmmm, is the information worth it though, that is the question?
di652 (BOB member since 2005-02-24)
It only works with 4.2 SP3 and future releases. But yes, it’s worth it. It doesn’t have all of the information I get from the SDK code I’ve written, but it provides a lot of good info and it gets better on a regular basis.
-Dell
hilfy (BOB member since 2007-04-16)
I am assuming than that Auditor needs to be turned on.
Can I ask how are you leveraging it to help you service your environment?
di652 (BOB member since 2005-02-24)
The BI on BI (“CMS Universe”) does not need auditing to be turned on to work.
It accesses the CMS subsystem (using APIs that translate contents of the CMS database repository (e.g. CMS_InfoObjects7) tables.
Some of the data is similar to the audit DB’s data, some of it, not so.
Basically, the CMS Universe will give what we call “shallow” metadata (folders, document names, owners, scheduled instance properties, create/update timestamps (updated as per CMS update NOT human-updated – although often the same ; no SQL/universe objects+filters+derived table SQL or other “deep” metadata as we call it – that’s still only accessible via some audit data but mostly through APIs)
HTH
Atul Chowdhury (BOB member since 2003-07-07)
If you are on 4.2 SP03 and want to use the new CMS universe, be aware that patch 5 “uninstalls” the driver (it won’t show up under SAP connections when you try to create a new connection). I’ve heard patch 6 corrects that.
charlie (BOB member since 2002-08-20)
Does anyone else have this universe working in 4.2 SP4? I imported the universe and configured the connection but I get the following error when trying to create a new query:
while trying to get the length of a null array loaded from a local variable at slot 53 (Error: INF )
Interestingly I can see valid data using Values from List when I drag a dimension into the Query Filters pane . I also imported the set of sample webi docs and they give the same error. Maybe I’m doing something wrong.
clarence (BOB member since 2005-11-18)
Our 4.2 SP04 instance is also missing the folder that contains the CMS driver. There should be a CMS folder under [install folder]\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer.
charlie (BOB member since 2002-08-20)