| Table of Contents | ||
|---|---|---|
|
Inserting a Query
When you first start Analysis, there is no data, or query inside the excel file. The first step is then to insert a query.
Open Data Source
There are 2 options to open Data Source:
- Go to the File tab, click on Analysis then Open Data Source.
Or click the Analysis tab
- First, select an empty cell where you wish
- to insert your data (Ex : A1)
2 - Go to the "Analysis" menu
3 - Click on "Insert"
4 - Select your source system : See the guide on which server to select.
- BW Production - WBP : This is Rhodia Legacy BW server.
- BW Production - PQ1 : This is the Solvay Legacy BW server.
- BI - Production - PQ2 : This is the BI HR BW server.
| Note |
|---|
Server list may be a bit different as this depends on your current saplogon.ini file but the server codes (Ex : WBP) should be the unchanged. |
5 - Log in using your BW user and password and click OK
6 - Optional : Click on "Options" to be able to change the language (Only FR/EN Supported).
7 - The "Select Data Source" window opens. Here you can either search for the queries by description/technical name (Search Tab) or via browsing in the roles.
- Click on "Insert Data Source"
| Info |
|---|
When you click on "Insert", it will show the "Select Data Source" option but also up to 10 queries from your history |
| Info |
|---|
If you already connected to BW then it will not ask for the server selection again. |
Select the source system: BW - Production - WBP
| Info | ||
|---|---|---|
| ||
No Account ? |
Go to Getting a BW Account. |
Click « OK »
- Client: 400
- Language: EN
| Info | ||
|---|---|---|
| ||
Only English is fully supported. |
|
The "Select Data Source" window opens. Here you can:
- either search for the queries by description/technical name (Search Tab)
- or via browsing in the roles
| Info | ||
|---|---|---|
| ||
The "Roles" are folders which contain the core queries. The roles you have reflect your access so if you are not seeing a given role it means you do not have access to it and need to request it ( |
Go to Getting an Account |
). |
Select the query you want to insert and click OK. This will launch the query and a prompt will appear for you to select the data
.
Open a workbook (on the server)
- Go to the File tab, click on Analysis then Open Workbook.
Select the source system: BW - Production - WBP
| Info | ||
|---|---|---|
| ||
No Account ? Go to Getting a BW Account. |
Click « OK »
- Client: 400
- Language: EN
| Info | ||
|---|---|---|
| ||
Only English is fully supported. |
Go to the tab “Role” and then open a working capital workbook.
Select and open the folder and double click on the workbook.
Open a workbook (saved on your local drive)
You need to first open "Analysis for Microsoft Excel", then open your BW file (by File --> Open or
Recent).
If you first open your BW file, then open "Analysis for Microsoft Excel", there will be two Excel opened and you can't refresh your BW file.
