General

How to receive the BW newletters

To see the newletters for BW you can either check directly the News section of the IS Support Portal, or subscribe to it to receive it by email :

1. Go to ISSP Portal http://issp.priv.rhodia.com/issp/news/listFancy.do
2. Select My Subscriptions
3. Choose "Business Warehouse" tool
4. Choose the required application (you should, at least, subscribe to the “GENERAL” BW newsletter)
5. Click on the Purple “+” to subscribe

Installation related

Before a training, how to check if Analysis works correctly or not?

1. In Windows Start menu / All Programs, there should be a folder "SAP Business Intelligence" in which there is "Analysis for Microsoft Excel".If you don't have this, please see how to contact your service desk via  http://welink.solvay.com/en/functions/solvay_business_services/IS_infra-page_usercorner.tcm#&slider1=2

2. By clicking "Analysis for Microsoft Excel", you can open Excel with a tab "Analysis".

3. Click insert and then "Select Data Source".

4. Skip the first interface ( Logon to SAP BusinessObjects BI Platform ).

5.  The following "Select Data Source" interface shows. Make sure the following two BW servers are in the list:

PQ1 (Solvay Legacy BW server ) (Analysis training is done on PQ1, so be sure to have it in the list )

WBP ( Rhodia Legacy BW server)
If they are not in the list, please contact the Infrastructure Service Desk to update the SAPLogon.ini file.

 For some users(mainly Solvay legacy), WBP comes right after PQ1, they are:
BW - Production - PQ1
BW - Production - WBP

For other users( mainly Rhodia Legacy), there are two WBP servers, make sure the 

"OR-- BW !!! Production WBP !!! IBM" are in the list. We are using this one.

6. After you select the BW server ( WBP or PQ1 ), you can logon with your WBP or PQ1 account.

How to check my Saplogon version

To check the Saplogon version :

Execute the "SAP Logon" program. It should be in your Program Files --> SAP Front End --> SAP Logon :

If you do not find this it means the SAP Logon is not installed on your PC.

This will open a SAP window displaying the list of all SAP Servers. Click on the top left corner of the window and then select About SAP Logon...

This will open a new window that displays the exact version number :

The current working "Patch level" is 13, so if yours is not 13, please contact the insfrastructure Service desk to upgrade your SAPLogon.

How to update your saplogon.ini file (SAP servers list)

Note : The saplogon.ini is a file that contains the list of servers displayed when you connect to SAP. It is a small text file you can find in C:\windows.

• If connecting to the BW server (WBP - Production) the Client is empty, input "400", in case of PQ1 fill in "020" with.

Account related

How to get an access to BW Analysis?

Please sent a mail to sbs-is-appli-help@solvay.com.

They will send you a form to precise your request.

I do not remember my user name. How do I find it ?

If you do not remember your login, simply ask the sbs-is-appli-help@solvay.com.

Note that generally your BW login will be the same as your RCS or windows login.

How to reset the BW password ?

You can reset your password yourself by using the SAP GRC Access Control portal password self service.

The first time you will need to set your secret question.

Alternatively you can ask directly for a password reset to the sbs-is-appli-help@solvay.com

How to deactivate or delete an account ?

Desactivation or deletion of an account can be done via the same form as for account creation/modification. See here.

I received an email about account beeing disabled soon. What to do ?

Once per month the IS Security team sends a reminder to users which have not used their account for more than 3 months.

If you do nothing, the account will be disabled and then deleted automatically by IS.

If you want to keep the account, just log in once into Business Warehouse.

Logon related

Which BW server should I select ?

For Production, please select "BW !! ! Production WBP ! !! IBM .

The "BW !! ! Production WBP ! !!" (without IBM) is no longer accessible due to migration of our servers to IBM.

What languages are supported by BW ?

The tool itself (tool bars, menus...) can be displayed in many languages but the reports are only translated English (EN), French (FR) and Portuguese (PT)
You can choose the language in the connection screen :

If no language is selected, it will automatically select the default language provided at the account creation.

Broadcasts (Reports sent automatically)

