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.
1 - First, select the empty cell where you will want 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 the Solvay Group BW server .
- BW Production - PQ1 : This is the Solvay Legacy BW server.
- BI - Production - PQ2 : This is the BI HR BW server.
No Server list available
In case that pop-up list doesn't appear please read carefully the following link.
5 - Connection to the server
- in the SSO (single sign-on)mode you get that screen .
If language box is empty fill in with EN .
If you let it empty the selected language is the language defined within your BW account.
- In case you need to bypass that mode, click on Cancel you will open the screen :
Thus you can enter either your account and password or an other one.
6 - Optional : Click on "Options" to be able to change the language (Only EN supported).
if you don't get that we recommend you to adjust your Analysis Settings by ticking the following option.
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.
When you click on "Insert", it will show the "Select Data Source" option but also up to 10 queries from your history
If you already connected to BW then it will not ask for the server selection again.
Account
No Account ? See the "Getting an account" section.
Language
Only English is fully supported. Part of WBP content will also be translated into FR and PT.
Roles
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 (See Getting an Account section).
8 - 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 (See next sections on prompts).
Open a workbook ( on the server )
- Open “Analysis for Microsoft Excel” in the Start Menu / All programs
2. In “File” tab / Analysis , click icon “Open workbook” (from SAP NetWeaver )
3. Logon the BW server (WBP or PQ1)
4. After logging in with your ID (and password if you are not in the SSO mode).
Click Options to use language EN
If not in the SSO mode, better to Click Options to use language "EN".
5. select Folders , then you can select “My Documents” to open your personal workbooks or select “Role” to select core workbooks.
6. In the following example, we select “Role” and then open a working capital 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.
The best way to get IT support is to use the new
Service One Platform.