BW - Introduction

Business Warehouse (BW) is the SAP tool to extract reports with data coming from the transactional systems (mainly RCS). 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.

Reports are organised by Applications (represented as 'Roles" in the Analysis) corresponding to functional areas. 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

Getting BW installed

Requesting Installation

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. 

Checking the Installation

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

To check the installation : 

1. Select "START" button
2. Click on "All Programs"
3. Search for the "SAP Business Intelligence" folder
4. Open the "SAP BusinessObjects Analysis" folder
5. Select Analysis for Microsoft Excel
   
6. Microsoft Excel will open. Verify that you have the "Analysis" Ribbon in the top bar
   

If you did not find the "SAP Business Intelligence" Folder, you need to contact your SBS infraservice desk  support and request them to install Analysis for Microsoft Excel.

Reference : SLV0325_SAP_BOAnalysisforMSOFIX_XXX

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 ()

1. Request through BW online form . 

2. Aftersubmission, there will be a ticket automatically created in the SBS Support portal.
3. IS Customer Support team will ensure the form/Content is duly filled and transfer the ticket to Authorization team (IS-SD-Authorization group).
4. Authorization team will ask for validation from some Key contacts.
5. Once access is validated, Authorization team will create the account and inform you the new user/password by email.

Account creation can take several days due to  required approvals (Based on the applications and perimeter the Authorization team will request several approvals).

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

PQ1 Server (Solvay Legacy)

For PQ1 BW access there is currently no form. To request an access, Please send an email to SBS Support. Please provide your job description, scope and if possible explain what kind of reports you are interested in. The support team will determine your access based on your explanations.

Getting Training

For general training or support, you could refer to weLink for more information. 

Password Reset and Unlock Account

WBP Server 

For Account unlocking and password resets on WBP, you can use SAP GRC CUP 

PQ1 Server (Solvay Legacy)

Please send an email to SBS Support.