I was wanting to create a report - maybe based on activity universe and/or a freehand SQL query based report on the auditor tables.
Could anybody please guide me as to what tables to refer and/or what objects would be preferable to be used.
I would like to get the number of WebI Reports and the number of DeskI reports in the BO XI 3.1 system. I was able to find the report for BO XI R2 version.
Even if I need to refer the Auditor part of the BO XI 3.1 Admin guide, I can. Please let me know. Thanks a LOT!!
Thank you Sebastien!
I am trying to query the CMS from the Query Builder. Once I get a good enough query, I can go ahead and write a Free Hand SQL based report right? Now that I am trying to write the query on the CMS, I am looking for information on the relationship between the various tables in the CMS.
I am looking at places where I can get the relationship diagram [ER diagram] for the BO XI 3.1 CMS. If anyone knows it, it would be of great help! I will reply on this post in case I get any.
I tried looking at an earlier post which gave a report [probably in BO 5.x] which mentioned about the retrieval of count of WebI documents and DeskI documents in the repository. It was a FreeHand SQL.
Can I be able to write a similar query in BO XI 3.1?
[quote:9063a238ab=“avinash.phenom”]I tried looking at an earlier post which gave a report [probably in BO 5.x] which mentioned about the retrieval of count of WebI documents and DeskI documents in the repository. It was a FreeHand SQL.
Can I be able to write a similar query in BO XI 3.1?
[/quote]
No, you can’t. The structure of the BO repository in BO 5.x, 6.x versions and BO XI versions is completely different.
Furthermore, data in the BO repository of XI and higher versions is encrypted. You can’t query tables directly, you would get nothing. You need to use either Query Builder to get a meaningful data or you need to use SDK to retrieve any usable information out of the BO system database.
It’s also worth noting that we’ll be releasing CMS/Connect CE (Community Edition) in the coming weeks that will provide all the bread-and-butter querying as has been typically performed through Query Builder and SDK, but using our native real-time CMS driver - free of cost. This should relieve many installations that have been frustrated so far with quality CMS reporting.
I will try to look for either Query Builder and/or SDKs as you have mentioned for getting the information out. I would also be looking forward to the CMS Connect mentioned by Atul.
(BOB member since 2010-06-07)
(BOB member since 2003-11-27)