system
February 14, 2012, 4:43pm
#1
Can anyone help me w/ find a post that had all sorts of examples for the “Query Builder” functionality.
I know someone spent the time providing numerous SQL statements for querying the CMS.
If someone could provide that post url it would be greatly appreciated. I tried searching before posting this…
steelz09 (BOB member since 2011-06-22)
system
February 14, 2012, 4:49pm
#2
Hi,
These topics can help:
Hi
Can somebody help me to understand what is mean by Query Builder in BO and where can I find it and its uses?
Thanks.
stvel (BOB member since 2007-10-04)
Hi
This post is a list of CMC queries, i.e. queries that can be executed using the Query Builder tool, that I use most often.
If anyone else has some useful queries then reply and add them to this topic - hopefully we can build up a good library of CMC queries!
List of all user groups
SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_PROGID='CrystalEnterprise.UserGroup'
or
SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'UserGroup'
List of all folders
SELECT * FROM CI_INFOOBJECTS WHERE SI_PROGID = 'C…
I have compiled a list of queries that will get some basic information out of the CMC. I'm trying to figure out how to run more complex queires to get all the reports that I need.
here is the initial list. feel free to add queries.. Thanks
Get All Webi reports
Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_PROGID='CrystalEnterprise.Webi' And SI_INSTANCE=0
Get Full Client Reports
SELECT SI_ID, SI_NAME,SI_FILES FROM CI_INFOOBJECTS WHERE SI_KIND in( 'webi' ,'FullClient')
Get All report…
Marek Chladny (BOB member since 2003-11-27)
system
February 15, 2012, 4:22pm
#3
Thank you.
I can’t believe SAP doesn’t have a tool that allows you to “export to excel” data like:
What users are in what groups
Which reports are tied to which universes
Query Builder is the best option but I wish I could get this data to a web-i report so I can publicize / schedule it to other users.
steelz09 (BOB member since 2011-06-22)
system
February 15, 2012, 4:31pm
#4
Hi -
We (Infolytik) actually provide a free, light-weight Universe + driver that plugs into the CMS and allows query and reporting of the CMS repository directly via Webi - a fairly good Query Builder replacement.
You can download it from here:
Hope this helps -
Atul
Atul Chowdhury (BOB member since 2003-07-07)
(BOB member since 2003-11-27)