Quick Guide for Implementing the SAP Business Intelligence

(1)

SAP BW 7.31 SPS11

Business Objects

Enterprise XI 4.1

SP04

SAP ERP 606 SP11

Oct. 2014

English

Quick Guide for

Implementing the SAP

Business Intelligence

Adoption

rapid-deployment solution V5.41

SAP AG Dietmar-Hopp-Allee 16 69190 Walldorf Germany

(2)

Copyright

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer, StreamWork, SAP HANA, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects Software Ltd. Business Objects is an SAP company.

Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybase products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Sybase Inc. Sybase is an SAP company.

Crossgate, m@gic EDDY, B2B 360°, and B2B 360° Services are registered trademarks of Crossgate AG in Germany and other countries. Crossgate is an SAP company.

All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary. These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

(3)

Icons

Icon Meaning Caution Example Note Recommendation Syntax

Typographic Conventions

Type Style Description

Example text Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths and options.

Cross-references to other documentation.

Example text Emphasized words or phrases in body text, titles of graphics and tables. EXAMPLE TEXT Names of elements in the system. These include report names,

program names, transaction codes, table names, and individual key words of a programming language, when surrounded by body text, for example, SELECT and INCLUDE.

Example text Screen output. This includes file and directory names and their paths, messages, source code, names of variables and parameters as well as names of installation, upgrade and database tools.

EXAMPLE TEXT Keys on the keyboard, for example, function keys (such as F2) or the ENTER key.

Example text Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation.

<Example text> Variable user entry. Pointed brackets indicate that you replace these words and characters with appropriate entries.

(4)

Content

Quick Guide for Implementing the SAP Business Intelligence Adoption rapid-deployment solution

... 6

1 About This Quick Guide ... 6

2 SAP Business Intelligence Adoption rapid-deployment solution Building Blocks ... 6

2.1 Solution Overview ... 6

2.2 Best Practise Guide to choose stuitable Solution Architecture and BI Reporting Tool.. 7

2.3 Document Types and Content ... 8

3 Implementation Methodology... 8

4 System Preparation ... 9

4.1 Required SAP Product and Software Component Versions ... 9

4.2 Solution Architecture and Required Software based on Customer’s Landscape ... 9

4.3 Creating Role in BW (Optional) ... 9

4.4 BI Platform Pre-configuration (Optional) ... 10

4.4.1 Configuring SAP Authentication ... 10

4.4.2 Enable SAP Authentication in BI Launch Pad ... 11

4.4.3 User Security Setting (Optional) ... 12

4.5 Relevant SAP Notes ... 12

4.6 Download Information ... 13

4.6.1 SBOP BI Platform 4.1 ... 13

4.6.2 SBOP EXPLORER 4.1 ... 13

4.6.3 SBOP DASHBOARDS 4.1 ... 14

4.6.4 SBOP BI Platform 4.1 Clients ... 14

4.6.5 SAP CRYSTAL REPORTS FOR ENTERPRISE 4.1 ... 14

4.6.6 SAP BusinessObjects Design Studio 1.3 or above ... 15

4.6.7 SAP LUMIRA (VISUAL INTELLIGENCE) 1.0 SP12+ ... 15

4.6.8 BI Reports and HANA Content (LCMBIAR files, svid files, HANA tgz files) for this Solution 15 4.6.9 BP-BW 731V6 (or latest version later than BP-BW 731 V6) ... 16

5 Deploy HANA Content for Remote HANA Scenario ... 17

5.1 Replicate ECC tables to HANA through SLT ... 17

5.2 Import HANA Content ... 18

5.3 Check the Import of HANA models (Optional) ... 19

5.4 Change Client for users ... 19

5.5 Create Connection to HANA in your BW ... 19

6 Deploy BusinessObjects Reports ... 20

6.1 Import LCMBIAR File ... 20

6.2 Adapt BW OLAP Connection ... 20

6.3 Adapt BWoH OLAP Connection ... 21

6.4 Adapt ECC OLAP Connection ... 21

7 ECC Administraction ... 22

7.1 Maintaining Currency Translation Types ... 22

(5)

8.1 CEO Analysis (B05) ... 25

8.2 Sales Analysis (B07) ... 26

8.3 Financial Analysis (B49) ... 26

8.4 Purchasing Analysis (B53) ... 27

8.5 Manufacturing Analysis (B55) ... 27

8.6 Human Capital Management Analysis (D02) ... 28

8.7 CRM Sales Analysis for BI Platform (VB6) ... 28

8.8 Data Reconciliation for SAP BW (BY4) ... 29

8.9 Data Availability for SAP BW (BY5) ... 29

8.10 Data Lineage for SAP BW (BY6) ... 30

8.11 Finance Operational Analytics with ODP (BY7) ... 30

8.12 Sales Operational Analytics with ODP (BY8) ... 31

8.13 Purchasing Operational Analytics with ODP (BY9) ... 31

8.14 CRM Marketing Analysis (CR3) ... 32

8.15 CRM ERP Integrated Sales Analysis (CR4) ... 33

8.16 CRM Standalone Sales Analysis (CR5) ... 34

8.17 CRM Service Analysis (CR6) ... 35

9 Additional Configuration to View BI Report ... 36

9.1 Analysis Application (Design Studio) ... 36

9.2 View Analysis Application (Design Studio) On iPad ... 36

9.3 Convert Analysis Worspace report into Design Studio ... 37

9.4 Information Workspace ... 37

9.5 Crystal Report ... 37

9.6 WEB Intelligence ... 38

9.6.1 Changing the bex display property ... 38

9.6.2 Workaround for mobile use ... 38

9.6.3 Other related SAP Notes ... 39

9.7 Dashboard on iPad ... 39

10 Appendix ... 40

(6)

Quick Guide for Implementing the SAP Business

Intelligence Adoption rapid-deployment solution

1 About This Quick Guide

This quick guide helps consultants and customer project members to implement the SAP

Business Intelligence Adoption rapid-deployment solution. The document specifies all of the steps required to ensure successful implementation of the SAP Business Intelligence Adoption rapid-deployment solution and directs you to more detailed documentation where necessary.

