BO Query Builder not available : alternatives in SAP BO 4.1 ?

[former_member598933]

Hello.

I am trying to export to excel several lists of SAP BO users, groups, folders, connections, universes.

This information is available in the CMC but it is not possible to copy or extract it in an easy way.

I tried to access to Query Builder using the following URL and I got a (HTTP Error 404 : « the requested ressource is not available »)

https://<servername>/AdminTools/querybuilder/ie.jsp

Could you please help me to find a way to solve this http error or an alternative to Query Builder to read information from CMS database or Audit database ?

I am using SAP Business Objects 4.1.

Thank you very much for your kind replies.

Please see : access-to-query-builder.png

[ayman_salem]

the correct URL is:

http(s)://<servername>:<port>/AdminTools

[former_member230921]

You can achieve using SDK script (4.1 +) :

https://help.sap.com/viewer/0225aa3e7b4b4b17b2d4a882e6f2de96/4.2.6/en-US/45a7a73f6e041014910aba7db0e...

4.2 Sp03+ then you can use :

https://blogs.sap.com/2017/05/10/query-the-businessobjects-repository-using-bi-platform-rest-sdk-rws...

[former_member230921]

https://blogs.sap.com/2015/07/15/unlock-the-auditing-database-with-a-new-universe-and-web-intelligen...

[former_member598933]

Thank you all.

Does anybody know how to make QueryBuilder work? It seems that the setting of Apache Tomcat is not good inside Business Objects 4.1 but I suppose that the instalaltion of BO 4.1 is a default one.

Could anybody help me?

Thank you.

[former_member185603]

Unfortunately, you cannot export using query builder. But if you are in 4.2, you should be able to query the CMS universe. Since you are on 4.1, check this below link.

http://bukhantsov.org/2012/03/query-builder-with-export-to-excel/