Drivers and Rates Models
Non-reporting models support reporting models by holding data such as prices or rate information.
Features
Drivers and rates models support reporting models by holding data concerning currency exchange rates and ownership percentages. You can report on drivers and rates model data. You cannot define business rules to these model types. The following table describes the different types of drivers and rates models and lists the required dimensions for each:
|
Type of Drivers and Rates Model |
Description |
Required Dimensions |
|---|---|---|
|
Rate |
A rate model is a supporting model for financial and consolidation reporting models. It is used to store exchange rates that support currency conversion in financial models. The time dimension must be identical to the dimension used by the models using the rate model to store their foreign currency exchange rates and must have the same category member IDs. This model must include a currency dimension detailing the exchange rates by each input currency. The currency dimension in a rate model does not need to have the REPORTING property. |
Account (A) Category (C) Entity (E) Time (T) Currency (R) |
|
Ownership |
The ownership model is a supporting model for a consolidation reporting model. It stores information such as the consolidation methods, ownership percentages, and group roll up information used for legal consolidation. |
Account (A) Category (C) Entity (E) Time (T) Intercompany (I) Group (G) |
|
Generic |
A generic model has no special requirements other than the four required dimensions. Generic models have no default business intelligence. Therefore, to apply logic, create it using script logic. |
Account (A) Category (C) Entity (E) Time (T) |
For detailed information about the setup of these dimensions, refer to Dimension Setup in Dimension Library.