This document is intended for use by SAP partners,consultants, and system administrators who are involved in SAP Business Intelligence Adoption rapid-deployment solution installation.

Very Important: Always check SAP Note 2034647 to find and download the latest version of this quick guide.

2 SAP Business Intelligence Adoption

rapid-deployment solution Building Blocks

Definition

Building blocks are reusable preconfiguration or documentation units that you can combine in order to install an SAP business scenario or solution. The building block concept offers

substantial benefits to SAP Channel Partners involved in the development, distribution, and sale of SAP solutions for the SMB market. You can use the building block installations as the basis for your own vertical solutions. Similar to a construction kit, you can assemble building blocks flexibly to set up business scenarios. Using building blocks for installing business content means

reducing redundancies, because you can use a generic building block in different solutions. In the past, the configuration content was component-focused and you had to import the configuration of an entire system, whereas now you can select blocks of scenario-oriented configuration. The reusability of building blocks accelerates and facilitates the installation because you no longer need to import the settings of an entire system but can build on separate configuration blocks. Consequently, development and maintenance costs are minimized, because redundant development is reduced.

Building Block Characteristics

A building block is not characterized by the level of configuration it covers but by its reusability as a complete configuration entity in the installation of one or more solutions. With the building block approach, you can therefore classify both entire solutions and minor specific configuration packages as building blocks, depending on their ability to feature as configuration units in different solutions.

2.1 Solution Overview

This SAP Business Intelligence Adoption rapid-deployment solution adds consumption of BW and HANA content, penetration and drive successful adoption of BI 4.1, ensure customer success by providing guided analysis to use the right visualization tool for their scenario. It provides End-to-End offering for a successful BI adoption for BW, HANA & ERP, and helps customers make the right design choices on how to consume existing and new content (such as queries, modeling.etc) In SAP Business Intelligence Adoption rapid-deployment solution package, it provides

(7)

Studio, Lumira report as examples based on BW Content, HANA and ERP for the following scenarios:

Scenario Number Analytics Scenario

B05 CEO Analytics

B07 Sales Analytics

B49 Financial Analytics

B53 Purchasing Analytics

B55 Manufacturing Analytics

D02 Human Resources Analytics

VB6 CRM Sales Analysis for BI Platform

BY4 Data Reconciliation for SAP BW

BY5 Data Availability for SAP BW

BY6 Data Lineage for SAP BW

BY7 Finance Operational Analytics with ODP

BY8 Sales Operational Analytics with ODP

BY9 Purchasing Operational Analytics with ODP

CR3 * CRM Marketing Analysis

CR4* CRM ERP Integrated Sales Analysis

CR5* CRM Standalone Sales Analysis

CR6* CRM Service Analysis

This quick guide only provides the implementation for BI reporting on BW’s BI content with latest BI platform 4.1 technologies.

* CR3 CR4 CR5 CR6 are to merge existing CRM Analytics RDS into BI Adoption RDS (Dashboard and Bex Reports on BW content, Reporting on CRM WEB UI via BI Java Portal).

As for other BI platform 4.0 architeture and technology to implement BI reporting on existing HANA content or ECC, please refer to following existing Rapid Deployment Solution Packages as samples: SAP Note 1826840: Rapid deployment of operational reporting with SAP HANA

2.2 Best Practise Guide to choose stuitable Solution

Architecture and BI Reporting Tool

In the service document of this Rapid Deployment Solution, we provides the Best Practise Guide to choose stuitable Solution Architecture and BI Reporting Tool:

For BW Customers, one option is to use BI reporting on BW’s BI content, which is implimented in this quick giude. Meanwhile, if they have HANA as well, they can also refer the predefined configuration and content of this quick guide for more BI adoption on BW content before / after BW migration to HANA database.

(8)

For HANA Customer who requires real time analytics based on large volumn of data, they can choose the content on HANA as SAP Note 1826840 mentions ( Rapid deployment of operational reporting with SAP HANA)

In Service Step-By-Step Guide - Start: Do Kick-Off Workshop page, you can download the Best practice Guide document.

2.3 Document Types and Content

Purpose

In order to set up an analytics scenario, you have to install a number of building blocks in a predefined sequence. For each building block, documents are available that describe the preparation and installation procedures for a standalone building block or scenario. The installation documentation for a given scenario therefore comes in the form of a number of individual documents that are delivered together with their associated building block.

The individual installation documents can therefore not be used on their own and it is important that you read the documentation carefully in the correct order.

The following table provides an overview of the documentation delivered with the SAP Business Intelligence Adoption rapid-deployment solution:

Document Type Purpose File

Format Prerequisites

Matrix

A spreadsheet that lists the building blocks required and their implementation sequence

Microsoft Excel Building Block

Description

Briefly describes the content of a building block and lists its functions and benefits

HTML

Building Block Configuration Guide

For each building block, there is a Building Block

Configuration Guide that describes in detail how to install the building block. Microsoft Word Business Process Documentation

Business user documentation providing detailed application-focused descriptions of individual business processes and business processes of a business scenario

Microsoft Word

3 Implementation Methodology

Overall project guidance is provided in the form of a specific implementation roadmap, the implementation methodology for the SAP Business Intelligence Adoption rapid-deployment solution, which is a phased, delivery-oriented methodology that streamlines implementation projects for solution packages, guiding project teams through the following phases:

 Start  Deploy  Run

The methodology supports project teams with templates, tools, questionnaires, and checklists, including guidebooks and accelerators to ensure the quick and pragmatic implementation of rapid-deployment solutions.

The SAP Business Intelligence Adoption rapid-deployment solution does not make use of automated installation procedures. The configuration guides in the SAP Business Intelligence

(9)

Adoption rapid-deployment solution package describe how to manually configure the system in order to get the SAP Best Practices business scenarios up and running.

The SAP Business Intelligence Adoption rapid-deployment solution solution documentation provides you with all you need for setting up the SAP rapid-deployment solution business scenarios.

4 System Preparation

The SAP Business Intelligence Adoption rapid-deployment solution solution has been tested in an environment with different system landscape components for certain release and support

package levels specified in the following sections.

