Overview of Financial Reporting OLAP Data Model

The Financial Reporting OLAP data model supports analysis from the enterprise level down to individual business objects and uses the standard OLAP functionality.

This documentation provides an overview of the data model components and customization options.

Key features

The key features of the Financial Reporting OLAP data model are:

  • Versions: Actual, budget, or forecast data for financial statements such as the balance sheet, income statement, or cash flow.
  • CAPEX: Data support for the Capital Expenditures Analysis report in Financial Reporting.
  • Strategies and Objectives: Data for the C-Suite dashboard with strategies and objectives.
  • Metrics and KPIs: Predefined financial metrics and key performance indicators with online calculations.
  • Fiscal Calendar: Support for multiple fiscal calendars per entity.
  • Accounts: Support for multiple local charts of accounts and one group chart of accounts.
  • Cash Flow: Support for an indirect cash flow with parametrization.
  • Currencies: Support for multiple currencies.
  • Sign conversion: Support for the global and KPI sign conversion to show the sign of data based on customer needs.
  • Perspectives: Views that show combinations of hierarchies and dimensions within data cubes.

    For more information, see: Perspectives

Administration

The data model is published in Business Modeling. Customization of standard cubes and dimensions outside Business Modeling is currently limited. You can extend the model by creating additional custom cubes and dimensions. Custom cube rules and their order are preserved in standard cubes when the Financial Reporting data model is being published.