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 |