If the release and support package levels do not match the levels indicated, errors may occur. The documentation is based on the menu paths and transaction views as they appear in the given system environments.

We therefore recommend that you use the release and support package level prerequisites specified below for each system involved. After installation, you can upgrade to the latest release and support packages.

4.1 Required SAP Product and Software Component Versions

The table lists all software required to implement the whole scope of this solution. Customer should adopt the applicable scope according to their actual landscape and business scope. Please refer to the required SAP Product and software component versions in

RDS_BIA_BOA41V5_Requirements_EN_XX.doc document.

Very Important: Don’t use solution manager to implement this RDS

This document (Quick guide) is the entry point to start implementation this RDS. Although this RDS also released solution manager content as well, please don’t use solution manager template for implementation. In our solution manager template, we just define the reference link to each configuration guide word document. We didn't deliver any automatically deployment content in solution manager template.

4.2 Solution Architecture and Required Software based on

Customer’s Landscape

To deploy BI on BW of this package, the applicable scope depends on customer’s landscape. Please refer to more details in RDS_BIA_BOA41V5_Requirements_EN_XX.doc document.

4.3 Creating Role in BW (Optional)

Use

In this activity you create Roles in BW and assign your User ID to this role, which will be used to integration with BI platform

Procedure

This activity must be performed in the SAP BW system.

(10)

SAP BW Menu Role Maintenance Transaction Code PFCG

2. On the Role Maintenance screen, Enter a name for the Role, for example ZBPR_BIA_RPT. 3. Choose Single Role.

4. On the Create Roles screen, enter a description for Description field, for example SAP BI Adoption Reporting

5. Choose Save button from the upper menu.

6. Choose the Authorizations tab, and click the ‘Change Authorization Data’ to grant enough authorization which can be used to access data of BW infoCubes and Queries.

For reference/example, customer can choose S_RS_RREPU (“BI Role: Reporting user”) from ‘Choose Template’ dialog, then choose ‘Adopt reference’. Choose ‘generate’ button to generate the authorization profile.

Customer can adopt more complex authorization strategy in BW side, and this is not provided by this package by default, but by additional services.

7. Choose User tab; enter your User ID you want to add to the role under User Assignments section and press Enter.

8. Select the users you added and click User comparison button. 9. In the Compare Role User Master Record dialog box, choose Cancel. 10. Save your settings.

4.4 BI Platform Pre-configuration (Optional)

4.4.1 Configuring SAP Authentication

SAP authentication enables your BW users to log onto BI platform using their BW user names and passwords, without storing these passwords in BI platform, SAP authentication also allows you to preserve information about user roles in BW, and to use this role information within the platform to assign rights to perform administrative tasks, or access content, you can follow the below steps to implement this activity.

(11)

Procedure

1. Go to the Authentication management area of CMC. 2. Double-click the SAP link.

The entitlement systems settings appear.

If an entitlement system is already displayed in the logical system name list, click New. 3. In the System field, type the three-character System ID (SID) of you SAP system.

4. In the Client field, type the client number that BI platform must use when it logs on to your SAP system. BI platform combines your system and client information, and addes an entry to Logical system name list.

5. Ensure the Disabled check box is clear.

6. Complete the Message Server and Logon Group fields as appropriate, if you have set up load balancing such that BI platform must log on through a message server.

7. If you have not set up load balancing, complete the Application Server and System Number fields as appropriate.

8. In the User Name, Password, and Language fields, type the user name, password, and language code for the SAP account that you want BI platform to use when it logs on to SAP. 9. Click Update.

10. Go to Options tab.

11. Check Enable SAP Authentication. 12. Go to Role Import tab.

13. Choose the available role which you created by previous steps, for example ZBPR_BIA_RPT 14. Add the role to right side and click on Update.

4.4.2 Enable SAP Authentication in BI Launch Pad

SAP authentication is invisible in BI Launch Pad logon screen by default. To make SAP authentication available, you need to edit the BI Launch pad properties in your BOE server. To modify BI Launch pad default settings, you need to set custom BI Launch pad properties.

Procedure

1. Go to the following directory in your BI platform installation: <INSTALLDIR>\SAP BusinessObjects Enterprise XI 4.0\warfiles\webapps\BOE\WEB-INF\config\custom\

If you are using the Tomcat version installed with BI platform, you can also access the following directory: C:\Program Files (x86)\SAP

BusinessObjects\Tomcat6\webapps\BOE\WEBINF\config\custom

If you are using any other supported web application server, consult the documentation for your web application server to determine the appropriate path.

2. Create a new file named: BIlaunchpad.properties

3. Edit the file by notepad and include the authentication options on the BI launch pad logon screen add the following entries:

authentication.visible=true authentication.default=secSAPR3

(12)

cms.visible=true 4. Save and close the file.

5. Restart your web application server.

4.4.3 User Security Setting (Optional)

A user group will be created automatically along with you import BW roles into BI Platform by step 4.4.1, all users which you are using to log onto BI Platform with SAP Authentication will be

assigned to that user group, by default the user group doesn’t have access privileges to public folders via BI Launch Pad, please change user security setting according to your real business demand.

A user group will be created having the name : BI4~800@ZBPR_BIA_RPT

For reference/example, you could simply assign the user group to administrative, certainly you are also able to adopt more complex authorization strategy, but this is not provided by this package by default, but by additional services.

4.5 Relevant SAP Notes

The following notes may need to be implemented if you encountert issues. Check if the symptoms described for each note occur in your system landscape:

SAP Note #

System Description / Symptom Component

1373402 BW Issues with invalid characters or SID Generation BW-WHM-DBA-ODS

1763267 BW DBIF_RSQL_TABLE_UNKNOWN dump in RSAR_CHECK_REQUEST

BW-WHM-DST-PSA

1637935 BW Short Dump RAISE_EXCEPTION

RSO_CONTENT_INSTALL_BATCH X_MESSAGE

BW-BCT-TCT

1721195 BW Assertion failed during content activation of TRF BW-WHM-DST-TRF

1712355 ERP BI extraction: Dump

DBIF_RSQL_INVALID_CURSOR

BW-BCT-FI-GL

1752626 BW (If it is BW on HANA)

