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
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.
| 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
- 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
Microsoft Excel will open. - "
- 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. |
Getting a BW Account
To get a new BW account (or to modify/delete your existing account)
WBP Server (Rhodia Legacy)
Download the BW Form and fill it based on what you need.
- Send the filled form to the SBS-IS-Appli-Help@solvay.com by email.
- The Security team will proceed to account validation.
- Once access is validated the account will be created and you will receive by email your new user/password.
, 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).
Note that after your first connexion your password will have to be changed.
PQ1 Server (Solvay Legacy)
For PQ1 BW access there is currently no form. To request an access, Please send an email to SBS-IS-Appli-Help@solvay.com. Please provide your job description, scope and if possible explain what kind of reports you are interrested in. The support team will determine your access based on your explanations.
Getting Training
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
PQ1 Server (Solvay Legacy)
Please send an email to SBS-IS-Appli-Help@solvay.com.
Self-Service Reactivate User System Specific
- Move system WBPCLNT400 to the RIGHT
- Click Save to reactivate your WBP account
