Not loaded since 2019

Access Management

Roles and access

List of application role + menu role  and explanation if we have several applications role with specials rules.

Role CodeRole DescriptionExplanation

ZBI_RCS_CO_A24

 GBU Fixed Cost

Application role

ZR_RCS_CA_M53FC - GBU Fixed CostRole Menu

Authorization objects

List of autorisation objects mandatory for the application.

Authorization objectExplanation

C_RESP_CC__CPFCTR1_2

CPFCTR1_2

ZR_*_CA_P05

C_RESP_CC__C_RPLANT

C_PLANT

C_COSTCTR__C_RPLANT

ZR_*_CA_P02

C_RESP_CC__C_AUTHMA

ZR_*_CA_P00
C_COMPCDE__C_COMPPRSZR_*_CA_P07
Company (C_COMPCDE)ZR_*_CA_P01

Dataflow overview

Dataflow :


Datasource on a flat file →  DSO  → Infocube


General presentation

Objective of the application

In Fixed costs analysis add budget information.

The objective is to upload budget from excel files.

History

Rtr team is the requester of this project (june 2018).



Functional and Technical rules on Workbench + Reporting

Rules & Explanations

09/19/2023: Last load of DSO → 04/23/2019

A Datasource on a flat file.

Mockup of source file : 

https://drive.google.com/file/d/1z8TM7hfFN-_XlFfBwDJuHVTAJmiHC8cYLYeRlSq7oEM/view


DSO DBBUDG01 :

Be careful : in the key, they are BFC Global Business Unit and BFC Group of activities : in the mockup, only one line with one GBU but more BFC Group of activities.


Transformation between datasource DTS_CO_BUDGET_FIXED_COSTS  and DSO DBBUDG01 :

It's an expert routine :  - read table company for fiscvarnt

                                     - add one line in DSO for each activity group not initial   (to put a budget to 0 add  activity group with value 0)

Transformation between  DSO DBBUDG01 and Infocube CUB_FB001 :

Only direct mapping except : 0CALMONTH (Time characteristic conversion)

                                               0CALQUARTER (Time characteristic conversion)

                                               C_INFOPRO (constant  name of DSO : DBBUDG01)


Multiprovider :
The Infocube CUB_FB001 is added on on the multiprovider MPR_FC003 (Fixed costs Analysis (Multi Systems))

Reporting

Queries End User Documentation


Dependencies with other applications


Data loadings

Info providers and objects loaded

The loading run the process chaîn PC_FIXED_COST_BUDGET. This process chain is a direct scheduling with event "PC_FIXED_COST_BUDGET".


Loading frequency

 Loading on demand with transaction : ZBW_BUDGET_LOAD (program ZBW_LOAD_FLAT_FILE_BUDGET).

The user must create or modify a file data and chosse this file in the transaction.

Average performance


Key FigureEstimation
~ Average Process Chain Runtime
~ Average nb of rows loaded per load
~ Total nb of rows loaded (if full)
~ Average Runtime for 10k lines

Record Keeping


Main queries

Query:
BW_QRY_MPR_FC003_0008 is modified : add Calculated and Restricted key-figures.

Main functionalities

Give detail on all complex functionalities: list most important and/or complex KPI, query jump, alerts

Broadcast

Indicate if there are broadcasts and give some details on the broadcast settings.

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