Data, Analytics & AI Platform

Page tree


Versions Compared

Old Version 13

changes.mady.by.user GIRAUD-ext, Mickael

Saved on

compared with

New Version Current

changes.mady.by.user POLOSSON-ext, Damien

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
outlinetrue

Access Management 



Panel
borderColor#ffffff
titleColor#ffffff
titleBGColor#009EE0
titleRoles & Access

Role Code

Role Description

Explanation

ZR_RCS_CA_M09PS - Project CostsRole menu for all project costs queries
ZR_RCS_CO_A22CBS Project costs  Reporting Analysis - Key User roleKey user role
ZR_RCS_CO_A21CBS Project costs Reporting Analysis - End User roleEnd user role
ZR_RCS_CO_A20CBS Project Costs  Reporting Analysis - RCS/APM rolesuper user role
ZP2_RCS_CO_A21CBS Project costs Reporting Analysis - End User role
ZP2_RCS_CO_A21CBS Project costs Reporting Analysis - End User role
ZBI_RCS_CO_A21CBS Project costs Reporting Analysis - End User role
ZBI_RCS_CO_A22CBS Project costs  Reporting Analysis - Key User role
ZBI_RCS_PS_A02Project Costs and Structures Analysis - End User role

Application Role:

  • End User rights
  • gives access to infoproviders of Infoarea "AREA_PSCO"
  • BI Analysis Authorization "ZBI_PS" ("*" for authorization objects not relevant for the application)
ZR_RCS_CO_A21CBS Project costs Reporting Analysis - End User roleRole End User CO
ZR_RCS_CO_A22CBS Project costs  Reporting Analysis - Key User roleRole Key User CO
ZR_RCS_CO_A20CBS Project Costs  Reporting Analysis - RCS/APM roleRole référence CO
ZP2_RCS_CO_A21CBS Project costs Reporting Analysis - End User role
ZBI_RCS_CO_A22CBS Project costs  Reporting Analysis - Key User role
ZBI_RCS_CO_A21CBS Project costs Reporting Analysis - End User role

DataFlow

Overview

...


Panel
borderColor#ffffff
titleColor#ffffff
titleBGColor#009EE0
titleAuthorization Objects

List of authorization objects mandatory for the application.

Authorization objectExplanation
C_COMPCDE__C_AUTHMAAuthorization scope : ZR_*_CA_P00

CPFCTR1_2

C_WBS_EL2__CPFCTR1_2

GBU:

ZR_*_CA_P05

C_WBS_EL2__C_FAMIL

C_FAMIL

Family:

ZR_*_CA_P04

C_COMPCDECompany code: ZR_*_CA_P01

Link to the BW Catalog of role

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


DataFlow

Overview

Image Added

https://drive.google.com/file/d/1ydpFLq0IbY3Himhbsquhss01sm0LnLuWBAyCWSrDwHo/view1rKhYbUaglLB11ESjep34L9ttFZhrid_jQFc-rDFgpxc

Embedded Google Drive File
migratedtrue
urlhttps://docs.google.com/presentation/d/14v977ISlRSMYPikY6GXrJpZl5wiBVHDHja4GVg3pGhA/edit?usp=sharing
fullwidthtrue
height600

...

Reporting documentation drive folder:

https://drive.google.com/open?id=0B_p_Afe8sjVlUW1BWFR2ZElITlk/drive/folders/1G9ssgTkOrK9FW8fAsOONLMt5P4gvlymI


Technical Rules on Workbench

...

This application was created in 2013 and it replaces the former  RCS  Project costs reporting (based on multiprovider MPR_PS004) that should not be used anymore.

CASPEND (CO WBS) documentation

https://wiki.solvay.com/display/x/yro_AQIIDF/BW+CASPEND

WBSE - PM orders documentation

https://wiki.solvay.com/x/1r8_AQdisplay/IIDF/BW+WBSE+-+PM+orders

Cash Out documentation

...

 

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

Dependencies with other applications

COLMAR dso DPIPCO06 is based on a MPR_PS014 query:

Image Removed

display/IIDF/BW+Cash+out


Reporting

Customer Support Wiki (To update):

...

https://drive.google.com/open?id=1xLR2eV7ZtyYsbGeYOSVL0TCgdp-mcQzdYvbLtZWaL4c

Queries

