General presentation

Objective of the application

The objective of this application is to allow BFC Capex vs BW project reporting (PeC and Cash) data reconciliation: it mainly means providing a detailed view of all BFC CAPEX components (PeC/AuC, PeC/FXA, Fixed Asset Supplier, and Lease debt), to be available on a wide range of axes also shared with BW PeC and Cash solution.

The reporting coordinator is Sandrine Micollet.

Usage information

History

This application was created in 2016 but it shares some cubes with the already existing Project costs application.

Roles & Access

Roles and access

Role Code

Role Description

Explanation

ZR_RCS_CA_M50

CX - CAPEX Analysis

Role menu for all CAPEX queries

ZBI_RCS_CX_A01

Application CAPEX analysis - End user role :

Application Role:

End User rights
gives access to infoproviders of Infoarea "IA_FMCO_FICX*"
BI Analysis Authorization "ZBI_CAPEX" ("*" for authorization objects not relevant for the application)

Authorization objects

Link to the BW Catalog of role

https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I

Dataflow overview

$TECHNO - BI TEAM > BW RTR - CAPEX (WBP) /!\ Obsolete /!\ > image2017-4-21 14:49:14.png$

https://drive.google.com/open?id=17Agt7EWrCz5E2wBQJQiCXo6M0UsLfkR7D7ifW8dLPlY

Reporting documentation drive folder:

https://drive.google.com/open?id=0B03hryo6pwqdVGhoaV9BMXV4MzA

FI-GL for CAPEX documentation

These flows contain all the FI-GL data used for the calculation of the CAPEX FI key figures (Key figures "FI Detailed posting" and "FI CX accounts"):

https://wiki.solvay.com/x/KqixAQ

FI-AP documentation

These flows contain all the FI-AP data used for the calculation of the CAPEX FI key figures (Key figures "FI Detailed posting" and "FI CX accounts"):

It is part of Working Capital documentation:

https://wiki.solvay.com/x/ZqA_AQ

BFC documentation

This flow contains BFC data used for the calculation of the CAPEX BFC key figures

It is part of Working Capital documentation:

https://wiki.solvay.com/x/ZqA_AQ

Cash Out documentation (PeC & Cash):

This flow contains FI data used for the calculation of the CAPEX Project key figures

https://wiki.solvay.com/x/1Lo_AQ

Reporting

Queries End User Documentation

Main queries

Reports are available via workbooks published in the Roles menu.

Role menu "CX - CAPEX Analysis" (ZR_RCS_CA_M50)

$TECHNO - BI TEAM > BW RTR - CAPEX (WBP) /!\ Obsolete /!\ > image2017-4-21 14:44:25.png$

Main functionalities

Complex formulas: most of the key figures definitions contains formula variables in order to calculate the "conso" view and use the "enlarge to PM" option.

Currency conversion: key figures are available in local currency but can be converted according to a target currency entered in a query prompt.