Business Intelligence with SAP Business Objects 4.3

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).

SAP BI 4.0 Errors List scheduling error - source file error. [Invalid argument]: [CrystalEnterprise.DiskUnmanaged] ERR_WIS_30271 - Maximum binary output size limit reached QTJ 00511 - Circular references : check your @select and @where calls Parse Failed: Invalid Definition (UNV0023) Index is not ready. Please try again later (PSS 01004). Error qtj 00519 reference @select SAP BI 4 Converting Unv in UNX- IDT error ambiguous object path FWM 01003 Server Not found or it may be down Business Objects XI R 3.1 Errors