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 Vintage
by Strategy
Custom hierarchies - Scenario Reporting
With the “Scenario Reporting” users can create custom portfolio hierarchies, to be used in reports, accross the solution.
Where the functionality can be found
How the functionality is used
How the functionality is used
Prepare for a new custom hierarchy
Choose the Base hierarchy to start with
Reset the existing Scenario Reporting, based on applied hierarchy
Add hierarchy level
click on green button to add hierarchy
complete the wizard
Delete hierarchy level
click on red button to remove hierarchy
Move the positions to the right hierarchy level
click on 4-arrow icon in “move member” column
choose in wizard where to move
Use the new custom hierarchy in reports
go to a report, e.g. “aggregate portfolio”
Select from “Fund Breakdown” filter the “scenario reporting” from the drop down.
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.