We would like to use Query Builder to detect changes to the universe, such as a new object added, or one removed. We do not have access to the SDK. My thought was to get a list of all objects and put it in an MS/SQL tabe. Then, at a later time, get another list, put that data in another MS/SQL table, and compare the two. I’ve been playing around with Query builder but can’t find a query that will pull this type of information and also could not find a manual on the SAP site that documents the data available to do this.
We have a remote-hosted BO solution, and don’t always get the details of changes to the universe we are using.
I don’t think you ca do use through query builder. You d have a couple of choices:
Buy a product called version manager from ebiexperts.com. It is a version control tool that allows comparisons of universe and will list ALL changes.
Run the code on this site that Dwayne create on BOB downloads. This is a universe documentation tool that exports the metadata to excel. Then you can compare the two excel files.
Johnathan, thanks for the info. Do I have to have direct access to the BO server to use Dwayne’s code? The reason I ask is that we have a remote-hosted BO solution, and only have Citrix access to the following:
Designer
Desktop Intelligence
InfoView web page
Admin web page
AS long as you have designer installed you will be able to use the code. From memory, I think it is just an excel spreadsheet that pops up with a form that you enter the login details
(BOB member since 2008-05-08)