The business structure is reflected in Apliqo FPM using the Company dimension and up to four business segments that can be used flexibly. The Company serves as the balancing entity and determines the currency of the Local currency. The business segments might be; Cost Centers, Profit Centers, Departments, Customers, Products or Locations of the business. It will depend on the requirements of the Apliqo FPM implementation. Both the Company dimension and the Business Segment dimensions will define the level of detail that data that is stored in the General Ledger cube. The FIN General Ledger cube is the main cube for reporting and analysis.
...
Rollups verses hierarchies. Rollups are relatively simple to implement and understand, making them suitable for straightforward for your reporting needs. Hierarchies provide greater design flexibility and provide new insights. Using our example above, having a Cost Center by Location and Cost Centers by Managers hierarchies mean that these two hierarchies can be cross-tabbed in the same report to see the performance of the Cost Centers by Location and General Manager.
Required Elements
All dimension dimensions have the default hierarchy . The that is the same name as the dimension. Every business segment hierarchy dimension must have the consolidated top node, “Total FIN BSEG x” and the leaf element of “NA FIN BSEG x”. Where , where x is the business segment dimension’s index. The Company hierarchy has must have the consolidated top node, “Total FIN Company” and the leaf element of “NA FIN Company”. Many other dimensions/hierarchies use the same naming principle convention for the top node of the dimension/hierarchy and the default leaf element. Do not delete these elements as they are important to the operation of Apliqo FPM.
The “Total FIN BSEG x” and the “Total Accounts” consolidations are used to reconcile the balancing entity. The “Total FIN BSEG x” rollup in the business segment hierarchy must include all the leaf elements of the business segment. Other rollups and alternate hierarchies do not have to include all the leaf elements. They will be defined by the business requirements. The “Total FIN BSEG x” rollup is considered the correct total that all other totals are compared to. The same applies to the FIN Company and other dimensions in Apliqo FPM.
...
Deleting a leaf element can lead to a loss of data. When updating the hierarchy the leaf elements of a hierarchy are unwound from the rollup instead of being deleted. The rollup is rebuilt from the hierarchy definition defined stored in Apliqo FPM. Any leaf elements that are not part of the new hierarchy definition becomes become orphans in the hierarchy. These orphan leaf elements should be reviewed, wither after the hierarchy definition has been updated in Apliqo FPM or the leaf elements can be manually deleted from the hierarchy.
...