Adjustment Data Flow

 

Current Section is thought for Developers only and describes the back-end Flows happening during the Adjustment Creation/Edit Step. It is out of Scope of any Business user even advanced.

 

 

Step 1 - Adjustment Heading Creation (User)

> Data Entry on Text Cubes (Adj - H - * Cubes) by Adjustment Number in Screen 040 - 01 - Adjustment Creation

 

Step 2 - Adjustment Heading Creation (User Confirmation)

> Click on "Arrow" Like Layout Button

> Run of 040 - 01 Adjustment Heading Creation Procedure

> Adjustment Heading Cube is populated

 

Step 3 - Adjustment Row Creation

> Data Entry on Text Cubes (Adj - R - * Cubes) by Adjustment Number, Account, Month in Screen 040 - 02 - Adjustment Rows Editor

> Data Entry on Numeric Cubes (Credit/Debit (edit) Cubes) by Adjustment Number in Screen 040 - 02 - Adjustment Rows Editor

 

 

Cube Dimension

Step 1

(heading edit)

Step 2

(heading creation)

Step 3

(rows edit)

Step 4

(rows read)

Step 5

(credit/debit)

Conso Layer Value
Adjustment Number

O

O

O

O

O

 
Adjustment Row Nr

 

 

O

 

 

 
Layer  

O

    

O

O
Consolidation Node  

O

    

x (open sparsity)

x
Scenario

 

O

 

 

x (open sparsity)

x
Reporting Unit

 

O

 

 

x (open sparsity)

x
Month    

O

O

O

O
Intercompany

 

 

 

x

x

x
Account

 

 

O

x

x

x
Movement

 

 

 

O

O

O
Investment Cost

 

 

 

x

x

x
Custom 1

 

 

 

x

x

x
Custom 2

 

 

 

x

x

x

 

Step 4 - Adjustment Row Creation

> Click on "Confirm" Button in Screen 040 - 02 - Adjustment Rows Editor

> Execution of Procedure 040 - 02 Adjustment Rows Creations

> Adjustment Credit/Debit (read) Cubes are populated through Export Layout and ASCII Data reader

 

Step 5 - Credit/Debit Creation

> Click on "Confirm" Button in Screen 040 - 02 - Adjustment Rows Editor

> Execution of Procedure 040 - 02 Adjustment Rows Creations

> Adjustment Credit/Debit Cubes are populated a Data Flow driver by a Select based on the Heading Cube that select the proper Items for the dimensions RU,IC, Layer and Consolidation Node per Given Adjustment Number (by Page). Open Sparsity Option is Activated.

The Credit/Debit Cube now matches with Consolidation Layer Value Cube and can be there ignited during the Adjustment Post Action.

 

Notice : As you can see the Month is not linked to the Adjustment Heading but to the Adjustment Rows only. This facilitates Carry Forward operation on Adjustment Rows.

 

Recap of Target Cubes on Procedure Invocation

 

ADJUSTMENT

Step 1

(heading edit)

Step 2

(heading creation)

Step 3

(rows edit)

Step 4

(adj confirm)

Post

UN-Post

Reverse

Forward

Close on NFY

 

 

 

 

 

 

 

 

 

 

HEADING (TXT)

X

 

 

 

 

 

 

 

 

HEADING (VALUE)

 

X

 

 

 

 

 

 

 

ROWS (TXT)

 

 

X

 

 

 

 

X

 

CREDIT-DEBIT (EDIT)

 

 

X

 

 

  

X

X

 

CREDIT-DEBIT (READ)

 

 

 

X

 

X

X

X

 

CREDIT-DEBIT

 

 

 

X

 

X

X

X

X

CONSO VALUE

 

 

 

 

X

X

 

 

X