Business Intelligence with SAP Business Objects 4.3

 HTTP 404 errors in Business Objects XI R 3.1 The HTTP 404 error may happen for one of the following reasons: 1. The requested page was deleted in error. Check the deployment folder of the web application to make sure that the requested page exists. 2. The web application is not properly configured. Try to access other pages in this web application. If there are other pages in this web application that are not accessible, then there is a problem with the web application configuration. Consult the web application deployment instructions to check that the configuration files are valid, or redeploy the web application. 3. A system setting is incorrect. For example, the memory limit was reached or an ODBC DSN was not correctly configured. As a result, an exception was thrown and the expected page was not generated. Check the web server log or the web application log for error or exception records. 4. An environment variable is not properly set. This environment variable ...

The last SAP Dashboards SP05 for Mobile (Ipad -Iphone) The last SP05 SAP Dashboards  allows going on mobile (IPAD)  through HTML5  With this last SP you can verify old dashboards you developed in order to use them on Ipad. In this version you cano select  the right size for an iPad screen (1024x768) Beside you have to check the components/parameters in order to verify that are supported for HTML5, this check  is easy to do through a new functionality  for analayze dashboards components compatibility panel. A plus is the chance to choose iOS compatible fonts (Arial, etc. – otherwise, the embedded browser will try to use the best font). Before exporting the reviewed dashboard you can preview it using the mobile viewer option to see how its layout on an iPad: you can choose between: - Fit to screen - Original size Finally you can export  to the server the dashboard and you can  open it  using the SAP Busine...

You can also create an BO Analysis OLAP connection with SAP HANA as provider. With this HANA OLAP connection, you can use Analysis directly on top of a SAP HANA database. Configuration for SAP HANA If you use the SAP HANA appliance software, you can analyze SAP HANA data sources with Analysis. If you use SAP NetWeaver Business Warehouse, powered by SAP HANA, you can analyze BW queries, query views and InfoProvider with Analysis. You can connect and use a BW system, powered by SAP HANA, like other BW systems with Analysis. You have the following options to connect to SAP HANA:  - You can use an OLAP connection to connect via SAP BusinessObjects Business Intelligence platform. This connection can be created directly in the CMC of the SAP BusinessObjects BI platform like BW system connections to the platform. The SAP HANA OLAP connections are currently not SSO compatible. - You can use a JDBC connection to connect via SAP BusinessObjects Business Inte...

You can use Analysis with SAP BusinessObjects Business Intelligence XI 4.0 or SAP BusinessObjects Enterprise XI 3.1   as the central content management system for Analysis workbooks  and presentations and as platform for managing data source connections. Before users can begin working with business data in Analysis, you have to create connections to BW systems so they can add data sources to their Analysis workbooks. You create new connection objects and manage existing connection objects in the module OLAP Connections in the Central Management Console (CMC) of the business intelligence platform. To create a connection to a BW system, you define a connection to any object of the BW system. You also have to make sure that the client PCs can communicate with the connected BW systems. If the BW system uses a message server the client PCs must specify the service name of the message server in the system services file at :\WINDOWS\system32\driver...

Cannot retrieve the document with the passed obsolete token. (RWI 00323) Cause An error occurred during document state deserialization. This might be caused by a storage token that identifies a document state, which is no longer available in the storage tokens stack. Action In the webi.properties file, increase the value of storage tokens stack size. Also, ensure that the storage token is valid before using it. In BO XI R3.1 environment this problem could be also fixed installing the latest fixpack/service pack. See also: BUSINESS OBJECTS ERRORS LIST

Connection failed. The server has reached the maximum number of simultaneous connections. (RWI 00239) Cause The maximum number of server connections allowed has been reached. Action Either raise the value of the maximum connections server parameter, or add another server instance. To modify the maximum connections value: 1. Log on to BusinessObjects Enterprise Central Management Console. 2. Click on Servers. 3. Expand Server Categories, and click on Web Intelligence. 4. Under Server name, double-click on WebIntelligenceProcessingServer. The Properties window appears. 5. In Properties window, under Web Intelligence Processing Service, enter a greater value for Maximum Connections. In our customer case environment BO XI R3.1 on windows server 2008 R2, with 4 cpu, 16 GB Ram and more then 300 BO users   we inserted a 100 connections value  and this value fixed the problem. See also: BUSINESS OBJECTS ERRORS LIST

