BW -

Introduction

Business Warehouse (BW) is the SAP tool to extract reports with data coming from the transactional systems (mainly RCSWP1 & PF1). Users can use Analysis, an excel add-in, to connect to BW and then select a report to launch. The result of the report will directly be displayed in Excel.

High level of BW data flow

Image Added

Also BW is the main database to send data to other platforms like Qlik, Salesforce, SAC (Sap Analytic Cloud) GCP (Google Cloud Platform), Tableau by data engineering tool such as Talend or MFT (Manage File Transfer) tool.

BW Reports are organised organized by Applications (represented as 'Roles" in the Analysis) corresponding to functional areas. Each Each user is given access to one or more Applications based on needs.Is BW the right tool for your reporting needs? Check the Reporting tools guide

Request Access

Panel

bgColor	#f2f2f2

Livesearch

spaceKey	ISAPPSUP
placeholder	Search in BW contents
labels	bw

Contents for this page :

Table of Contents

maxLevel	2

Links to sub-pages :

Children Display

Note
if you are not able to find the solution in the self help portal, please create a ticket in Service one to our customer support team.

Getting BW installed

Requesting Installation

You cannot install SAP Business Intelligence by yourself.

To get BW installed on your PC you need to request it from your local

SBS - IS - Infrastructure support. You cannot install SAP Business Intelligence by yourself.

Service One.

Choose the service Software Installation Request [Workstation]
Software Requested: SAPGUI (SAP Logon & SAP Business Client)

Image Added

Search for

Checking the Installation

To use BW you need to have the "Analysis for Microsoft Excel" tool installed.

To check the installation :

Select "START" button

Click on "All Programs"

Open the "SAP Business Intelligence" folder

Open the

Double Click "

SAP BusinessObjects

Analysis

" folderSelect Analysis

for Microsoft Excel

Image Removed

"
Verify

Double Click Analysis for Microsoft Excel and verify

that you have the "Analysis" Ribbon in the top bar

Image Removed

Note
If you

did

do not find the "SAP Business Intelligence"

Folder

folder, you need to

contact your SBS infraservice desk support

request it from your local Service One and request them to install Analysis for Microsoft Excel.

Image Added

Getting a BW Account

To get a new BW account (or to modify/delete your existing account)

the process is different depending on the server.

WBP Server ()

User request through BW online form. It can be for the user him/herself or for others(up to 10) who needs the same access.

After submission, there will be a ticket automatically created in the SBS Support portal.

Customer Support team will ensure the form/Content is duly filled and transfer the ticket to Authorization team (IS-SD-Authorization group).

Authorization team will ask for validation from some Key contacts. This take

, the requester fills the BW online form in Service One:

Choose the service SAP Access Request
Select the Type of request: creation or modification
Select the environment: Production (WBP), Pré-Production (WBV), Quality (WBQ)
Select the SAP system: WBP - BW Business Warehouse
Select the Business Roles you need

Authorization team will ask for validation from some key contacts. This take several days due to required approvals (Based on the applications and perimeter the

Authorization team will

L1 AM team will request several approvals).

Once

access is

accesses are validated,

Authorization team will

L1 AM team will create the account and inform the User

the new user/password

by email.

Note: After your first connexion you have to change the transient password sent.

PQ1 Server (Solvay Legacy)

For PQ1 BW access there is currently no form. To request an access to this system, Please create a Freshdesk ticket, using the link below:

https://sbs-support.solvay.com/helpdesk/tickets/new

Please provide the scope (finance, purchasing....) and which reports you are interested in.

The support team will determine your access based on your explanations.

Getting Training

How to join an existing session:

http://issp.solvay.com/issp/training/session/list.do

to look for the list of the next BW Analysis course fill in the right handside fields of the screen with the following information.

Image Removed

Image Removed
Image Removed Image Removed