IS users can access the BW Private Space. |
Business Warehouse (BW) is an SAP tool that can be used to extract reports with data coming from the transactional systems and mainly RCS. Users can use the Analyser, an excel add-on, to connect to BW and then select a report to execute. The result of the report will directly be extracted in Excel.
Reports are organised by Applications (represented as 'Roles" in the Analyser)_corresponding to_functional areas. Each user is given access to one or more Applications based on needs.
To get BW installed on your PC you need to request it from your local SBS - IS - Infrastructure support.
You cannot install SAP Business Warehouse by yourself because admin rights are needed on the PC to do so.
To check if BW has been installed, check if you have the Business Explorer Analyser in your programs :
!Attachment Library^Analyzerinstall.JPG|cleanup="null" kids="null" pendingsrc="null" !
If you do not have the "Analyser (SAP BW 3.x)" in your programs then BW has not been correctly installed.
If necessery you can also check the version installed (see How To)
To get a new BW account (or to modify/delete your existin account) the process is different depending on the server.
Account creation can take several days to due required approvals (Based on the applications and perimeter the security team will request several approvals).
Note that after your first connexion your password will have to be changed.
For PQ1 BW access there is currently no form. To request an access, please send an email to the APPLICATIONS HELPDESK. Please provide your job description, scope and if possible explain what kind of reports you are interrested in. The support team will determine your access based on your explanations.
Support and training for Business Warehouse can be requested the same way as any other IS tool.
See the general Getting Supportand Getting Training pages.
For Account unlocking and password resets on WBP, you can use the Password Self Service on the |SAP GRC Access Control >http://pyjsapr3.ibm.be.solvay.com/AE/index.jsp||rel="__blank"]page : |http://pyjsapr3.ibm.be.solvay.com/AE/index.jsp>>http://pyjsapr3.ibm.be.solvay.com/AE/index.jsp]
The name of the program used to access BW reports is called the Business Explorer (BEX) Analyzer
Currently 2 versions of the Analyzer coexist :
At this time, most users are trained and use version 3, but we are starting to rollout version 7 on some applications.
| Analysis (New version) | Bex Analyzer 3.x (Legacy) | Bex Analyzer (Legacy) |
|---|---|---|---|
Program | !Attachment Library^AnalysisProgram.png]]|[[imageAnalyzer3program:png|style="DISPLAY: block; MARGIN-LEFT: auto; MARGIN-RIGHT: auto"! | !Attachment Library^Analyser program:png|! | |
Tool bar | !Attachment Library^]]|[[imageV7Toolbar:png! | ||
Basic User Guide | |||
Query Refresh Quick Guide | |||
Workbook Quick Guide | |||
Advanced User Guide | |||
Converting Workbooks |
| ||
Exercice/Correction |
|
The BW reports are organised into "Applications", which are basically functional groups of reports.
In BW each application is represented by a "Role" - A folder that contains the reports.
As we currently have 2 BW production servers from the legacies, the applications list are different.
Code | Name | Access by | Scope | Description |
|---|---|---|---|---|
AU | Authorisation Follow Up | Rhodia Legacy | RCS Authorisations - GRC | |
CATS | Time Sheet | Personnel Area | Rhodia Legacy | Cross Application Time Sheets reporting from RCS |
COPC | Production Costs | Plant | Rhodia Legacy | Cost estimates, components & Activities, material yeld... |
FC2 | Fixed Costs | Plant | Rhodia Legacy | Enterprise Fixed Costs reporting |
FIAA | Fixed assets accouting | Company | Rhodia Legacy | Reporting on the RCS fixed assets |
FIAP | Account payables | Company | Rhodia Legacy | Vendor accounting : balances, overdues... |
FIAR | Account Receivables | Company | Rhodia Legacy | Customer accounting : balances, overdues, credit... |
ITC | Credit Management | Company | Full Solvay | New credit management reporting (With both legacies, including CICC & Acetow data - with master data based on PRS) |
FIGL | General Ledger | Company | Rhodia Legacy | General ledger reporting : balances |
FISCA | Supplier Credit Automation |
| Rhodia Legacy | Reports for the supplier credit optimisation process |
Company Or GBU | Rhodia Legacy | Working Capital by company or GBU reports | ||
CBS | Function Costs | Function & Company & Family | Full Solvay | Functions/Shared Services fixed costs reporting. Includes Legacy-Rhodia & Legacy-Solvay perimeter. Now includes the PEC (Costs but not CASH OUT/CAPEX). |
Zone (All or AP) | Rhodia Legacy | Purchasing function reporting | ||
GTS | Global Trade Services |
| Rhodia Legacy | Import/Export reporting |
Company | Rhodia Legacy | Inventory and stock movements reports | ||
| Rhodia Legacy | Statistics on RCS usage | ||
OC | Order Changes | Company & Plant | Rhodia Legacy | Sales orders history reporting |
PM | Plant Maintenance | Company | Rhodia Legacy | Maintenance orders, notifications and operations (hours/costs/counting) reporting |
PP | Production Planning | Company | Rhodia Legacy | SOIP Reports - Actual/MRP production, Consumption, Sales & Procurement |
GBU & Family | Rhodia Legacy | PEC, CASH, CAPEX reporting - WBS elements costs | ||
PU | Purchasing For Plants | Company | Rhodia Legacy | Purchasing reporting for non-purchasing function users |
QM | Quality Management | Plant | Rhodia Legacy | QM Lots reporting : individual results and statistics |
TR | Transportation Costs | Company | Rhodia Legacy | Shipment costs analysis reporting |
EHS | Substance Volume Tracking |
| Rhodia Legacy | |
Value Stream | Rhodia Legacy | Industrial Dashboard detail reports by value stream |
In addition to these applications, there are some complements that can be selected in the BW Access form that will give additional rights but without giving a new role :
Name | Description |
|---|---|
PS Complement | Allows to enter the planned PEC and CAPEX directly in the BW report |
FIAP Complement | Account Payables Optimisation |
All applications scope are Solvay Legacy and do not include Rhodia Legacy data.
Code | Name | Description |
|---|---|---|
FI | Financial Accounting | |
| Credit Management | |
| Overhead Cost Controlling | |
| General Ledger Accounting | |
PCA | Profit Center Accounting | |
| Production Costs (PRG) | |
PCO | Product Cost Controlling | |
COPA | Profitability Analysis | |
AP_WC | Working Capital AP | |
| Gross Margin Analysis | |
P&L | P&L and Consolidation | |
IM | Investment Management | |
FAS | FAS Connect | |
| IAM Applications | |
| Collections Management | |
| Dispute Management | |
| Yearly IT reporting - Costs | |
| BI Statistics | |
LE | Logistics Execution System | |
PUR | Purchasing | |
| Vendor Evaluation | |
| Production Plan & Cont | |
QM | Quality Management | |
| Solvay Stocks | |
INFBR | Incoming Notas Fiscals | |
ONFBR | Outgoing Notas Fiscals | |
| SAPL Costs & LCM | |
| Global | |
| US History | |
| SAPL | |
| Solexis | |
PM | Plant Maintenance | |
PS | Project System | |
| Cross Application Timesheets | |
SALES | Sales & Distribution | |
| Sales Force | |
TP | Transfer Pricing |
In BW the data is not updated in real-time The data is copied from the different sources periodically.
+For the WBP server (Rhodia legacy BW) :
Example :
If you modify a document in RCS, you will usually need to wait until the next day to see the impact in BW reports (with exception of the D4 loading scheduled applications)
You can now check the loading status of each BW application (WBP only) in live via the |Loading Status >http://issp.priv.rhodia.com/issp/report/loadingStatus.do]* page in the IS Support Portal.*
The page shows a table which is continuously updated with the progress and times of each loading.
Example :