Xcelsius provides an authentication mechanism that enables you to avoid logging into InfoView twice with the same session ID. Take note of following rules if you customize authentication: - An existing session ID is used only if the user name and password are blank (if they are not hard coded or not passed as input values captured by a dialog). This occurs when Query as a Web Service is running in InfoView or Dashboard Manager. - If the user name and password are not blank, then use these values to authenticate the user. No session is created. This is the most scalable scenario and is the preferred option for large-scale usage. - If there is no pre-existing session (and username and password are blank), Xcelsius displays the standard security dialog, in which a session is created. This occurs when Xcelsius designers do not build their own security dialog. See also: Consuming a query as a web service in Xcelsius How to start Query as a Web Service

To consume a query as a web service inside Xcelsius, use the Web Service Connector The Web Service Connector component allows a Flash document created in Xcelsius to communicate with Query as a Web Service through SOAP, using point and click. The Xcelsius Flash document is self-contained and communicates with the web service to display data visually. The only prerequisite is that there be a SOAP-based web service available to the Flash document. The Web Service Connector component, when activated, creates a SOAP-based message (basically an XML document) and sends it to the web service. The web service responds with a SOAP-based message of its own. The Web Service Connector component then sends this data to all the other components, resulting in a live visual representation of your data. There are many public web services available, and many different toolkits and packages for SOAP-based web services. To use public web services and packages that already have...

This kind of query  is useful because can be used it to consume data into Xcelsius Dashboards in alternative to connecting through Live Office. See: Sap BO Dashboards 4.0 - Xcelsius 2008 Query as a Web Service is used with a Central Management System (CMS) The CMS contains the server component that stores the Query as a Web Service catalog and hosts the published Web Services. When you start Query as a Web Service for the first time, you must define the host server before starting. Each successive time you start Query as a Web Service you select an available host server, then log into the CMS. Once you are logged in, the Query as a Web Service startup Query Catalog page appears.  From this page you can start the query creation and publication wizard to publish a new query and edit existing published queries. How To define a query in Publish as a Web Service Wizard The "Query" page of the "Publish as a Web Service Wizard" allow...

