Other countries.Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports. 7.6.1 Creating a trigger node in Query Builder. Query Builder queries for BusinessObjects This simple webapp can be used to query your. Cisco Ethernet Switch Ios For Gns3. To find users are all logged in to Business Objects at a given.

Query Builder is a web application to query Business Objects repository. It provides information which can’t be found in Central Management Console (CMC). BusinessObjects deployment repository made up of set of tables to hold the information about the BI content such as universes, reports, users, schedules, etc. These tables are encrypted in such a way that the information stored in these tables cannot be readable using conventional SQL query tools. Query Builder gives the opportunity for the Admin/developer to query the metadata stored in the repository. Why you may ask, because users, auditors may ask some questions with data not ready available.

Like what reports were updated since start of the year, categorise reports by kind, number and names of recurring reports etc How to access Query Builder To access the Query Builder, in the Internet browser of your choice type the following URL: SERVER]:[PORT]/AdminTools/querybuilder/ie.jsp Log on as an Administrator to get full access to all the repository objects. Query Builder Objects There are 3 main objects: • CI_INFOOBJECTS: Covers folders, reports and other content consumed by the end user • CI_SYSTEMOBJECTS: Covers servers, connections, users, and user groups.

Hi All, This is the continuation of my previous blog related to Business Objects Query Builder. We are going to see some of the Query builder queries that I used real time in my experience. To get all the documents created by user named ’Mani’ SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND=’Webi’ and SI_AUTHOR=’Mani’ 2. To return list of Web Intelligence documents that have a name starting with “Annual” and are scheduled SELECT SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND=’Webi’ AND SI_NAME LIKE ‘Annual%’ AND SI_RUNNABLE_OBJECT=1 3. To extract list of Web Intelligence documents that are scheduled in a specified period of time SELECT SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND=’Webi’ and SI_RUNNABLE_OBJECT=1 and SI_NEXTRUNTIME between ‘2010.07.08.09’ and ‘2010.07.08.11’ 4.

To return all report folders containing a string SELECT * FROM CI_INFOOBJECTS WHERE SI_NAME LIKE ‘%Service%’ AND SI_KIND=’Folder’ 5. To returns all Universe folders containing a string SELECT * FROM CI_APPOBJECTS WHERE SI_NAME LIKE ‘%Sales%’ AND SI_KIND=’Folder’ 6. To see what type of rights you have for your BO software SELECT SI_NAME from CI_SYSTEMOBJECTS where SI_NAMEDUSER=0 AND SI_KIND=’User’ 7. Lavanya - June 24th, 2011 Hi Mani, Thx for the reply. Is there any way that I can extract the instances information which has the SI_destinations as attachments. We actually send out all our reports via email with either a hyper link or attachments to the users.

I understand that we have SI_SMTP_ENABLEATTACHMENTS as true for attachments. But I would like to know if there is any way to extract only the said column for the SI_Instance=1 in the repository.

I have around 100,000 instances and to retrieve the SI_Destinations for all these instances is taking very long time in Query Builder. I would appreciate if you can provide me some idea. Beginning C Through Game Programming By Michael Dawson Pdf. Thanks, Lavanya.

Lavanya - June 17th, 2011 Hi Mani, Thx for the reply. Is there any way that I can get the start time and run time of the instances? I checked the SI_UPDATE_TS, SI_CREATION_TIME, these are wrt the report creation time and modified time. But I am looking at the instance level. Is there any way that I can get this information? We are actually moving from r2 to 3.1 and we do not want to migrate the older instances beyond 3 years. So that's the reason why we are checking thru the query builder as to how many instances does each report have per folder.

Thanks, Lavanya. Manikandan Elumalai - June 16th, 2011 Lavanya, Query Builder output will be displayed within a predefined format and you can’t expect it as you require. For your requirement (Folder ->SF ->Rep ->Instances ->Seagull Bartender Professional 10 0 Crack. Recurrence pattern) the first 4 columns can be queried within a single virtual table (i.e.) CI_INFOOBJECTS and are related with each other by parent/ child relationship like our Employee/Department. The recurrence pattern can be extracted from Scheduling Info of each instance.