Page tree


You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

1.0 Overview




Business Context and Application Overview

This document describes Environmental & Rehabilitation (ER) expenses reporting built in BW for ERD (Environmental Rehabilitation Department) and HSE (Health, Safety, Environment)

Application User Profile

For these queries the access is provided based on the BW menu and it's done via Service one. 

Target Users:

Solvay resources (~140 users)

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

15.09.2023

Inês Vilares

Initial draft









Application Type


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
  • 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

BW - Environ. & Rehab. database (Core Workbook)

This report contains all the information regarding this scope as a database where the users can check for the specific order types for the following measures/values:

  • Actual values for all months of the year selected in Local and Target Currency;
  • YtD data until the period selected in Local and Target Currency;
  • Total amount for previous year in Local and Target Currency.. 

Mandatory:

  • Conso. View;
  • Fiscal year/Period;

Optional:

  • Auth. scope based on Comp. Code;
  • Target Curr. for conversion;
  • Order Type;
  • Company Code;
  • Cost Element;
  • Mngt country;
  • Mngt zone;
  • Order;
  • Source system;
  • 2 - CE grouping;
  • 3 - CE grouping.
BW_WBK_ER_0002BW_QRY_MVCOOP01_0002
BW - Environ. & Rehabilition expenses analysis (Core Workbook)

This workbook contains the same information as the "BW - Environ. & Rehab. database (Core Workbook)" but splitted by sheets:

  • Selected Quarter - show the values until the quarter based on the period selected for actuals and actual from CO area, YtD for the year selected and previous year and we also have the measure for commitments in Local and CO area currency;
  • Periodic - show the actual values in Local currency and the actuals from CO area, YtD for the year selected and previous year and we also have the measure for commitments in Local and CO area currency;
  • Quarterly - show the actual values by quarter in Local currency and the actuals from CO area by quarter until the end of the year selected, YtD for the year selected and previous year and we also have the measure for commitments in Local and CO area currency;

Mandatory:

  • Conso. View;
  • Fiscal year/Period;

Optional:

  • Auth. scope based on Comp. Code;
  • Target Curr. for conversion;
  • Order Type;
  • Company Code;
  • Cost Element;
  • Mngt country;
  • Mngt zone;
  • Object Class;
  • Order;
  • Source system;
  • Vendor;
  • 2 - CE grouping;
  • 3 - CE grouping.
BW_WBK_ER_0001BW_QRY_MVCOOP01_0001

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
ApplicationBW reports under ER - Environmental & Rehabilition expenses analysis
ProviderMVCOOP01




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 data load is once per day in the early morning..