info
This FAQ relates to "Analysis - The FAQ for the Analyzer has been moved here.
/info
{toc}
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 local IT (SMIO) 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 ! !! are in the list. We are using this one.
6. After you select the BW server ( WBP or PQ1 ), you can logon then with your WBP or PQ1 account.
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 local IT( ATOS or SMIO ) to upgrade your SAPLogon.
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.
To update the saplogon file run the following program (not download):
ema:priv:rhodia:com/TA/get_saplogon_ini:bat+
This program will automatically download the last version of the standard file and save it in the correct location (C:/Windows). Your previous file will be renammed and saved in the same folder.
If the link does not work :
If you do not remember your login, simply ask the SBS IS Application Helpdesk.
Note that generally your BW login will be the same as your RCS or windows login.
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
Desactivation or deletion of an account can be done via the same form as for account creation/modification. See the detailed procedure.
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.
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.
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.
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.
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 ISF Application Helpdesk.
For a new broadcast make sure you mention :
For an update, please make sure you mention the name of the report or the subject of the email
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
To make sure that chinese characters are correctly displayed in Excel for the BW reports, you have to verify 2 parameters :
warning
Exact name can differ but should include "WBP" or "BW Production".
/warning
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.
"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).
The BW team provides both queries and worbooks to users (Workbooks are usually used because we can include documentation in the excel sheets).
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 in the user guide.
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 APPLICATIONS HELPDESK
Go to Business Warehouse Troubleshooting section