This FAQ relates to "Analysis - The FAQ for the Analyzer has been moved here. |
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 :
If you don't have this, please see how to contact your local IT Infra-structure helpdesk via : Solvay infrastructure Local Team
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. Otherwise, just ignore this step.
|
|
|---|
5. The following "Select Data Source" interface shows. WBP is the BW server.
BW - Production - WBP
6. After you select the BW server ( WBP ), you can click OK to logon automatically with SSO or click Cancel to manually input a User/Password .
Please note if you don't have a WBP account, you will not be able to logon.
To connect the server you will get one of these windows
|
|---|
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 release is 7.4 and the Patch Level is 7, so if yours is not exactly the same, please contact the insfrastructure Service desk tem to upgrade your SAPUI.
Refer to the procedure Getting BW installed
Note that generally your BW login will be the same as your WP1 or PF1 login.
If still not ok, Please contact SBS Support.
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.
Please contact SBS Support.
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.
Usually it's WBP, please refer to BW - Server List .
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, the default language defined within your account is applied.
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 SBS Support.
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 saying that you would like to be removed from that broadcast.
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.
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.
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.
"Core" means that it is standard content that was created for anyone: it does not 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).
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 open query and workbook
In order to exclude divestments the Prompts on Company, PRS company and Plant automatically only displays the whole values you are authorized to. If you want to access to a more restricted perimeter, then you need to change the existing filter as explained above. |
Refresh a Data Source or a Workbook
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.
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
Go to Business Warehouse Troubleshooting section