NO2 aggregation for InfoCubes fails activate BW-BEX-OT-DBIF

1824688 BW Variable or structure member texts are not displayed

BW-BEX-ET-QDEF 1788145 BW BICS: calling variable screen twice removes the

currency

BW-BEX-ET-WJR-BICS n/a BW When trying to activate data request in /IMO/ Data

Storage object, the following error occurs: Table SAP<XXX>:RSODSACTUPDTYPE: Table not found does not exist

Workaround: This is an new issue on NW BW 7.31 SP09. To fix it, Please change table type (storage parameter) of table “RSODSACTUPDTYPE” from “row store” to “column store” using Transaction

(13)

SE14.

n/a BI

platform Client

Could not open the editor: Argument cannot be null" happened when open JCO connection which is migrated to BI4.1 from BI4.0

(Problem report id:

ADAPT01710128) This issue have been fixed since BIP 4.1 client SP01 patch 05 + , or SP02 Patch01+ or SP03

4.6 Download Information

In order to deploy this solution, you need to get below softwares and install them:

To download software packages from the SAP Service Marketplace, you must install the SAP Download Manager.

Software installation is not in the service scope of this rapid-deployment solution.

4.6.1 SBOP BI Platform 4.1

To download SBOP BI Platform 4.1 SP04, perform the following steps:  In your Web browser, go to http://service.sap.com/swdc

 In the top pane, choose SAPBusinessObjects Downloads

 Choose SAP BusinessObjects Portfolio link under the Find your software tab in the content pane.

 Choose the Installtion and Upgrade link in the content pane.

 In the right pane, Choose SBOP BUSINESS INTELLIGENCE PLATFORM (SBOP ENTERPRISE)  SBOP BI PLATFORM (ENTERPRISE)  SBOP BI PLATFORM 4.1  Installation and Upgrade  WINDOWS

 In the Download area, select the checkbox for material number 51048294 (SBOP BI PLATFORM 4.1 SP04 SERVER WINDOWS), then choose Add to Download Basket.

4.6.2 SBOP EXPLORER 4.1

To download SBOP EXPLORER 4.1 SP04, perform the following steps:  In your Web browser, go to http://service.sap.com/swdc

 Choose the SAP BusinessObjects Portfolio link under the Find your software tab in the content pane.

 In the right pane, Choose SBOP EXPLORER SBOP EXPLORER 4.1 Installation and Upgrade  SBOP EXPLORER 4.1  WINDOWS

(14)

 In the Download area, select the checkbox for material number 51046788_4 (SAP BUSINESSOBJECTS EXPLORER 4.1 SP1 WINDOWS (64B)), then choose Add to Download Basket.

4.6.3 SBOP DASHBOARDS 4.1

You need to install SBOP DASHBOARDS 4.1 SP04 software, open Dashboard, and change Connection to your own Connection, and do necessary configuration.

To download SBOP DASHBOARDS 4.1SP04, perform the following steps:  In your Web browser, go to http://service.sap.com/swdc

 In the right pane, Choose SBOP DASHBOARDS (XCELSIUS)  SBOP DASHBOARDS 4.1 Installation and Upgrade  WINDOWS

 In the Download area, select the checkbox for 51048299 SBOP DASHBOARDS 4.1 SP04 WINDOWS (32B), then choose Add to Download Basket.

4.6.4 SBOP BI Platform 4.1 Clients

To download SBOP BI Platform 4.1 Client SP04, perform the following steps:  In your Web browser, go to http://service.sap.com/swdc

 In the Download area, select the checkbox for material number 51048293_1 (SBOP BI PLATFORM 4.1 SP04 CLIENT TOOLS WINDOWS (32B)), then choose Add to Download Basket.

4.6.5 SAP CRYSTAL REPORTS FOR ENTERPRISE 4.1

To download SAP CRYSTAL REPORTS FOR ENTERPRISE 4.1 SP04, perform the following steps:

 In your Web browser, go to http://service.sap.com/swdc

(15)

 In the Download area, select the checkbox for material number 51048293_3 (SAP CRYSTAL REPORTS FOR ENTERPRISE 4.1 SP04 WINDOWS (32B)), then choose Add to Download Basket.

4.6.6 SAP BusinessObjects Design Studio 1.3 or above

To download SAP BusinessObjects Design Studio 1.3 or higher version, perform the following steps:

 Choose the Installtion and Upgrade link in the content pane and go to D index.  In the right pane, Choose SBOP DESIGN STUDIO  SBOP DESIGN STUDIO 

Installation

 In the Download area, select the checkbox, then choose Add to Download Basket.

4.6.7 SAP LUMIRA (VISUAL INTELLIGENCE) 1.0 SP12+

To download SAP LUMIRA (VISUAL INTELLIGENCE) 1.0 SP12 or higher version, perform the following steps:

 Choose the Installtion and Upgrade link in the content pane and go to L index.  In the right pane, Choose LUMIRA (VISUAL INTELLIGENCE)  SAP LUMIRA 1.0  In the Download area, select the checkbox, then choose Add to Download Basket.  Install SAP LUMIRA 1.0 after downloading

 Choose the Support Package and Patches link in the content pane and go to L index.  In the right pane, Choose LUMIRA (VISUAL INTELLIGENCE)  SAP LUMIRA 1.0  In the Download area, select the checkbox, then choose Add to Download Basket.  Install the latest support package of SAP LUMIRA 1.0 after downloading

4.6.8 BI Reports and HANA Content (LCMBIAR files, svid files,

HANA tgz files) for this Solution

To download Lcmbiar file for the deployment of BI reports in this solution, perform the following steps:

 Click "Software Downloads"  "SAP Software Download Center"  "Installations and Upgrades"  A - Z Index (R)  "SAP Rapid Deployment Solutions"

 Choose and click "SAP Business Intelligence Adoption rapid-deployment solution"  "RDS_BIA_CONTENT 1.0“

(16)

 In the Download area, select the checkbox, then choose Add to Download Basket. Download it with SAP Download Manager.

 Unzip the zip file, and the LCMBIAR file is available at "

