Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 22

changes.mady.by.user Xiang Yun Ong

Saved on

compared with

New Version Current

changes.mady.by.user ROLLIER, Charlotte

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



 

 

BW -

Introduction

Business Warehouse (BW) is an the SAP tool that can be used to extract reports with data coming from the transactional systems and mainly RCS(mainly WP1 & PF1). Users can use the AnalyserAnalysis, an excel add-onin, to connect to BW and then select a report to executelaunch. The result of the report will directly be extracted 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 organized Reports are organised by Applications (represented as 'Roles" in the AnaylsisAnalysis) corresponding to to functional areas.  Each Each user is given access to one or more Applications based on needs.

Panel
bgColor#f2f2f2
Livesearch
spaceKeyISAPPSUP
placeholderSearch in BW contents
labelsbw

Contents for this page :

Table of Contents
maxLevel2

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 because admin rights are needed on the PC to do so.

Service One.

  1. Choose the service Software Installation Request [Workstation]
  2. 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 : 

  1. Select "START" button
  • Click on "All Programs"
    • Select
    1. Open the "SAP Business Intelligence" folder
  • Open the "SAP BusinessObjects Analysis" folder
    1. Double Click "Analysis for Microsoft Excel" 
    Microsoft Excel will open.
    1. Verify that you have the "Analysis" Ribbon in the top bar
    Note

    If you

    did

    do not find the "SAP Business Intelligence"

    Folder

    folder, you need to

    contact

    request it from your local

    IT support

    Service One and request them to install Analysis

    For

    for Microsoft Excel.

    Reference : SLV0325_SAP_BOAnalysisforMSOFIX_XXX



    Image Added

    Image Added

    Image Removed 


    Getting a BW Account

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

    existin

    existing account)

    the process is different depending on the server.

    WBP Server (Rhodia Legacy)

    1. Download the BW Form and fill it based on what you need.
    2. Send the filled form to the SBS-IS-Appli-Help@solvay.com by email.
    3. The Security team will proceed to account validation.
    4. 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:

    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

    Account creation can take several days to due

    required approvals (Based on the applications and perimeter the

    security

    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 the 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

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

    Password Reset and Unlock Account

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

    Image Added



    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


    Image Added



    Password Reset and Unlock Account

    WBP Server (Rhodia Legacy)

    For Account unlocking and password resets on WBP or any SAP systems, you can

    use the Password

    use Self

    Service on the SAP GRC Access Control. http://pyjsapr3.ibm.be.solvay.com/AE/index.jsp

    PQ1 Server (Solvay Legacy)

    Please send an email to SBS-IS-Appli-Help@solvay.com. 

    Panel

    Table of Contents
    maxLevel1

    Children Display

    Noteif you are not able to find the solution in the self help portal, please send an email - SBS-IS-Appli-Help@solvay.com to our customer support

    -Service Reactivate User System Specific 

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



    Image Added

    team.