FINANCE cube calculations

The calculations configured for the FINANCE cube are divided into three areas.

The areas are:

  • Rules for the data transfer from the SALES cube
  • Rules for the data transfer from the COST cube
  • Rules for the currency conversion

Modifications or additions can be made to all rules in EPM Administration.The following data are transferred to the specified target accounts within the P/L statement of the FINANCE cube:

  • Net revenue on aggregated level for all products
  • Direct material costs on aggregated level for all products
  • Indirect material costs on aggregated level for all products
  • Direct production costs on aggregated level for all product
  • Indirect production costs on aggregated level for all products
  • Change in inventory on aggregated level for all products

The cube rules are preconfigured for the local currency. The currency conversion process transfers data into other currencies.

Net Revenue from Sales (N-Rule)

The syntax is:

[CURRTYPE:'LC', ACCOUNT:'I110000']
=B:DB('SALES',!TIME, !VERSION, 'LC', !LEVEL, !UNIT, !INTERCO, 'All Tires', 'Net Revenue');

Direct Material Costs from Sales (N-Rule)

The syntax is:

[CURRTYPE:'LC', ACCOUNT:'I300001']
=B:DB('SALES',!TIME, !VERSION, 'LC', !LEVEL, !UNIT, !INTERCO, 'All Tires', 'Direct Material Costs');

Indirect Material Costs from Sales (N-Rule)

The syntax is:

[CURRTYPE:'LC', ACCOUNT:'I300002']
=B:DB('SALES',!TIME, !VERSION, 'LC', !LEVEL, !UNIT, !INTERCO, 'All Tires', 'Indirect Material Costs');

Direct Production Costs from Sales (N-Rule)

The syntax is:

[CURRTYPE:'LC', ACCOUNT:'I300003']
=B:DB('SALES',!TIME, !VERSION, 'LC', !LEVEL, !UNIT, !INTERCO, 'All Tires', 'Direct Production Costs');

Indirect Production Costs from Sales (N-Rule)

The syntax is:

[CURRTYPE:'LC', ACCOUNT:'I300004']
=B:DB('SALES',!TIME, !VERSION, 'LC', !LEVEL, !UNIT, !INTERCO, 'All Tires', 'Indirect Production Costs');

Change in Inventory from Sales (N-Rule)

The syntax is:

[CURRTYPE:'LC', INTERCO:'External others', ACCOUNT:'I300005']
=B:DB('SALES',!TIME, !VERSION, 'LC', !LEVEL, !UNIT, 'unassigned', 'All Tires', 'Change in Inventory');