\BI_Platform\RDS_BIA_SBO41.lcmbiar". You have to import this LCMBIAR file into SAP Business Objects BI platform in the following up section of this quick guide.

 Unzip the zip file, and the svid files are available in following sub folders. SAP Lumira is requried to open these files.

a) \Lumira\BWHANA

Capacity Load Utilization BWoH.svid Profitability Analysis BWoH.svid Sales Overview Analysis BWoH.svid Stock Consumption Analysis BWoH.svid Vendor Analysis BWoH.svid

b) \Lumira\BWUNX

Capacity Load Utilization - BW on UNX.svid Profitability Analysis - BW on UNX.svid Sales Overview Analysis - BW on UNX.svid Stock Consumption Analysis -BW on UNX.svid Vendor Analysis - BW on UNX.svid

 Unzip the zip file, go to sub folder and find HANA Content file as \HANA\HCO_RDS_BIA.tgz.

4.6.9 BP-BW 731V6 (or latest version later than BP-BW 731

V6)

To download BP-BW 731V3 BW addon component ( RDS BW BI CONT Addon) deployed in this solution, perform the following steps:

 Click "Software Downloads"  "SAP Software Download Center"  "Installations and Upgrades"  A - Z Index (R)  "SAP Rapid Deployment Solutions"

 Choose and click "SAP Business Intelligence Adoption rapid-deployment solution"  "BP-BW"  "BP-BW 731V6 "  “ Installation“  “BP-BW 731V6: Add-On Installation“.  In the Download area, select the checkbox, then choose Add to Download Basket.

Download it with SAP Download Manager.

Please download the BP-BW 731 latest version, since the latest version always includes the fixes to previous issues

(17)

5 Deploy HANA Content for Remote HANA Scenario

5.1 Replicate ECC tables to HANA through SLT

Use

ECC tables should be replicated to HANA first. HANA models are created based on these tables.

Procedure

Please refer to configuration guide HA1- SAP Landscape Transformation for SAP HANA and replicate all the tables in the below table list.

Table Name Description

CE1XXXX(XXXX means your operating concern)

CO-PA Actual Line Items

DD07L R/3 DD: values for the domains

DD07T DD: Texts for Domain Fixed Values

(Language-Dependent)

DD08L R/3 DD: relationship definitions

MAKT Material Descriptions

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

MBEW Material Valuatio

MCHB Batch Stocks

S032 Statistics: Current Stock and Grouping Terms

T001 Company Codes

T001K Valuation Area

T001L Storage Locations

T001W Plants/Branches

T005T Country Names

T005U Taxes: Region Key: Texts

T006A Assign Internal to Language-Dependent Unit

T023T Material Group Descriptions

T134T Material Type Descriptions

T137T Industry Descriptions

T179T Materials: Product hierarchies: Texts

T6WSAT Texts for seasonal material categories

(18)

TCURC Currency Codes

TCURF Conversion Factors

TCURN Quotations

TCURR Exchange Rates

TCURT Currency Code Names

TCURV Exchange rate types for currency translation

TCURX Decimal Places in Currencies

TNTPB Descriptions of EAN Categories

TSPAT Organizational Unit: Sales Divisions: Texts

After replication, you need to manually create one table DOM_ATTYPT under your schema. Take “SAP_RDS_BIA” as an example,

drop table "SAP_RDS_BIA"."DOM_ATTYPT";

create column table "SAP_RDS_BIA"."DOM_ATTYPT" ("DOMVALUE_L" NVARCHAR (10) not null default ' ', "DDLANGUAGE" NVARCHAR (1) not null default ' ',

"DDTEXT" NVARCHAR (60) not null default ' ', primary key ("DOMVALUE_L","DDLANGUAGE"));

insert into "SAP_RDS_BIA"."DOM_ATTYPT" select domvalue_l, ddlanguage, ddtext from "SAP_RDS_BIA"."DD07T" where domname = 'ATTYP';

5.2 Import HANA Content

Procedure

1. Choose StartAll ProgramsSAP HANASAP HANA Studio to open your SAP HANA studio.

2. Choose menu FileImport, click on SAP HANA Content and select Delivery Unit. 3. Click on Next and select the target HANA system.

4. Click on Next, choose client radio button then browse for file “HCO_RDS_BIA.tgz”. (Please refer to 4.6 download information about how to download this file)

5. Import dialog, set the following values:

Field name User action and values Comment Select file Client

Select the filename *.tgz This file is included with download content Overwrite inactive

versions

Checked

Activate objects Checked 6. Click Finish to import the content. 7. Check ‘job log’

(19)

5.3 Check the Import of HANA models (Optional)

Procedure

2. Open menu WindowOpen Perspective and choose Modeler.

3. In the navigator panel, expand the node <HANA server> Content -> sap ->rds-bia, you should be able to see your content now.

Check whether all the HANA models have been activated successfully, if not please reactivate again. You can find all technical objects listed in section 11.1 under Appendix chapter.

5.4 Change Client for users

Procedure

2. In the navigator panel, expand the node <HANA server>  Catalog  Authorization  Users, right click on the user e.g. SYSTEM, select “open” to open the user’s profile. 3. Enter the ERP client number for Session Client. e.g. 800

Save your setting.

5.5 Create Connection to HANA in your BW

Use

In this activity, a connection to HANA is set up under DB Connect

Procedure

1. Enter T-Code RSA1, in the Data Warehousing Workbench: use the menu Modeling -> Source Systems, from the context menu of DB Connect, create a new connection

2. In the popup dialog“Create Source System“ enter the parameters as below

Logical System Name Your logical system name (i.e., H3D) Source System Name Your source system name (i.e: H3D HANA)

Type and Release NO Value

3. Set up your HANA connection details

DBMS HDB

User Name Your HANA user name

DB Password Your HANA user password

(20)

4. Save your enteries.

6 Deploy BusinessObjects Reports

6.1 Import LCMBIAR File

Use

The BOBJ reports are packaged to LCMBIAR file; you can follow the steps below to import the LCMBIAR file to your BI Platform.

Please always check previous section “4.6.7 LCMBIAR File ( BI reports) for this Solution” in order to find the instruction to download latest version of the SBOP lcmbiar files.

Make sure that you use administrator user account to import LCMBIAR file.

