Page tree




Introduction

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


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 organized 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.

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 Service One.

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

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. Open the "SAP Business Intelligence" folder
  3. Double Click "Analysis for Microsoft Excel" 
  4. Verify that you have the "Analysis" Ribbon in the top bar

If you do not find the "SAP Business Intelligence" folder, you need to request it from your local Service One and request them to install Analysis for Microsoft Excel.





Getting a BW Account

To get a new BW account (or to modify/delete your existing account), the requester fills the  BW online form in Service One:

  1. Choose the service SAP Access Request 
  2. Select the Type of request: creation or modification
  3. Select the environment: Production (WBP), Pré-Production (WBV), Quality (WBQ)
  4. Select the SAP system: WBP - BW Business Warehouse
  5. 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 L1 AM team will request several approvals).

Once accesses are validated, L1 AM team will create the account and inform the User by email.




Getting Trained

You can request a training or join an existing training using the YouGrow learning platform,

You can filter on the learning catalog " BW" Business Warehouse to see the list of all trainings available





Password Reset and Unlock Account

For Account unlocking and password resets on WBP or any SAP systems, you can use Self-Service Reactivate User System Specific 

  1. Move system WBPCLNT400 to the RIGHT
  2. Click Save to reactivate your WBP account 





The best way to get IT support is to use the new Service One Platform.