Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 59

changes.mady.by.user Eric BOLLE

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

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 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.Is BW the right tool for your reporting needs? Check the Reporting tools guide

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. 

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"
    1. Open the "SAP Business Intelligence" folder
    Open the
    1. Double Click "
    SAP BusinessObjects
    1. Analysis
    " folderSelect Analysis
    1. for Microsoft Excel

    Image Removed
    1. " 
    2. Verify
    Double Click Analysis for Microsoft Excel and verify
    1. that you have the "Analysis" Ribbon in the top bar
    Image Removed
    Note

    If you

    did

    do not find the "SAP Business Intelligence"

    Folder

    folder, you need to

    contact your SBS infraservice desk  support

    request it from your local Service One and request them to install Analysis for Microsoft Excel.



    Image Added

    Image Added


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

  • User request through BW online form.  It can be for the user him/herself or for others(up to 10) who needs the same access.

  • After submission, there will be a ticket automatically created in the SBS Support portal.
  • Customer Support team will ensure the form/Content is duly filled and transfer the ticket to Authorization team (IS-SD-Authorization group).
    • Authorization team will ask for validation from some Key contacts. This take

    , 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

    Authorization team will

    L1 AM team will request several approvals).

    Once

    access is

    accesses are validated,

     Authorization team will

    L1 AM team will create the account and inform the User

    the new user/password

    by email.

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

     

    PQ1 Server (Solvay Legacy)

    For PQ1 BW access there is currently no form. To request an access to this system, Please create a Freshdesk ticket, using the link below:

    https://sbs-support.solvay.com/helpdesk/tickets/new

     

    Please provide the scope (finance, purchasing....) and which reports you are interested in.

    The support team will determine your access based on your explanations.

    Getting Training

    How to join an existing session:

    http://issp.solvay.com/issp/training/session/list.do

    • to look for the list of the next BW Analysis course fill in the right handside fields of the screen  with the following information.

     

    Fields to fulfilled in :Selected entries
    Image RemovedImage Removed
    Image RemovedImage Removed

     

    • Then click on search and you will get as hereunder a list of the next sessions.  
      Image Removed

    How to request a new session on ISSP :

    http://issp.solvay.com/issp/training/course/list.do

    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 

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

    SAP GRC CUP 

    PQ1 Server (Solvay Legacy)

    Please send an email to SBS Support. 

    Panel

    Contents for this page :

    Table of Contents
    maxLevel2

    Links to sub-pages :

    Children Display

    Noteif you are not able to find the solution in the self help portal, please send an email - SBS Support to our customer support team.

    Self-Service Reactivate User System Specific 

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



    Image Added