Procedure

1. Log into CMC by the link http://<hostname>:<port>/BOE/CMC 2. Go to Promotion Management in right side of homepage.

3. In the “Promotion Jobs” screen, select Import -> Import file. The Import from file window appears.

4. Browse the LCMBIAR file from your local driver and click OK. 5. Select the folder in which you want to save the job.

6. Choose your CMS system from Destination Drop-down.

7. Choose Create. A new job is created and stored in the CMS repository. 8. Click on Promote button and the Promote - <job name> window appears. 9. Enter the Change Management ID if necessary.

10. Click on Promote button. The importing of LCMBIAR file will be in progress. 11. Check if the LCMBIAR file is promoted successfully.

Result

The LCMBIAR file is imported to your BI Platform, and you will be able to see the BOBJ reports.

6.2 Adapt BW OLAP Connection

Use

In this activity, you will adapt the BW OLAP connection ZBIA_OLAP(BW) and switch to your own BW System. This connection is for those reports based on BW content.

Procedure

1. Log into CMC by the link http://<hostname>:<port>/BOE/CMC 2. Go to OLAP Connections from homepage.

3. Choose entry BW Connection and click on edit connection icon from menu bar. 4. In editing screen, configure the connection information to your own.

(21)

Make sure that you have selected Pre-defined under Authentication and have made the required entries for user and password.

You could also select SSO for Authentication and the authorization strategy of BW will be reflected in Dashboards per users by using SAP Authentication.

5. Save your setting.

6. Restart the Server Intelligence Agent to make the change effect.

6.3 Adapt BWoH OLAP Connection

Use

In this activity, you will adapt the BW OLAP connection ZBIA_OLAP(BWoH) and switch to your own BW System. This connection is for those reports based on HANA Optimized BW content.

Procedure

6.4 Adapt ECC OLAP Connection

Use

In this activity, you will adapt the BW OLAP connection ZBIA_OLAP(BI ECC) and switch to your own BW System. This connection is for those reports based on ERP Operational Data provider.

Procedure

(22)

7 ECC Administraction

7.1 Maintaining Currency Translation Types

Use

In this activity, we maintain currency translation types. With currency translation types, different currencies can be translated into standard currency. This currency conversion is for those reports based on ERP Operational Data provider.

Procedure

1. Choose one of the following navigation options:

SAP BW Menu Modeling → Object Maintenance → Currency Translation Types

Transaction Code RSCUR

2. On the Currency Translation Types screen, enter ZBIA_CC for field Currency Translation Types, and BIA Project Currency Conversion as Description, choose Create.

3. Choose Exchange Rate Tab, make the following entries:

Field Name User Action and Values

ER Determ. Using FI Modules X

Exhange Rate Type M

Dyn. Ex. Rate. Determination X 4. Choose Currncy Tab, make the following entries:

Source Currency form Data Record X

Fixed Target Currency USD

5. Choose Time Ref Tab, make the following entries:

Fixed Time Ref X

Current Date X

(23)

8 Implementing Content

The building blocks per scenario include all implementions which are based on different requirement to customer’s landscapes:

(1) BW on any Database , without seperate HANA (Conventional BW or BW on HANA)

These configurations can be implemented in BW on any Database. In building blocks configuration guide, all configurations are applicable for (1) by default unless there are additional landscape prerequisites information marked for (2) and (3) .

These configurations are for the BI reports which is based on SAP Standard BW Content object (0*) and SAP BP-BW Addon BW content object (name space /PKG/). All /PKG/ namespace BW objects can be activated on both conventional BW and BW HANA.

(2) BW on any Database (eg: conventional BW) + seperate HANA (BW and HANA Mixed Scenario)

The configurations marked with landscape prerequisites (2) requires seperate HANA sever.

These configurations are for the BI reports which is based on SAP BP-BW Addon BW content object (name space /PKG/). We can activate these /PKG/ namespace objects on conventional BW , but we can’t use these /PKG/ namespace BW Model objects without HANA views.

(24)

The configurations marked with landscape prerequisites (3) requires BW on HANA. These configurations are for the BI reports which is based on SAP HANA Optimized BW content object (name space /IMO/) and SAP HANA Optimized BP-BW Addon BW content object (name space /PIO/), which requires BW’s Database migration into HANA as prerequisites.

The more landscapes‘ requirement can be statisfied, the more content can be implemented.

Please refer to the detailed information in each building blocks configuration guide. Customer should adopt the applicable scope according to their actual landscape and business scope.

(1) To pick up applicable Server product and software components, please refer to

customer’s Landscape according to BW Migration (none HANA/ Partial Migration / BW on HANA)

(2) To pick up client reporting tools, please do the scoping with the file RDS\Accelerators \ RDS_BIA_BOA41V5_Technical_Object_Mapping_EN_XX.xls

a. Filter the Landscape according to BW Migration (none HANA/ Partial Migration / BW on HANA)

(25)

8.1 CEO Analysis (B05)

Use

In this activity, you start to activate the CEO Analysis scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

Procedure

1. First install the prerequisite building blocks and then activate each building block using the relevant configuration guide.

2. Activate each scenario in the sequence below.

Building Block Number

Building Block Name Prerequisites

BW1 BW Basic Connectivity

BW2 BW Connectivity for SAP ERP BW1

B03 General Settings for BW Integration BW1 BW2 BS1 Basic Configuration – Financial

Accounting Analytics

BW1 BW2 B03

BS3 Basic Configuration – Sales Analytics BW1 BW2 B03 BS5 Basic Configuration – Purchasing

Analytics

BW1 BW2 B03

BS6 Basic Configuration – Manufacturing Analytics

BW1 BW2 B03

BS7 Basic Configuration - Inventory Analytics

BW1 BW2 B03

B48 Financial Analytics Configuration BW1 BW2 B03 BS1

B06 Sales Analytics Configuration BW1 BW2 B03 BS1 BS3 B48 B52 Purchasing Analytics Configuration BW1 BW2 B03 BS5

B54 Manufacturing Analytics Configuration BW1 BW2 B03 BS6 HA1 SAP Landscape Transformation for

SAP HANA

