Reporting Models

Reporting models hold financial data.

Features

The following table describes the different types of reporting models and lists the required dimensions for each:

Type of Reporting Model

Description

Required Dimensions

Financial

Financial models perform management and legal consolidation functions. They support data translations from local currencies to one or more reporting currencies, intercompany elimination calculations, and other calculations.

When you create a financial model, you must choose an associated rate model (see Drivers and Rates Models).

You can also choose to set up the following business rules:

  • Currency conversion

  • Account transformation

  • Intercompany bookings

  • US eliminations

  • Carry-forward rules

  • Validations

Account (A)

Category (C)

Entity (E)

Time (T)

Currency (R)

Consolidation

Consolidation models perform more complicated legal consolidation functions than Financial models. Consolidation can incorporate complex organizational structures involving full ownership, partial ownership, minority ownership and consolidation methods.

Consolidation models must reference an ownership model and a rate model (see Create or Modify the Model).

You can also choose to set up the following business rules:

  • Currency conversion

  • Account transformation

  • Intercompany bookings

  • US eliminations

  • Carry-forward rules

  • Validations

  • Automatic adjustments

Account (A)

Category (C)

Entity (E)

Time (T)

Audit (D)

Group (G)

Intercompany (I)

Subtables (S)

Currency (R)

Standard

Standard reporting models have no special requirements other than the four required dimensions. Generic models have no default business intelligence. Therefore, to apply logic, create it using logic scripts.

Account (A)

Category (C)

Entity (E)

Time (T)