SAP BI Platform CMS extracts

[zjaffary]

Hello,

I need help with extracting data from the CMS database. Specifically, I am looking to get information on all Connections, Documents, Schedules, Universes, and Users to generate reports. I have tried using the Query Builder, but I found it less user-friendly. I came across \SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Samples\BI on BI, but I couldn't find any documentation on how to use the information in it.

Can you please provide me with some useful information? I would like to know how to utilize the JAVA SDK or the BIONBI Connection (BI platform CMS system database.cns) and Universe (BI platform CMS system database.unx). Additionally, do you have any sample Webi reports on top of this UNX?

Thank you.

[rajdeep_marathe]

You can use the CMS DB driver, https://me.sap.com/notes/2369779 

[DellSC]

As far as I know, all of that information is available in the BI on BI universe.  I don't currently have access to a BOBJ system, but I will have tomorrow.  I'll also see what I can find for sample reports for you - I have a few.

-Dell

[zjaffary]

Thanks, Dell. Awaiting your reply.