Only necessary in case of BW and HANA mixed scenario BV2 Inventory Analytics Configuration BW1 BW2 B03 BS7

B04 CEO Analytics Configuration BW1 BW2 B03 BS1 BS3 BS5

BS6 BS7 B48 B06 B52 B54 BV2 V38 SAP BusinessObjects Mobile for iPad

Configuration (if reporting on mobile is necessary)

(26)

8.2 Sales Analysis (B07)

Use

In this activity, you start to activate the Sales Analysis scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

Procedure

First install the prerequisite building blocks and then activate each building block using the relevant configuration guide.

B03 General Settings for BW Integration BW1 BW2 BS1 Basic Configuration – Financial

BW1 BW2 B03

BS3 Basic Configuration – Sales Analytics BW1 BW2 B03 B48 Financial Analytics Configuration BW1 BW2 B03 BS1 HA1 SAP Landscape Transformation for

SAP HANA

Only necessary in case of BW and HANA mixed scenario B06 Sales Analytics Configuration BW1 BW2 B03 BS1 BS3 B48 V38 SAP BusinessObjects Mobile for iPad

n/a

8.3 Financial Analysis (B49)

Use

In this activity, you start to activate the Financial Analysis scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block

Configuration Guide provided with this package.

Procedure

(27)

BW2 BW Connectivity for SAP ERP BW1 B03 General Settings for BW Integration BW1 BW2 BS1 Basic Configuration – Financial

BW1 BW2 B03

B48 Financial Analytics Configuration BW1 BW2 B03 BS1 V38 SAP BusinessObjects Mobile for iPad

n/a

8.4 Purchasing Analysis (B53)

Use

In this activity, you start to activate the Purchasing Analysis scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block

Configuration Guide provided with this package.

Procedure

B03 General Settings for BW Integration BW1 BW2 BS5 Basic Configuration – Purchasing

Analytics

BW1 BW2 B03

B52 Purchasing Analytics Configuration BW1 BW2 B03 BS5 V38 SAP BusinessObjects Mobile for iPad

n/a

8.5 Manufacturing Analysis (B55)

Use

In this activity, you start to activate the Manufacturing Analysis scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

Procedure

(28)

B03 General Settings for BW Integration BW1 BW2 BS6 Basic Configuration – Manufacturing

Analytics

BW1 BW2 B03

B54 Manufacturing Analytics Configuration BW1 BW2 B03 BS6 V38 SAP BusinessObjects Mobile for iPad

n/a

8.6 Human Capital Management Analysis (D02)

Use

In this activity, you start to activate the Human Capital Management Analytics scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

Procedure

B03 General Settings for BW Integration BW1 BW2 D00 Human Capital Management Analytics

configuration

BW1 BW2 B03

8.7 CRM Sales Analysis for BI Platform (VB6)

Use

In this activity, you start to activate the CRM Sales Analysis for BI Platform scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

Procedure

(29)

B01 CRM Generation

BW3 BW Connectivity for SAP CRM

B03 General Settings for BW Integration BW1 BW3

BS4 Basic Configuration – CRM Analytics B01 BW1 BW3 B03

VB7 CRM Sales Analysis for BI Platform Configuration

B01 BW1 BW3 B03

8.8 Data Reconciliation for SAP BW (BY4)

Use

In this activity, you start to activate the Data Reconciliation for SAP BW scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

Procedure

BY1 Data Reconciliation for SAP BW BW1 BW2 B03

V38 SAP BusinessObjects Mobile for iPad Configuration (if reporting on mobile is necessary)

n/a

8.9 Data Availability for SAP BW (BY5)

Use

In this activity, you start to activate the Data Availability for SAP BW scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

(30)

Procedure

BY2 Data Availability for SAP BW BW1 BW2 B03

n/a

8.10 Data Lineage for SAP BW (BY6)

Use

In this activity, you start to activate the Data Lineage for SAP BW scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

Procedure

BY3 Data Lineage for SAP BW BW1 BW2 B03

n/a

8.11 Finance Operational Analytics with ODP (BY7)

Use

In this activity, you start to activate the Finance Operational Analytics with ODP scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

(31)

Procedure

B03 General Settings for BW Integration Comments: Refer B03 to configure between ECC’s BI client and data source client BZ0 ERP Finance Operational Analytics

with ODP

B03

n/a

8.12 Sales Operational Analytics with ODP (BY8)

Use

In this activity, you start to activate the Sales Operational Analytics with ODP scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

Procedure

B03 General Settings for BW Integration Comments: Refer B03 to configure between ECC’s BI client and data source client BZ1 ERP Sales Operational Analytics with

ODP

B03

n/a

8.13 Purchasing Operational Analytics with ODP (BY9)

Use

In this activity, you start to activate the Purchasing Operational Analytics with ODP scenario in this solution. For detailed instructions, see the Prerequisites Matrix Configuration Guide and the Building Block Configuration Guide provided with this package.

(32)

Procedure

B03 General Settings for BW Integration Comments: Refer B03 to configure between ECC’s BI client and data source client BZ2 ERP Puchasing Operational Analytics

with ODP

B03

n/a

8.14 CRM Marketing Analysis (CR3)

Use

In this activity you start to activate CRM Marketing Analysis scenario in this solution. Refer to the Prerequisites Matrix and the Building Block Configuration Guides shipped with this package for detailed instructions.

Procedure

Activate each building block using the relevant configuration guide, after first installing the prerequisite building blocks:

Activate each scenario follow below sequence

The ERP Integrated Analysis is not in the scope of this package. Please select only CRM source system when activating BI Content in below building blocking configuration guides.

When referring to configuration guide, please follow it as the BW 7.x data flow if the configuration guide still mention the data flow as 3.x but BI CONT data flow is in higher version (7.x)

B01 CRM Generation

BW3 BW Connectivity for SAP CRM B01 BW1

B03 General Settings for BW Integration B01 BW1 BW3 C04 CRM WebClient UI - Basic Settings B01 BW1 BW3 B03 BS4 Basic Configuration – CRM Analytics B01 BW1 BW3 B03

(33)

