velocity
#if($hasEdit)
info

IS users can access the BW Private Space.

/info
#end
/velocity

html

<div>
<div style="float: left;width:100%;padding-right:1.5%;">
<table>
<tr>
<td><img src="http://frph2-appvm105.rhd.priv.rhodia.com:8090/download/attachments/3638419/introduction.png" alt="BW Introduction"/></td>
<td><div><p><span class="wikilink"><a href="/xwiki/wiki/is_support/view/BW+-+Business+Warehouse/#HBWIntroduction">BW Introduction</a></span><br/>
A short presentation of the tool</p></div></td>
<td><img src="http://frph2-appvm105.rhd.priv.rhodia.com:8090/download/attachments/3638419/content.png" alt="BW Content and organisation"/></td>
<td><div><p><span class="wikilink"><a href="/xwiki/wiki/is_support/view/BW+-+Business+Warehouse/#HBWApplications">BW Applications</a></span><br/>
Explanations on how the BW reports are organised and general description of the BW applications.</p></div></td>
</tr>
<tr>
<td><img src="http://frph2-appvm105.rhd.priv.rhodia.com:8090/download/attachments/3638419/install.png" alt="BW Installation"/></td>
<td><div><p><span class="wikilink"><a href="/xwiki/wiki/is_support/view/BW+-+Business+Warehouse/#HGettingBWinstalled">Getting BW installed</a></span><br/>
How to request the software installation, verify if it's installed and which version. First steps before using it.</p></div></td>
<td><img src="http://frph2-appvm105.rhd.priv.rhodia.com:8090/download/attachments/3638419/unlock.png" width="70%" height="50%" alt="Password reset"/></td>
<td><div><p><span class="wikilink"><a href="/xwiki/wiki/is_support/view/BW+-+Business+Warehouse/BW+FAQ#HHowtoresettheBWpassword3F">Password reset</a></span><br/>
How to reset your password by yourself or ask for Help.</p></div></td>
</tr>
<tr>
<td><img src="http://frph2-appvm105.rhd.priv.rhodia.com:8090/download/attachments/3638419/gettingaccount.png" alt="BW Account"/></td>
<td><div><p><span class="wikilink"><a href="/xwiki/wiki/is_support/view/BW+-+Business+Warehouse/#HGettingaBWAccount">Getting a BW account</a></span><br/>
How to request for a new account, ask for a modification or solve any account related issues.</p></div></td>
<td><img src="http://frph2-appvm105.rhd.priv.rhodia.com:8090/download/attachments/3638419/dataloading.png" alt="BW data loading"/></td>
<td><div><p><span class="wikilink"><a href="/xwiki/wiki/is_support/view/BW+-+Business+Warehouse/#HBWDataUpdating">BW Data Updating</a></span><br/>
Explanations on how the data is updated in BW, with what schedule and how to troubleshoot</p></div></td>
</tr>
<tr>
<td><img src="http://frph2-appvm105.rhd.priv.rhodia.com:8090/download/attachments/3638419/Support.png" alt="BW Support and training"/></td>
<td><div><p><span class="wikilink"><a href="/xwiki/wiki/is_support/view/BW+-+Business+Warehouse/#HGettingSupportandtraining">Getting Support& Training</a></span><br/>
How to request trainings, new features, corrections or simply ask for help </p></div></td>
<td><img src="http://frph2-appvm105.rhd.priv.rhodia.com:8090/download/attachments/3638419/FAQ.png" alt="BW FAQ"/></td>
<td><div><p><span class="wikilink"><a href="/xwiki/wiki/is_support/view/BW+-+Business+Warehouse/BW+FAQ">BW FAQ</a></span><br/>
Most Frequently Asked Questions about BW with an answer to each.</p></div></td>
</tr>
<tr>
<td><img src="http://frph2-appvm105.rhd.priv.rhodia.com:8090/download/attachments/3638419/UserGuide.png" alt="BW User Guides"/></td>
<td><div><p><span class="wikilink"><a href="/xwiki/wiki/is_support/view/BW+-+Business+Warehouse/#HUserGuides">BW User Guides</a></span><br/>
User guides on how to use both version of the BW BEX Analyzer.</p></div></td>
<td><img src="http://frph2-appvm105.rhd.priv.rhodia.com:8090/download/attachments/3638419/troubleshooting.jpg" alt="BW Troubleshooting"/></td>
<td><div><p><span class="wikilink"><a href="/xwiki/wiki/is_support/view/BW+-+Business+Warehouse/BW+Troubleshooting">BW Troubleshooting</a></span><br/>
A list of most encountered errors and issues with an explanation and solution.</p></div></td>
</tr>
</table>

</div>
/html

BW Introduction

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.

Getting BW installed

Requesting Installation

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.

Checking the Installation

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)

Getting a BW Account

To get a new BW account (or to modify/delete your existin account) the process is different depending on the server.

WBP Server (Rhodia Legacy)

Download the BW Form and fill it based on what you need.
Send the filled form to the APPLICATIONS HELPDESKby email.
The Security team will proceed to account validation.
Once access is validated the account will be created and you will receive by email your new user/password.

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.

PQ1 Server (Solvay Legacy)

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.

Getting Support and Training

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]

User Guides

The name of the program used to access BW reports is called the Business Explorer (BEX) Analyzer

Currently 2 versions of the Analyzer coexist :

Version 3.x : Called * nalyzer (SAP BW 3.x)* in your programs.
Version 7 : Called * nalyzer* in your programs.

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	BW Analysis User Guide	V3 Basic User Guide (Windows 7 Complement)	V7 Basic User Guide
Query Refresh Quick Guide	V3 Query Refresh Quick Guide
Workbook Quick Guide	Analysis Workbook Quick Guide	V3 Workbook Refresh Quick Guide
Advanced User Guide	V3 Advanced User Guide
Converting Workbooks	How to convert workbook from Analyzer to Analysis
Exercice/Correction	Exercice/Correction

BW Applications

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.

On WBP server (Rhodia legacy BW)

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
FIWC	Working Capital	Company Or GBU	Rhodia Legacy	Working Capital by company or GBU reports
CBS	Function Costs Function Project 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).
GSV	Global Spent Visibility	Zone (All or AP)	Rhodia Legacy	Purchasing function reporting
GTS	Global Trade Services		Rhodia Legacy	Import/Export reporting
IM	Stocks	Company	Rhodia Legacy	Inventory and stock movements reports
KPI	RCS Key Performance Indicators		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
PS	Project System	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
VS	Value Stream	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

On PQ1 server (Solvay legacy BW)

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

BW Data Updating

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) :

Most data (excluding below exceptions) is loaded * nce a day.* The data updating starts at * 2pm Paris Time and finishes around 6pm Paris Time*.
Due to closing reporting, some applications are loaded several times a day (up to 6) following the D4 loading schedule.

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.