What is a broadcast ?

1. broadcast is a report that is sent automatically to users on a scheduled basis.

The report can be sent in several formats (Excel, PDF...) to an email or to a business objects inbox. It can be scheduled to be sent on a daily, weekly or monthly basis.

How to create or modify a scheduled report (broadcast) ?

As a user you cannot create new broadcasts or modify the existing ones.

For any new broadcast, or a change in an existing one, please contact the sbs-is-appli-help@solvay.com.

For a new broadcast make sure you mention :

• The report to be broadcasted (where to find it and the name)
• The schedule of the broadcast (which day to start and frequency : weekly, daily, monthly...)
• The format : PDF, Excel
• The targets : emails or BO account lists (If Email, specify the Subject to be used).

For an update, please make sure you mention the name of the report or the subject of the email

How to get removed from a broadcast ?

To be removed from a broadcasted report list, please forward the email you received to the APPLICATIONS HELPDESK saying that you would like to be removed from that broadcast.h1.Navigation Related

How to display local (chinese/korean...) characters in BW excel reports ?

To make sure that chinese characters are correctly displayed in Excel for the BW reports, you have to verify 2 parameters :

• The local language set in Windows

• The language set in the SAP Logon for the BW Production server.

• Step 1: Choose Start -> Control Panel

• Step 2: Double-click on “Regional and Language Options” and you will see a popup screen.
• Step 3: Under the “Regional Options” tab, select “Chinese (any country)”
• Step 4: Click on the “OK” button.

• Step 5: Open the SAP Logon Pad.
• Step 6: Selection “Production WBP”.

• Step 7: Click on the “Change Item…” button to see a pop up screen.

• Step 8: Click on the “Advanced..” button to see another popup screen.

• Step 9: Make sure the settings in your screen looks like the following screen.
• Step 10: Click on the “OK” button.

• Step 11: Click on the “Save” button.

• Step 12: Reopen excel and BEx Analyzer, refresh the report and you will be able to see the Chinese characters successfully now.

Note that if you need to view the data in other languages such as Korean, etc., you will need to do all the above steps and choose the respective language.

Navigation

What is a "Core Query" and "Core Workbook" ?

"Core" means that it is standard content that was created for anyone in Rhodia : it doesnt have any specific rules that restrict the usage to a specific Business Unit or country or zone.

Other reports are "Specific" : GBU Specific, Country Specific (ex : for tax purposes).

What difference between a query and a workbook ?

A Query is an object that contains the way to extract the data from the database. It defines the fields (Characteristics), calculations (Key Figures), filters from the database.

A Workbook is an excel file with one or more embedded Queries. It can have several queries is used to save the result and the layout of the report.

A typical use is to execute a query, change the layout and then save the result as a workbook.

The BW team provides both queries and worbooks to users (Workbooks are usually used because we can include documentation in the excel sheets).

How to delete many values in a prompt

• Step 1 : In the Prompt, Select « + » and choose « Add Lines using Filter By Member ».
• Step 2 : Uncheck the “Select all” checkbox.
• Step 3 : Only check the Companies/Plants you want to access to.

How to avoid refreshing the whole workbook when I uncheck the "Merge Variables"

Refresh a data source or workbook#Agoodwaytouncheck"MergeVariables"

Report results

BW will not repeat all the values in each line and instead will show a blank value. Is there a way to have BW repeat the values ?

By default in the BW queries, it will not "repeat the key values" in each line. This is because it usually makes it easier to read the results. But it also prevents you to use some excel features (filters, sorts, pivot) since the values are empty.

You can ask BW to change that behavior by changing an option in the workbooks. See  How to repeat members for more detail.

When I run my BW report, the data I get is obsolete and has not been updated. Why ?

The BW data is not updated in real-time. Mostly BW is going to copy the data from the sources one time per day (see details).

It is possible that the copying of the data is still in progress or has not been done since the new data was created. If possible, please retry after the loading process is completed. If not solved, please contact the sbs-is-appli-help@solvay.com

Errors messages and main issues

Go to Business Warehouse Troubleshooting section