Business Intelligence with SAP Business Objects 4.3

Visual Difference SAP BusinessObjects  Business Intelligence 4.0  - Version 4.0 SP2 Fixpack 5 Features - Visual Difference framework allows easy identification of changes - Comparison plug ins and viewers for each BI content type. (Eventually…) - LCMBIAR viewer answers: “How is this version of the BI application different from a previous version?” - Future service packs will provide comparison viewers for universes and other content types - For example, will answer: “What is different between these two versions of a universe? Can I easily merge changes?” - Impact Analysis - Understanding which objects in a universe have changed allows tester to focus only on reports which use changed objects. See Also Visual Difference Overview

Lifecycle management console features SAP BusinessObjects  Business Intelligence 4.0  - Version 4.0 SP2 Fixpack 5 Lifecycle management console is now included in SAP BusinessObjects Business Intelligence servers install package. New Visual Difference capabilities allow easy identification of changes. Scriptable promotions supported via a command line interface. • Central Management Console– Visual Difference, Promotion and Version Mgmt. Lifecycle management is now in CMC: New Objects supported Categories based promotion is now supported. Server group promotion is supported however the servers are not promoted. LCM is now localized. • Job is copied • Job is migrated Update Source system of job when Overrides no longer job specific  Supports new improved BI platform Audit infrastructure There are 2 new features specifically for integrated deployments with BW: • SAP Authentication is now supported. • Integration with the SAP standar

LCMBIAR Overview - LCM Command Line Tool SAP BusinessObjects  Business Intelligence 4.0 Version 4.0 SP2 Fixpack 5 Allows to: Promote content between Development, Test, and Production SAP BusinessObjects BI 4.0 environments. Allows you to use scripting to automate the import of objects. Terms BIAR and LCMBIAR:   BIAR :(BI Archive) is a collection of any binaries associated with a BI object and its associated metadata, all materialized in a zip file. An LCMBIAR file is the same idea, but each object is stored in an individual BIAR. Considerations:  Lifecycle management tool is to promote objects from BI platform 4.x to BI platform 4.X version only.  Upgrades from a previous BO version to BI 4.0 must be done using the Upgrade management tool. To rollback a job you need to use the UI, not command line  LCM Command Line tool is not used when CTS+ is available. What can you do with LCM Cmd line tool?  Report developer creates LCM Job with cont

SAP NOTE 1634962 - BI4 - How to import or export a LifeCycle Manager BIAR file using command line utility If you need to export or import a Life Cycle Manager (LCM) BIAR in BI 4 using command line utility. Environment l SAP BusinessObjects Business Intelligence Platform (BI) 4.0 l SAP BusinessObjects Business Intelligence Platform (BI) 4.1 Follow these steps: 1. Create a Properties file: Start by creating a properties file (Example c:\lcm1.properties) as below. Note that the names of properties and lcmbiar files are not specific and can be anything. While the below examples are provided with Windows syntax, they are applicable to unix environments as well with minor changes to file path locations. Here is an example of a properties file to EXPORT to an lcmbiar file: exportLocation=C:/lcm1.lcmbiar action=export LCM_CMS=localhost:6400 LCM_userName=Administrator LCM_password=password LCM_authentication=secEnterprise Source_CMS=localhost:6400

Error: WIS 00504  Message: You do not have the rights to access data returned by this universe. See your business objects administrator  Non si dispone dei diritti di accesso ai dati restituiti da questo universo. (WIS 00504) Environment SA BI 4.0 SP 8 In order to solve this issue on refreshing a WebI  report check  user permissions at user/folder/object level Check   the access rights for all the universes and universe connections in this case for assigning rights to the user for Universe and connections, Login to CMC and go to Universes.  Select the universe which you are using,right click and select user security,check if your user has rights on that universe if not then use Add principals and assign rights to the user you are using.  Then go to Connections in CMC and select the connection which your universe is using and follow the same thing as done for Universes.  Moreover  on the rights tab and for the user/group  on the Access Level drop down, ch

Invalid Prompt definition. See your Business Objects administrator. (Error: WIS 00005) Environment BI  4 SP 8 Cause The syntax in the prompt is not valid, or the prompt makes reference to an object that no longer exists in the universe. Action The universe designer can verify that the prompt syntax is correct, and check that all objects referenced in the prompt exist.

 WebI Rich Client XI R3.1 Environment XI R3.1 SP 4 When we try to open an imported reports  in Webi Rich Client, BO raises the following Error Code WIJ 20002 Error Workaround: Log in  Web Intelligence Rich Client. Go to Tools > Options Go to Locale (tab) and set "Interface locale" and "Formatting locale" to English (United States) > OK. Open a report in Web Intelligence Rich Client it runs ! See Also XI R 3.1 errors solutions

In order to refresh the structure of the universe in the Information design Tool Open the Data Foundation  Click on detect button and select Refresh Structure as you can see in the following image See also Publishing Universe with IDT

Circular references : check your @select and @where calls (QTJ 00511) Environment BI 4 SP 8 Cause An @Select or @Where call in the script refers to itself. This is not allowed. Action Check the declaration of the @Select and @Where calls and correct or modify the script. See also: Sap BI 4.0 errors list