CX1 CRM Xcelsius Basic Configuration B01 BW1 BW3 B03 BS4

CBM CRM Marketing Analysis BEx Reports B01 BW1 BW3 B03 BS4 CX1

CXM CRM Xcelsius Marketing Analysis B01 BW1 BW3 B03 BS4 CX1

B72 CRM Marketing Analysis B01 BW1 BW3 B03 BS4 CX1

CXN CRM Xcelsius Lead Analysis B01 BW1 BW3 B03 BS4 CX1

8.15 CRM ERP Integrated Sales Analysis (CR4)

Use

In this activity you start to activate CRM ERP Integrated Sales Analysis scenario in this solution. Refer to the Prerequisites Matrix and the Building Block Configuration Guides shipped with this package for detailed instructions.

Procedure

B01 CRM Generation

BW2 BW Connectivity for SAP ERP

C41 CRM Interactive Reporting

(34)

CXR CRM Sales Analysis Interactive XC Dashboard

B01 BW1 BW3 B03 BS4 CX1

CXQ CRM to ERP SD BW Content mapping BW1 BW2 BW3 B03 BS4

CBP CRM+ERP SD Sales Analyses Bex

Reports

BW1 BW2 BW3 B03 CXQ

CXP CRM and ERP SD Sales Analyses XC

Dashboard

BW1 BW3 B03 BS4 CX1

8.16 CRM Standalone Sales Analysis (CR5)

Use

In this activity you start to activate CRM Standalone Sales Analysis scenario in this solution. Refer to the Prerequisites Matrix and the Building Block Configuration Guides shipped with this package for detailed instructions.

Procedure

The ERP Integrated Analysis is not in the scope of this package. Please select only CRM source system when activating BI Content in below building blocking configuration guides.

B01 CRM Generation

(35)

CX1 CRM Xcelsius Basic Configuration B01 BW1 BW3 B03 BS4

B73 CRM Sales Analysis B01 BW1 BW3 B03 BS4 CX1

CXO CRM Xcelsius Sales Analysis B01 BW1 BW3 B03 BS4 CX1

CXR CRM Xcelsius Opportunity Analysis B01 BW1 BW3 B03 BS4 CX1

8.17 CRM Service Analysis (CR6)

Use

In this activity you start to activate CRM Service Analysis scenario in this solution. Refer to the Prerequisites Matrix and the Building Block Configuration Guides shipped with this package for detailed instructions.

Procedure

B01 CRM Generation

BW2 BW Connectivity for SAP ERP

C41 CRM Interactive Reporting

(36)

CBS CRM Service Request BEx Reports B01 BW1 BW3 B03 BS4 CX1

CXS CRM Xcelsius Service Request

Analysis

B01 BW1 BW3 B03 BS4 CX1

CXT CRM Xcelsius Service Order Analysis B01 BW1 BW3 B03 BS4 CX1

9 Additional Configuration to View BI Report

9.1 Analysis Application (Design Studio)

Use

If you want to replace the SAP Logo on Design Studio Reports to your own company logo, you can follow below procedure.

Procedure

1. Launch Design Studio tool. In the popup logon window, enter User Name and Password for the Authnication you selected. For Web Service URL option, enter the URL link like http://<Your BOE Server Name>:<Port>/dswsbobje/services/Session, click OK to logon. 2. On the menu bar, select Application  Open…, in the popup window, navigate to the

folder which stored the reports of SAP Business Intelligence Adoption rapid-deployment solution and choose the Design Studio report you want to customize.

3. Click on Open button. Then the Design Studio Reports file will be opened.

4. Click on the SAP logo on the report. In the right panel Properties, choose Image under node Display, then click the Browser button.

5. In the popup window Open Image, click Upload Local Image button. Choose your local image which you want to replace the SAP logo, then click Open button.

6. Choose the image you just uploaded and click Open button.

7. After the refreshing, you will find the logo is changed to your own image already. 8. On the menu bar, select Application Save to save the replacement.

Result

The Design Studio Reports‘ logo was replaced with your own company logo.

9.2 View Analysis Application (Design Studio) On iPad

Use

If you want to view the design studio analysises , please follow the below procedure.

Procedure

1. Launch Design Studio tool. In the popup logon window, enter User Name and Password for the Authnication you selected. For Web Service URL option, enter the URL link like http://<Your BOE Server Name>:<Port>/dswsbobje/services/Session, click OK to logon.

(37)

2. On the menu bar, select Application  Open…, in the popup window, navigate to the folder which stored the reports of SAP Business Intelligence Adoption rapid-deployment solution and choose the Design Studio report you want to customize.

3. Click on Open button. Then the Design Studio Reports file will be opened.

4. Click the cross tab component, in the property panel, please change the value of property „Pixel-Based Scrolling“ to be true.

5. On the menu bar, select Application Save to save the replacement.

Result

You can scroll up and down the crosstab table.

9.3 Convert Analysis Worspace report into Design Studio

Use

If you want to convert Analysis Workspace report into Desing Studio, please follow the below procedure.

Procedure

1. Launch BOE server. In the BI launch pad logon window, enter User Name and Password. Then selecte Log On.

2. In the menu list, navigate to the folder which stored the Analysis Workspace reports. Double-click to open the Analysis Workspace report you want to convert to Design Studio. 3. On the menu bar, select button, in the Export window you can choose your export

versions,desktop or iPad. Then click OK.

4. Choose the path you want to save the new report and enter the Filename. Then click Save.

Result

The Analysis Workspace report have been converted to Design Studio.

9.4 Information Workspace

Please check SAP Note 1690334 if you Unable to create or test connection in Information Design Tool or if the indexing failed for Information Space.

9.5 Crystal Report

In B05 - CEO Analytics Area, current Inventory Crystal report has 5 filters: Key date, Company Code, Plant, Material Group and Material. Key date, Company Code, Plant are defined as variable in BW Query. Material Group and Material are defined as filter in Crystal Reports‘ Query Panel, to order to use Dynamical Cascading on List of Value generated from BW Query‘ s result set.

To accelarate the performance, you can define Material Group and Material as BW Query’s variable instead of Query Panel’s filter. In this case, Dynamical Cascading on List of Value can not be used.