Business Intelligence with SAP Business Objects 4.3

BusinessObjects Environment assessment using Query builder This includes identifying unused BI content (Users, Universes, reports,etc.). We are going to see more in detail about identification of unused objects using Query Builder in this document.   Let us see how to identify unused objects in each category listed below     1. User Community          a. Users not logged in for the past 6 months             SELECT TOP 1000 SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS            WHERE SI_NAME NOT IN ('ADMINISTRATOR','GUEST') AND SI_KIND='USER'           AND SI_LASTLOGONTIME < '2013.06.30' ORDER BY SI_NAME          b. Users who never logged in to system              SELECT TOP 1000 SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS            WHERE SI_NAME NOT IN ('ADMINISTRATOR','GUEST') AND SI_KIND='USER'             AND SI_LASTLOGONTIME IS NULL ORDER BY SI_NAME          c. Users not in any gr

Business Objects Query Builder Among Business Objects tools there is an application named Query Builder which can be used to query the Business Objects Meta Data repository in order to collect more information and details about your  Business Objects reporting system. Its url is: http://BOserver:port/AdminTools/ How to create a query Queries are created in a language SQL like. Unlike Sql language there are not a lot of functions supported (like nesting SQL statements, the GROUP BY clause or the DISTINCT function). Below the possible functions in Query Builder within the different clauses of a query are described: (SELECT, FROM, WHERE, ORDER BY). Some examples behind: A list of the Id and Name of all universes SELECT SI _ID, SI _NAME FROM CI _APPOBJECTS WHERE SI _KIND = 'UNIVERSE' Total num ber of Web Intelligence Reports SELECT COUNT(SI _ID) FROM CI _I NFOOBJECTS WHERE SI _KIND = 'WEBI ' A list of 10 0  Crystal Reports with all properties SELE

On converting a unv universe in unx format in Indormation Design Tool with a generic error after tracing IDT we found the following error and solution: Checking integrity from Information Design Tool shows an error parsing expression: ambiguous object path Environment:  BI.4 - Information Design Tool - SP 5 on Windows Server 2008 R2 Cases: When a dimension and a filter has the same name in Information Design Tool, the Check Integrity returns an Ambiguous Object Path error. Or After converting the universe from UNV to UNX the check integrity gives Ambiguous Object path error. The issue is resolved on Support Package 5 with Patch 1 or Support Package 6. See Also: http://businessobjectsbi4.blogspot.it/2013/09/sap-bi-40-errors-list.html

How to publish an Unx from Information Design Tool (SAP BI 4.0) In order to publish an UNX Universe  go to  Local Project  Select the .blx you want to publish  (right click)   do the check integrity  first  then select Publish in the repository as you can see in the following image: Read also Universe on Sap Hana