1.0 Overview




The GBU Fixed Costs applciation is part of Finance domain and we use mainly the SAP data from CO (Controlling) module to get the dat for the fixed costs and GBU level.

The application GBU Fixed Costs is used to follow Solvay’s fixed costs mainly: 

  • STOT-R330 – Administrative & Commercial expenses
  • R25460 – Non proportional costs of sales
  • R27900 – Mis production.
  • R25510 – Logistics costs.

For this Application the access is provided based on the BW menu "FC - GBU Fixed Costs" and it's done via Service one.

Fill the form
https://solvay-dwp.onbmc.com/dwp/app/#/itemprofile/622 

In SAP system select the "WBP - BW Business Warehouse" 

In WBP - BW Business Warehouse : Select the Business Role select the "FC - GBU Fixed Costs"

Target Users:

GBU and Site Controllers and Plant Management

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

dd.mm.2023

Inês Vilares

Initial draft










Data Product Type 
  • Dashboard
  • Report
  • Advanced analytics
  • AI 
  • Others <specify which one>
Technologies
  • BW
  • Tableau
  • Qliksense
  • Talend
  • Dataiku
  • Others <specify which one>

Data Sources 

Note: list of all applications and various environment

  • SAP PF1 (Production environment)
  • SAP WP1
  • SAP PI1
  • BW (versions)
  • iCare CRM 
  • CORE CRM
  • Budget flat files
  • Others <specify the name of the source> 

2.0 Business Process


Capture the business process that the application supports . This can be describe through a process diagram or a business capability model


3.0 Application Feature Overview


Information about the existent Workbooks and the respective BW queries.


ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name















4.0 Functional Specification


4.1 General Data/Calculations 

This section will approach the concepts/definitions that will be used in all the reports and required to understand the data from the reports.

Could be specific fields, closing activities, additional information to work and understand the reports.


4.2 Process Detail 

4.2.1.  Report/Process Definition 

DomainFinance
Application>insert name>
Provider<insert name>


This section represents the process with detail information for the application. Can include specific or special cases, complex logics , calculations, flows, among others.


The GBU Fixed Costs it's based in an existent model since many years ago exist a controlling model to be more accurate for the GBU needs. We take the model already developed and it was enhanced to follow the fixed costs specially in the cost center at GBU level.

We have the PF1 and WP1 systems and we are using the main CO objects cost centers, WBS and orders and with this information extracted we the data is splitted in two BW tools one side the GBU fixed costs and the other solution is CBS for the functions (This scope is explained in the "Corporate Business Services application"). For both applications we use the same data base and the same cubes but the multiproviders are different also because of the authorization part.


4.2.2. KPI's/Calculations/Indicators 

Indicators available: 

  • XXXX
  • XXXX


Indicatores/KPI's

Definition

Calculation/Extraction of data

Can be a field, a program, something that was created or the report

What are we looking for ? Why has this KPI been created/developed? What is the goal of monitoring this data ? 

How is the calculation, or if it's a program what are the steps or how the data is extracted if it's by files




5.0 Non-functional Descriptions 


5.1 Usability

5.2 Regulatory Compliance

5.3 Security

5.4 Performance

5.5 Reliability  

5.6 Scalability

5.7 Compatibility

5.8 Availability

5.9 Refresh of the Data

The loads for the GBU Fixed Costs application is the following:

Closing Time:

Outside of Closing: it's one time on a daily basis.