Reporting and Analytics

Most of the reports, dashboards and analytical screens will be based on the central reporting cube of Apliqo FPM: FIN General Ledger (hereinafter referred to as the GL cube). Once the dimensional structure is understood it depends on the front end of choice as of how the report building takes place.

Apliqo FPM uses Apliqo UX as the main front end, please refer to the Apliqo UX training materials to get started: Training Materialsarchived

Cube Dimension	Usage

Cube Dimension	Usage
FIN Version	Version of the data Actual - data loaded from an external source. Working Plan - Plan that has been submitted from Planning. Snapshot - Copy of the submitted working plan at a point in time.
FIN Currency	The currency of the movement value. Local currency - Is the currency of the Company. Reporting currency - Is the converted Local Currency to a Reporting Currency.
T Year-Month	Financial periods / month on the lowest level with rollups by quarter, half-year and year.
FIN Company	The Legal Entities of the organisation.
FIN BSEG 1 … 4	The maximum available four business segments can be used at the customers discretion. Depending on the setup it can be cost centers, regions etc.
FIN OCoA	The chart of accounts, containing all important reporting structures such as balance sheet, profit and loss and all defined KPIs.
Scale	Scales the value in whole, thousands or millions.
Time Analysis	For doing time series analysis, contains measures such as year-to-date, moving annual total, previous month etc.
FIN Consolidation Value Measure	Contains different layers of data, normally "CON - Consolidated fair value" contains the full result for reporting purposes, "OPV - Operating Value", reflects data that has been imported from a source system, depending on the setup of the system additional adjustments measures might be used.
FIN General Ledger Measure	Allows for the selection of opening balance, movement or closing balance for any given period.