User defined consolidation
The database used behind Apliqo LPPM contains hierarchical structures in all business dimensions (e.g. Funds, Assets, Investors, Investment Vehicle.) Data is loaded into tables at the lowest level and automatically aggregated or “rolled up” to higher reporting levels according to the hierarchical structure. In larger dimensions such as fund or asset there can be many hierarchies which means data can be summed up in many different ways (e.g. by sector, by geography, by performance, etc.)
For example, funds can be organized by
by Region,
by Vintagemissing
by PerformanceStrategy
Custom Rollup
In addition to these pre-defined and automatically maintained categories, it is possible for any user to create their own temporary sums or “rollups” in any table based report.
| Note |
|---|
Note: that user defined consolidations are temporary and exist only for the current report being viewed. If you find you are recreating the same custom rollups often then you should request that the desired structure be created as a permanent hierarchy. |
This feature is available via the right-click context menu by selecting “Rollup” or “Custom Rollup”.
Using “Rollup” will create a sum of the selected row members with a single click without an option to set a display name for the sum. Using “Custom Rollup” allows the user to set a display name of their choosing.
On clicking apply the new sum replaces the row definition in the report.
To restore the original row selection, select the “reset” option also available in the context menu.