Cubes

The preconfigured cubes provide for the implementation of the structures required by the sample applications.

The applications are:

  • Corporate planning and accounting
  • Sales volume and revenue
  • Cost center accounting
  • Cost type accounting
  • Currency conversion
  • Sales reporting and budgeting

This table gives an overview of the structure of the SALES, FINANCE, and COST cubes.

Dimension COST FINANCE SALES Description
PROFIT N N Y Measure dimension of SALES cube

Cost of Sales, Discounts, Gross Margin, Price, and Production Costs, Revenue, Sales Discount, Units

VERSION Y Y Y Measure dimension in FINANCE, COST, and Configuration cubes

Actual, Budget and Forecast

TIME Y Y Y Years, Months and Quarters
CURRTYPE Y Y Y Currencies

This includes local currency (LC) and other currencies

For example, EUR and USD

LEVEL Y Y Y GAAP
UNIT Y Y Y The company structure
INTERCO Y Y Y Intercompany Exchange

Used to distinguish between sales to external customers and those to internal customers

COST Y N N Cost types from the chart of accounts (CoA)
COSTCNTR Y N N Cost Centers
ACCOUNT N Y N Accounts in the CoA

The CoA depends on the selected Level (GAAP)

PRODUCT N N Y List of products