| Table of Contents |
|---|
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 Reports are organised 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.
| Panel | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||
Contents for this page :
Links to sub-pages :
|
| 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 Service One.
- Choose the service Software Installation Request [Workstation]
- 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 :
- Select "START" button
- Open the "SAP Business Intelligence" folder
- Double Click "
- Analysis
- for Microsoft Excel
- "
- Verify
- that you have the "Analysis" Ribbon in the top bar
| Note |
|---|
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. |
Please note that Analyzer tool is obsolete. Please do not use it
| Expand | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||
SAP Analysis for MS Excel provided by SAP and the Analysis Tool Pack Add-IN are 2 different tools.
|
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:
- 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 L1 AM
team will request several approvals).
Once accesses are validated, L1 AM
team will create the account and inform the User by email.
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
| Livesearch | ||||||
|---|---|---|---|---|---|---|
|
| Panel | |||||
|---|---|---|---|---|---|
Contents for this page :
Links to sub-pages :
|
- Move system WBPCLNT400 to the RIGHT
- Click Save to reactivate your WBP account
