Nested Formulas
In a nested formula, a given part of that formula is calculated by another formula.
The functionality described in this topic applies only to systems based on SAP HANA, which enhances capabilities and improves performance of SAP Business Planning and Consolidation. If you are not using an SAP HANA-based system, disregard the information in this topic.
Prerequisites
You must have the SAP HANA Component for Business Planning and Consolidation HANABPC SP05 installed on your system.
Use
You can create a nested formula in which the different parts of that formula are calculated by other formulas.
A = B + C
B = D - 6
C = F * E
In the example above, the formula A is calculated by B and C. In turn B and C are also calculated by formulas.
Nested formulas are only supported by the HANA MDX engine. The HANA MDX engine significantly improves the performance when executing complex calculations on large amounts of data.