QueryQuery description
BW_QRY_MPR_PS014_0001Projects costs & Cash out (Core Query)
BW_QRY_MPR_PS014_0003Project hours (Core Query)
BW_QRY_MPR_PS014_0004Project costs - Periodic (Core Query)
BW_QRY_MPR_PS014_0005Project costs - Actual (Core Query)
BW_QRY_MPR_PS014_0007Cum. Projects costs & Cash out (Core Query)
BW_QRY_MPR_PS014_0008Check of PM settlements (Core Query)
BW_QRY_MPR_PS014_0010WBS Element to be closed (Core Query)
BW_QRY_MPR_PS014_0011New Projects costs & Cash out (Core Query)
BW_QRY_MPR_PS014_0012New Project costs - Periodic (Core Query)
BW_QRY_MPR_PS014_0013New Project costs - Actual (Core Query)
BW_QRY_MPR_PS014_0014New Cum. Projects costs & Cash out (Core Query)
BW_QRY_MPR_PS014_0015New Detailed Cash out & Future (Core Query)
BW_QRY_MPR_PS014_0016New Projects costs/qties & Cash out/Future (Core Query)
BW_QRY_MPR_PS014_0017BW Colmar - Projects Created in WP1 and PF1
BW_QRY_MPR_PS014_007Colmar - BI IP Interface (Core Query)
QV_BW_QRY_MPR_PS014_0001Project R&I data for 1CP QS (Core Query)
QV_BW_QRY_MPR_PS014_0002BW New query (1) for QV CAPEX dashboard for Solay (Core Quer
QV_BW_QRY_MPR_PS014_0003Project hours and Costs (QlikSense Query)
QV_BW_QRY_MPR_PS014_0004BW New query (3) for QV CAPEX dashboard Solvay (Core Query)
QV_BW_QRY_MPR_PS014_1002BW New query (1) for QV CAPEX dashboard No conso. view (Core
QV_BW_QRY_MPR_PS014_1004BW New query (3) for QV CAPEX dashboard No conso. view (Core
QVCAPEX_BW_QRY_MPR_PS014_0002BW New query (1) for QV CAPEX dashboard (Core Query)
QVCAPEX_BW_QRY_MPR_PS014_0003BW New query (2) for QV CAPEX dashboard (Core Query)
QVCAPEX_BW_QRY_MPR_PS014_0004BW New query (3) for QV CAPEX dashboard (Core Query)


Workbooks:

Dependencies with other applications

COLMAR  dso DPIPCO06 is based on a MPR_PS014 query:

Image Added



Data Loading

Info providers and objects loaded

Main Process Chain

Final Provider Loading

Frequency

Time start

Duration

PC_FIPA_01CRFIPA01Daily

Closing period:

arround: 1am - 7:30am - 10:45am - 12:40pm - 2:40pm - 4:40pm - 6:40pm - 10:40pm


Outside closing period: 

arround: 1am - 7:20am - 12:45pm - 6:45pm

Arround 5 mins
PC_FIPA_05CRFIPA04Daily

Closing period:

arround: 7:15am - 10:45am - 12:40pm - 2:40pm - 4:40pm - 6:40pm - 10:40pm


Outside closing period: 

arround: 7:20am - 12:45pm - 6:45pm

Arround 5 mins
PC_FIPA_02CRFIPA02Daily

Closing period:

arround: 4:10am - 6:45am - 1pm - 5pm - 6:50pm - 11pm


Outside closing period: 

arround: 4am - 7am - 1pm - 7pm

Arround 5 mins
PC_FIPA_04CRFIPA05Daily

Closing period:

arround: 4:10am - 6:45am - 1pm - 5pm - 6:50pm - 11pm


Outside closing period: 

arround: 4am - 7am - 1pm - 7pm

Arround 5 mins
RSP_COOMCUB_PS007Daily (not saturday)1:15 am20 min
RSP_COOM_OTHERCUB6PS007Daily (not saturday)2:30 am15 min
RSP_PMCRFICS01Daily (not saturday)1:30 am30 min
RSP_PM_SOLVAYCRFICS03Daily (not week-end)2 am1 hour
PC_FIPA_05CRFIPA04Daily

Closing period:

arround: 7:15am - 10:45am - 12:40pm - 2:40pm - 4:40pm - 6:40pm - 10:40pm


Outside closing period: 

arround: 7:20am - 12:45pm - 6:45pm

Arround 5 mins


Data Quality Control

Data come from SAP system. To compare data between BW and sources systems, check propagation layers.


Operational Documentation

Procedures

<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>

Scheduling

<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>

Monitoring

<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>

Error Handling

<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>

Known Bugs

<List the existing bugs, its criticity, workarounds and resolution plan.>

Roadmap

Former Working Capital and Project Costs flow should be decommissioned in a near future.


Powered by Atlassian Confluence and Brikit Theme Press