Bi-kipedia

Two "dimensional modeling” techniques are generally used for modeling the data structures within a data warehouse context. These are the "star schema” and "snowflake schema” techniques. Both find their roots within the Kimball dimensional modeling techniques. Properties of the snowflake schemas :

A query is a question to a database, translated in a SQL-language which results in a particular data set being returned.

A mandatory property for the account dimension. There are 4 different account types: -AST: used for assets (BS) -LEQ: used for liabilities and equity (BS) -INC: used for income (P&L) -EXP: used for expenses (P&L)

A mandatory property for the account dimension. There are 4 different account types: -AST: used for assets (BS) -LEQ: used for liabilities and equity (BS) -INC: used for income (P&L) -EXP: used for expenses (P&L)

A mandatory property for the account dimension. There are 4 different account types: -AST: used for assets (BS) -LEQ: used for liabilities and equity (BS) -INC: used for income (P&L) -EXP: used for expenses (P&L)

A mandatory property for the account dimension. There are 4 different account types: -AST: used for assets (BS) -LEQ: used for liabilities and equity (BS) -INC: used for income (P&L) -EXP: used for expenses (P&L)

A mandatory property for the account dimension. There are 4 different account types: -AST: used for assets (BS) -LEQ: used for liabilities and equity (BS) -INC: used for income (P&L) -EXP: used for expenses (P&L)

Used by the currency conversion business rules. Balance sheet accounts are typically flagged as END, as they are converted at END rate, Pal accounts are typically flagged as AVG.

The rates are stored in the Rate application. It is a supporting application used in planning and consolidation applications.

IFRS is short for International Financial Reporting Standards. It is a general accepted accounting valuation method that allows international benchmarking between companies that belong to the same industry sector.