This FAQ relates to "Analysis - The FAQ for the Analyzer has been moved here.
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 :
- Go to ISSP Portal http://issp.priv.rhodia.com/issp/news/listFancy.do
- Select My Subscriptions
- Choose "Business Warehouse" tool
- Choose the required application (you should, at least, subscribe to the “GENERAL” BW newsletter)
- Click on the Purple “+” to subscribe
Installation related
Before a training, how to check if Analysis works correctly or not?
- 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 local IT Infra-structure helpdesk 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. If you see the following window, just click "Skip" to go to the next interface.
5. The following "Select Data Source" interface shows. The following servers are BW servers.
BW - Production - PQ1
BW - Production - WBP
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 in folder C:\windows that contains the list of servers displayed when you connect to SAP.
In "Analysis for Microsoft Excel", the list are in the "Connection" folder as in the image below.
Sometimes your SAPLogon.ini file is too old and you can contact your local IT infra-structure team to update it.
Account related
How to get an access to BW reports?
Please contact SBS Support.
They will send you a form to precise your request.
I do not remember my BW user name. How do I find it ?
Note that generally your BW login will be the same as your RCS or windows login.
If still not ok, Please contact SBS Support.
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 the answers your two secret questions.
Alternatively you can ask directly for a password reset to SBS Support.
How to deactivate or delete an account ?
Please contact SBS Support.
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 ?
Usually it's WBP or PQ1, please refer to BW - Server List .
What languages are supported by BW ?
The tool itself (tool bars, menus...) can be displayed in many languages but most of the reports are only designed in the English (EN) language so we recommend to select that language.
You can choose the language in the connection screen by clicking on "Options >>"
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 ?
A 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 SBS Support.
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 saying that you would like to be removed from that broadcast.
How to display local (Chinese, Korean...) characters in descriptions of some fields like material, customer, etc. in BW reports ?
For Chinese, Korean and other non-EN(FR, and PT) users, usually they should use EN to logon BW. But sometimes, users need descriptions to be in local languages. For example, they would like to know the Chinese descriptions of materials. In such case, users can do the following two things to get the local language descriptions. But this is not perfect, because the dimensions and key figures in BW might be in technical names ( instead of local languages ) and not recognizable.
- To set "Chinese" in Windows Control Panel / Reginal and language options
- To logon BW with the language, for example, ZH for Chinese, KR for Korean, etc..
Here are the detailed steps :
- 1. Choose Start -> Control Panel
- 2. Double-click on “Regional and Language Options” and you will see a popup screen.
- 3. Under the “Regional Options” tab, select “Chinese (any country)”
- 4. Click on the “OK” button.
- 5. When you logon BW, input the local language, ZH for Chinese for example.
- 6. Select the report to refresh. Please note here that the folder or report names might not be the same as in the English environment, because they are not maintained in local languages.
- 7. After you refresh the report, the descriptions in Chinese are displayed, but the names of dimensions ( Material, Customer ) or Key figures might be in technical names and unrecognizable.
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.
Due to Empire and Sabine’s project, the Prompts on Company and Plant automatically displays all the values you are authorized to access to.
If you want to access to a more restricted perimeter, then you need to change the existing filter as explained above.
How to avoid refreshing the whole workbook when I uncheck the "Merge Variables"
Refresh a Data Source or a Workbook
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 SBS Support
Errors messages and main issues
Go to Business Warehouse Troubleshooting section
The best way to get IT support is to use the new
Service One Platform.