General presentation

Objective of the application

Integration in WBP COSTA model of the hierarchy created in Anaplan to identify budget owner and budget reviewer levels, and the dependencies between the levels. This hierarchy is meant to be used in QlikSense Applications.

Two flat files are integrated in BW in order to load: Anaplan hierarchy levels, their related Responsible Cost Center, their description and their attributes.

This solution is temporary.

Tool Leader + IT leader of the application: 

Usage information

N/A

History

N/A

Roles & Access

Roles and access

N/A

Authorization objects

N/A

Dataflow overview

https://docs.google.com/presentation/d/1xV7_SS0oan6RmQgTHF7gsFtxLjLS5Fl4Ze7ITbSs4JY/edit?usp=sharing

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Flow Levels attributes and texts

The flat file containing Levels descriptions and Level 5 attributes is loaded in Inbound ADSO AACOCT02. Data cleaning routines are implemented:

• Characters ‘#’ are deleted for all fields
• Characters ‘!’ are deleted for level codes
• Level codes and Bridge fields are translated in upper case and spaces are deleted

For level texts loading (InfoObjects C_LEVEL1/2/3/4), duplicates data records are deleted in start routine.

For level 5 attributes loading (InfoObjects C_LEVEL5):

• ALPHA conversion is manually applied in PRS Company code routine.
• Bridge routine is converted to Boolean. Value ‘X’ is assigned:
  • If source value equals ‘X’ or ‘1’
  • Else if source value exists in RSBOOLT table where BOOL equals ‘X’ : field TXTSH, which correspond to ‘True’ value in 12 languages
  • Else if a record exists in Global Filter Master Data GLBFILT with STREAM = ‘F2G’ and RULE = ‘BRIDGE’

Flow Link Level 5 - Responsible Cost center

The flat file containing the link Level 5 - Responsible Cost center is loaded in Inbound ADSO AACOCT01:

• Characters ‘#’ are deleted in Responsible Cost Center codes
• Characters ‘#’ and ‘!’ are deleted for level 5 codes
• Level codes are translated in upper case and spaces are deleted

Then data is loaded in ADSO APCOCT18 “Link Level 5 - Responsible Cost center”:

• In start routine, all records where couple Controlling Area / Cost Center does not exist in Master Data C_COSTCTR are deleted.
• Version, Date From and Date To fields have been created for further implementation. As for now, constant values are assigned.
• Controlling Area and Responsible Cost Center values are substrings of source field RESP_CC.

Dependencies with other applications

Used by COSTA model.

Data loadings

Info providers and objects loaded

Both data flow are loaded in Process chain PC_CT_LEVEL5_HIER (“COSTA - Hierarchy Level 5 - Responsible Cost center”).

Both Inbound ADSO are cleaned up before the new loading.

Flat files are loaded in FULL mode.

Loading frequency

Loadings are not scheduled. Process chain execution is processed on demand.

Average performance

Record Keeping

N/A

Reporting

Queries End User Documentation

N/A

Main queries

N/A

Main functionalities

N/A

Broadcast

N/A

Maintenance

Known bugs

N/A

Recurring procedure

N/A

Planned Evolution

N/A