Tutorial  In order to activate auditing in BO XI R3.1 ( procedure it's similiar on BI 4 CMC ) you must follow these steps: Logon  into CMC Go to servers page Chose the BO server on which you want to activate auditing, for example let's open Web Intelligence server, and select WebIntelligenceProcessingServer click the right button in order to select: Audit Events here you will choose the events you want to audit The procedure is similar also on all the other Business Objects Servers you want to audit. For detail  about the new CMC BI 4 auditing page: CMC in Business Objects BI 4 - New features

SAP HANA Data Management You use the SAP HANA modeler , which is accessible as a perspective of the SAP HANA studio , for modeling and managing SAP HANA data . It allows technical users to create new or modify existing models of data. In addition, the initial configuration of the data replication is done in the SAP HANA modeler. Let see how to configure data replication to provide the necessary metadata and data to the SAP HANA box.  You need to perform the following steps: 1. Load table metadata from the data provider systems (source systems) into the SAP HANA database (target system) for all tables of the source system or for a subset of tables 2. Load data (initial load) from the data provider systems (source systems) into the SAP HANA database (target system) for a selection of tables 3. Start continuous replication of data changes from the data provider systems (source systems) into the SAP HANA database (target system) for a selected subset of t...

SAP Visual Intelligence  can Acquire data from different data sources SAP Visual Intelligence 1.0.6 You can acquire data from the following data sources: - C.S.V file - SAP HANA cube - MS Excel - Freehand SQL - SAP BusinessObjects Universe Each data source can be adapted before acquisition to include or remove columns. For certain data sources you have other options, for example data formatting, column naming and trimming, and specifying column name prefixes. The acquisition options are described for each individual data source. Note: For data that is acquired to manipulate locally the maximum number of cells that can be acquired is 15 million. Spreadsheets with more than this maximum are cut off at this point. Read also: Using SAP Visual Intelligence SAP Visual Intelligence SAP VISUAL INTELLIGENCE FEATURES SAP HANA Introduction

Environment: BO XI R3.1 SP 4 on WindowsServer 2008 R2 An error occurred during document utilization. This might be due to insufficient memory or an I/O error. Action Ensure that there is sufficient memory available. Also check for any webi.properties customization. That is: look for  ..: \Business Objects XI 31\Tomcat55\webapps\dswsbobje\WEB-INF\classes #WID_FAILOVER_SIZE=10 #WID_STORAGE_TOKEN_STACK_SIZE=10 #REP_FAILOVER_SIZE=10 – DeskI documents #REP_STORAGE_TOKEN_STACK_SIZE=10 >> Change all the values to 0 (no limit) >>Remove the # symbol - uncomment  More Intrusive solution  Add a request Timeout in the WebI and WebJob Servers (36000 for example)  Modify the CCM settings for Webi Server:  Add -port ServerIP  Add : -requesttimeout 36000  Modify -ns ServerIP After that restart Tomcat and all servers. See also: BUSINESS OBJECTS ERRORS LIST

In order to migrate  a universe from a prior CMS release (XI R3.1 and XI r2)  to a BI 4 CMS, you must use the Upgrade management tool  (UMT)  that is provided with BI 4. SAP Business Objects 4.0 BI 4 includes two universe development tools: - The universe design too l, which is an upgraded release of the Universe Designer tool you are familiar with if you are an existing Business Objects customer wich creates a UNV file . - and the new Information design tool (IDT) , which is the new universe authoring tool provided with BI 4 that produces a UNX file . A UNX universe file is published on the CMS  is the result of a merge of three components that are designed in the information design tool.: -  CNX files for connections -  DFX files for data foundations -  BLX files for business layers A UNX is the result of CNX + DFX + BLX where: the data foundation    (DFX )  contains a schema  of tables and joins f...

One problem you often have after Installing Xcelsius 2008 is that you can not open any more Excel file by double clicking on the Excel file, but you need before Excel application and from there you have to select and open the needed file. The solution to avoid this annoying  problem in MS EXCEL 2007 is going in OPTION -> Advanced -> removing the flag: 'Ignore other applications tha use Dynamic Data Exchange' as you can see in the following image The same solution is applicable also in MS Excel 2003 and we guess in all the other versions!

BusinessObjects Auditor  provides  a way to monitor and record key facts about your BusinessObjects Enterprise system.  The information provided by the auditor answers the following questions: - Who is using your Business Objects Enterprise system?  - Which objects they are accessing?  - Which groups within the company use our BusinessObjects system the most ?  - How many concurrent user licenses are we using at any given time?  Auditor also allows you to better administer individual user accounts and reports by giving you more insight into what actions users are taking and which reports they are accessing.  The Audit database contains  the following main  tables: Audit_Event  Audit_Detail  Server_Process  Detail_Type table  Event_Type  Application_Type  Follows the Activity universe graphic structure: Let's see what these tables contain: Audit_Eve...

SAP HANA - Additional Components In addition to the SAP HANA database , the following components are part of the SAP HANA landscape: • SAP HANA information composer • Lifecycle Management Tools • Unified Installer • SAP HANA UI toolkit for INA SAP HANA Information Composer The SAP HANA information composer is a Web application that allows you to upload and manipulate data on the SAP HANA database. The SAP HANA information composer uses a Java server which interacts with the SAP HANA database. The Java server communicates with the SAP HANA information composer client via HTTP or HTTPS. The following ports are used by default: • HTTP port 8080 • HTTPS port 8443 If HTTPS is used, the SSL certification must be configured by the administrator. Note: The SAP HANA information composer can be configured to use antivirus software. The SAP HANA information composer client is accessible to users who are assigned the IC_MODELER role. This role allows users to upload...

Export Failed  - [Deski XI]  Environment BO XI  R3.1  After having Imported Webi reports, folders,universe,connection and repository objects into a BIAR file the BIAR was created successfully, but connection import failed so we Deleted all my objects, folders, universe and connections from the BO server ,Exported successfully the BIAR file back into the BO server After  the Webi reports cannot be used since the universe connection is not available We redefined the universe connection and re-exported the universe  to the BO server so Webi reports work But we cannot export Deski reports to the server anymore - We get DX0034 error Problem solution on Deski open tools-> universes-> Refresh Perform the following sequence: Re-point the problematic reports.                                           - Go to Data menu à View data. ...

Error Message: Your Web Intelligence session has reached timeout. Log out and log in again to Infoview (Error : WIS 30553)  EnvironmenT BO XI R 3.1 SP4 After getting this error message we have been not able to use the same session to create the reports successfully. Solutions The timeout parameter in web.xml is for Infoview web application. Can you try changing Web Intelligence Server Timeout properties from CMC. CMC->WebIntelligence Server ->Properties. More complex solution for JSP increase the application session-timeouts for the web.xmls for the three application locations as follows: Business Objects XI 31\Tomcat55\webapps/WEB-INF/web.xml Business Objects XI 31\Tomcat55\webapps\InfoViewApp/WEB-INF/web.xml Business Objects XI 31\Tomcat55\webapps\CmcAppActions/WEB-INF/web.xml 2. Increase the attribute value under to perhaps 60 in this example:    20 3. To modify the default session timeout value in the CMC, search for web.config in ...

Working with SAP BI MOBILE Reports  Each document contains one or more reports. When you open a document, you can view the default report set by your report designer. If you want to view a specific report, perform the following steps: 1. Tap the document to open it. The Report screen opens. 2. Tap the Reports dropdown icon on the top left corner of the screen. 3. Select the required report from the dropdown list. This application provides you with a paging option to display multiple report parts that cannot be displayed on a single screen. The number at the bottom of the report indicates the number of pages contained in the report. You can browse and open a report part in full screen mode by performing the following steps: 1. Tap the page number at the bottom of the screen. The slider bar appears with a pointer. 2. Drag the pointer on the slider bar to navigate between pages. As you slide, the number changes to display which page you have navigat...

Defining  Web Intelligence Layout for Ipad Documents You must consider the following guidelines when designing the layout for Web intelligence documents to ensure they can be viewed on your iPad device. • Ensure a maximum of two horizontal report parts only. • Ensure proper spacing between report parts. • Consider the edges of the widest report parts as a boundary within which all other report parts must be aligned. Note: If you increase the length of report parts vertically in Web intelligence documents, the layout will not be reflected accordingly on the iPad device. The pages on the iPad device are rendered as described in the following image on the left: • If the document has only one report part or has one report part left on the last page, it appears as a full screen view irrespective of the formatting in the Web intelligence document If the document has two report parts or has two report parts left on the last page, the page is divided into ...

Error WIS 00003 - Some pre-defined filters are no longer available in the universe. See your Business Objects administrator. One or more predefined filters are no longer available in the universe. Predefined filters are condition objects that are predefined WHERE clauses. You use these to restrict the data returned in a query. Solution  Remove the predefined filters from the query, and manually create the same condition in the query by using the appropriate operators and operands. Exception case: In order to correct this problem the designer has renamed one  object in the universe   and has replaced it with the previous original name. This action has not solved the problem: The correct fix is to delete the new object in the last universe version, copy the filter  object from the old universe containing the original filter and  paste it into the current version of the universe. See also: BUSINESS OBJECTS ERRORS ...

Error WIS 00001 - Some objects are no longer available in the universe. See your Business Objects administrator One or more objects in a universe are no longer available to a document, because they have been deleted in the Universe. Solutions: If you have the old Universe backup ( containing the deleted objects nedeed)  you can publish it again otherwise delete the objects from the query that seem to be missing.  The available objects are listed on the Data tab. Rebuild the query without the obsolete objects. See also: BUSINESS OBJECTS ERRORS LIST

Universe Syntax Error This error message appears when special characters are used in object names, including: [ ] = & @ × $ % , ; ! ß £ ~ § μ + ' ( ) { } - There is no solution just: do not use special characters in object names. See also: BUSINESS OBJECTS ERRORS LIST

Transaction Log Based Data Replication Using Sybase Replication. This replication method is only recommended for customers that have been invited to use this technology during the RTC of the SAP HANA 1.0 product delivery. If you are not part of this RTC group, SAP recommends using Trigger-Based Data Replication Using SAP Landscape Transformation (SLT) Replicator because of the rich feature set this replication technology offers. The main components of this replication method are the Sybase Replication Agent which is part of the source system, SAP ERP, and the Sybase Replication Server which is to be implemented in SAP HANA. Replication Process in Detail The following image  details the data replication process and introduces the additional components of this replication method. Initial Load and Simultaneous Delta Replication The initial load of business data needs to be executed only one time to replicate the entire existing dataset from the s...

The Extraction-Transformation-Load (ETL) based data replication uses SAP BusinessObjects Data Services (hereafter referred to as Data Services) to load the relevant business data from the source system, SAP ERP, and replicate it to the target, SAP In-Memory Database (IMDB). This method allows you to read the required business data on the level of the application layer. You deploy this method by defining data flows in Data Services and scheduling the replication jobs. Since this method uses batch processing, it allows also for data checks, transformations, synchronizing with additional data providers, and the merging of data streams. The data replication is operated by Data Services. Its main components are the Data Services Designer, where you model the data flow, and the Data Services Job Server for the execution of the replication jobs. An additional repository is used to store the meta data and the job definitions. Data Flow As for any replication scenario you have to def...

The Trigger-Based Replication method uses the SAP Landscape Transformation (SLT) component to  pass data from the source system to the SAP In-Memory Database (IMDB) target system. Initial Load and Simultaneous Delta Replication The initial load of business data is initiated using the SAP In-Memory Computing Studio. The initial load message is sent from the SAP HANA system to the SLT system (based on SAP NetWeaver 7.02 with kernel 7.20) which in turn passes the initialization message to the ERP system. The ERP system begins by setting up database transaction log tables for each table to be replicated. After the transaction tables are completed, the SLT system begins a multi-threaded replication of data to the target system which allows high speed of data transfer to be achieved. The initial load of data can be executed whilst the source system is active. The system load that this process causes can be controlled by adjusting the number of worker threads performing th...

LO 01003 - An error occurred when refreshing. Cause This error might be caused by the following reasons: 1. The report is corrupted. 2. Drawing Live Office object on unsupported areas, like Word Header or Footer, or Office 2007 PowerPoint Slide Master. 3. The server is not accessible. If not in the list, check the detail error. Action For cause: 1. Check from InfoView to make sure the document is valid. If yes, log-off and log-on BOE on Live Office Option dialog then try again, or re-start the Office application, then try again. 2. Do not drawing Live Office object on unsupported areas. 3. Fix the network connectivity or start up the server. If not in previous causes, use the error code in the detail to find the solution,or just follow the guide in the detail See also: BUSINESS OBJECTS ERRORS LIST

Translation Manager Exporting documents to the CMS After you translate the document, you need to select it for publishing and export it to the CMS.  You can publish it into as many languages as are ready . A built in document analyzer provides statistics on the percentage of the document that has translations so you can decide if you are ready to complete the publish step before exporting to the CMS. Universes can only be exported to the same file location. Web Intelligence documents can change locations. 1. Go to the Language Management view. 2. Click the value in the Ready to export to CMS column for the language or languages that you want to export to Yes. 3. Select Export to CMS from the File menu. A message appears to prompt you to save the document before exporting to the CMS. 4. Click Yes. The Export Universe/Webi Document dialog box appears. 5. Click Export to export the document and save it in the local file that is shown a...

Installing and Using the SAP HANA ODBO Client for MS EXCEL Everyone  who intend to use Microsoft (MS) EXCEL as an end-user client for SAP HANA need to install the SAP HANA client on a host where MS EXCEL has been installed and is running. Prerequisites: You have downloaded the SAP HANA client software from SAP Service Marketplace . Procedure Install the SAP HANA ODBO driver on the host where MS EXCEL has been installed and is running. 1. Open a command prompt and call the SAP HANA client installation program by entering the following command: hdbinst -a client [ ] 2. Follow the instructions displayed by the installation tool. 3. Set the PATH environment variable to the installation path. For information on setting environment variables, see the documentation for your operating system. 4. Create a connection to the SAP HANA database: a. Create a connection to an external data source: Data connection Wizard Sele...

There are three options to recover a deleted folder depending  on what kind of backup you have done: 1. backup of the CMS database and File Store. 2. You created recently a BIAR file. 3. You have a Development/Test environment where you have this folder. Let's see the  Solution in case you have a back up of the CMS database. Follow the steps to recover deleted folder and sub-folders: 1. Copy the CMS database from the backup to your database server and point the CMS ODBC system DSN to it. 2. Copy the backed up file store to a Temp directory. 3. Change the path of input and output file repository servers in the CMC, for each server, to the Temp file store directory. 4. You will now be able to find the reports. Copy those reports to the BusinessObjects server's local disk, or create a BIAR file using the Import Wizard. 5. Point the ODBC system DSN back to the original database, and also change the paths on input file repository and output file repository s...

SAP HANA Persistence: In-Memory Data Is Regularly Saved to Disk  Data:  - SQL data and undo log information  - Additional HANA information, such as modeling data  - Kept in-memory to ensure maximum performance  - Write process is asynchronously Log:  - Information about data changes (redo log)  - Directly saved to persistent storage when transaction is committed  - Cyclical overwrite (only after backup) Savepoint:  - Changed data and undo log is written from memory to persistent storage  - Automatic  - At least every 5 minutes (customizable) For detail: SAP HANA - Data persistence