Business Intelligence with SAP Business Objects 4.3

Version Management feature in the lifecycle management console The lifecycle management console tool enables you to manage versions of BI resources that exist in the SAP BusinessObjects Business Intelligence platform repository. It supports both Subversion and ClearCase version management systems. Let see  how to use the Version Management feature in the lifecycle management console tool. In order  to  create and/or manage different versions of an infoobject, follow the below directions: Log into the lifecycle management console - LCM In home page, select Version Management from the drop-down list. Enter the login credentials, and click Login, then the Version Management window appears. If you want to change the host system click on the 'Servers' icon and Login with different credentials. From the left panel of the "Version Management" window, select the folder to view the infoobjects whose versions you want to manage. Select the infoobjects and cl

Talking about Open document there are several features that changed in the new Business Intelligence platform 4.0. changed compared to XI R3.1 version. Let's see some hints: The default URL to the OpenDocument web application bundle has changed in SAP BusinessObjects Business Intelligence platform 4.0. New absolute OpenDocument links need to use the new default URL: http:// : /BOE/OpenDocument/opendoc/openDocument.jsp? & &...& Below you will see a lists of deprecated and obsolete OpenDocument parameters as of SAP BusinessObjects Obsolete parameters are no more supported. sIDType=GUID    ->  Use sIDType=CUID instead. sIDType=RUID     ->   Use sIDType=CUID  instead. sKind                    -> Use iDocID instead.          Specifies the SI_KIND property of the target                                                                        Desktop Intelligence document. sPath                              sPath does not support the use of lo

SAP BO DASHBOARDS 4.0   Servers In SAP Business Objects BI 4, BO Dashboard has been integrating in CMC management (auditing and monitoring included) as concerns the management of two new servers: DashboardDesignCacheServer DashboardDesignProcessingServer which support better performance and scalabilty. the first server provides data caching and sharing while the second manages query processes requests A great new feature of SAP BO Dashboard 4.0 is provided by the direct connection to a Universe trough a Query panel , the user interface is like WebI one so objects like dimensions and misures can be selected directly, besides you can apply filters,  sorts, prompts and you can preview the query data. The query  browser panel enables the dashboard designer to manage query on the universe, displaying the summary of result obejects, prompts and filters for each query launched providing in this way a quick access to tool to create, edit and refresh queries.

How to prepare Excel spreadsheets Before you import an Excel spreadsheet, make sure the spreadsheet provides a good structure for achieving the best performance for models. Consider the following guidelines: - Use only supported Excel functions For a list of supported Excel functions, see Supported Excel functions . - Use these Excel functions with small data sets only The following Excel functions are supported in Dashboard Design and Presentation Design, but can affect the model's performance if used with larger data sets (over 100 rows): • SUMIF • COUNTIF • HLOOKUP • VLOOKUP Note: If you must access larger data sets, have the server or database perform the aggregation on the server side. - Organize your data in a logical fashion To make your spreadsheet easier to understand, lay out your data in a logical fashion. Group related items together and use colors, labels, and borders to describe the structure and function of cells. - Use colors

Lifecycle management console  in Business Objects 4.0 takes the place of Import Wizard tool in B.O. XI, so it's function is to transport new developing from developing B.O. enviroment  to production  enviroment. Let see GUI components in the lifecycle management console tool. The lifecycle management console tool home page is divided into the following panels: • lifecycle management console workspace toolbar • Workspace panel • Tree panel • Administrator and Details panel • Shopping Cart and Job Viewer page Promoting Overrides Promoting Overrides Through BIAR Files Using Lifecycle management console Promotion Job When you log into the lifecycle management console application, by default, you are taken to the "Promotion Jobs" page. The "Promotion Jobs" home page screen includes various tabs that you can use to perform the following tasks: • Select New Job to select job-related processes. You can also right-click the ho

The latest Business Objects Suite, B.O. 4.0,  is suitable for every kind of user from top managers to simple clerk. It has a new  styling and unified look and feel in every tool of the suite. It garantees common query design experience across all data sources. It allows interactivity with shared charting, alerting, and search options. B.O. 4.0  has a new information design tool for heterogeneous access over all sources that represents  abstraction layer for multi-dimensional data sources. Beside it allows: A simplified, Right-Scale Deployment Enhanced scalability with virtualization and native 64-bit support Comprehensive system diagnosis and monitoring New auditing for compliance and usage analysis. New User Experience SAP BusinessObjects Mobile BI  Interactive Reports & Dashboards Allows to: Make informed decisions with instant access to personalized information Leverage existing BI investments & skills to quickly reach mobile users E

In order to create a report Webi based on a  BEX query Longon in BI Launch Pad and create a new document choosing BEX as Data source: Select a BW Bex Query choosing the OLAP connection published before You will see the WebI Query panel on a BW Bex Query as in the following picture: Inserting object into the query and selecting prompt value: Read also: SAP BI 4 WebI - Connecting to a Bex Query with hierarchical data Webi 4 - Changing the query data source

USING OLAP IN INFORMATION DESIGN TOOL (SAP BI 4) Let see how to use Query Bex in Business Objects 4.0. Open Information Design Tool (IDT) and go to Connections  and open OLAP MIDDLEWARE DRIVER SELECTION as in the following image In order to open an olap connection on SAP Netweaver BI 7.x, choose the last BICS  connection: Insert Parameters for SAP Netweaver BI 7: Select the needed  Cube: Create the related connection: Publish connection in Repository: Read also: How to disable automerge demension on WebI 4 Webi 4 connecting to Bex query

SAP BusinessObjects BI 4.0 La piattaforma leader per la Business Intelligence si caratterizza per: o      Soluzioni semplici e dirette agli utenti finali o      Interoperabilità degli strumenti, definizione di template, condivisione tra progetti o       Nuovo strato semantico o       Console di amministrazione centralizzata per configurare il sistema o       Una soluzione per tutti gli utenti in una unica  piattaforma integrata o       Strumenti semplici ed intuitivi particolarmente  indicati per utenti non informatici o       Risultati immediati e progetti che crescono insieme           o       Unica piattaforma integrata per tutte le esigenze di BI. Le maggiori novità della nuova piattaforma:  Un' unica piattaforma per molteplici usi: Nuovo strumento per disegnare lo strato semantico - INFORMATION DESIGN TOOL: La nuova interfaccia utente dell' IDT: Una nuova feature  è il Query Panel all'interno d