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

Err_WIS_30270 While exporting in Excel a report Webi Environment XI R3.1 SP 4 This problem happened to an user which received a report WebI in the In box  when she tried to export it in xls format. Resolution We edited the advanced rights on favorite folder of this user as the rights to export in csv, pdf and xls were not specified and then in her case not allowed! So we granted them under WebI Report Content  as you can see in the following figure!

Cannot see connections in Report Conversion Tool Environment SAP BI 4 SP 5 In order to solve this problem I inserted the BO server name and its IP  in Hosts file under: C:\Windows\System32\drivers\etc Read also: BI 4 - How to download webi rich client Webi XI 4 - Changing query data source Sap BI 4 Webi-connecting to Bex query SAP BI 4.1 Supports SAP BusinessObjects Desktop Intelligence 3.1 SP6 FP 6.1 in viewing mode Disable automerge dimension on WebI X 4.0

How to download Webi Rich client in SAP BI 4.0  The Web Intelligence Rich Client can be installed from the BI Launchpad: In  BI Launchpad s elect Preferences  Select Web Intelligence.  Click on the (installation required) hyperlink next to Desktop or Desktop (Windows only).