Applying SolveOrder for Metadata

SolveOrder is a metadata property that can be set either for a dimension or a member that defines the order of member evaluation. The solve order is applied during query execution. When a cell is evaluated in a multidimensional query, the order in which the calculations should be resolved depends on the SolveOrder property.

See Solve Order in Member Formulas.

When using Extended Dimensionality, SolveOrder is set for the DynamicCalc members in certain dimensions. This helps in improved query performance when creating forms and adhoc-grids. All the Dynamic Calc ancestors of members that have the SolveOrder property should be set with the same SolveOrder.

In Financial Consolidation and Close, when using Extended Dimensionality, SolveOrder is set for the following dimensions:

  • Movement

  • Consolidation

  • DataSource

  • Period

  • View

For all the required seeded members of the above dimensions, the SolveOrder metadata property is seeded by default. You can add members to the DataSource and Movement dimensions. If you add any DynamicCalc in these dimensions under the seeded parent members that use SolveOrder, then you must set the SolveOrder on the new members. You should not set a SolveOrder for Custom dimensions, because it could lead to retrieval performance issues.

You apply the SolveOrder for metadata from a Configuration task. You select a dimension, and then select the SolveOrder. After you apply the SolveOrder property, a summary is displayed which lists all the members modified with the new SolveOrder, and both old and new values. Since setting the SolveOrder is a metadata change, you must then run the Refresh Database task for the changes to take effect.

To retain your customized Solve Order values, the EnableSolveOrderImport substitution variable is automatically enabled. This enables you to retain your customized Solve Order values for seeded members during application import, upgrade, or an incremental Enable Features process.

To apply the SolveOrder metadata property:

  1. On the Home page, click Application and then click Configuration.

  2. Click Apply Metadata SolveOrder.

  3. From the Dimension drop-down list, select a dimension.

  4. From the SolveOrder drop-down list, select a SolveOrder value.

    The minimum SolveOrder value is 0 and the maximum value is 127.

  5. Click Launch, then from the warning message, click OK.
  6. After the task completes, review the summary page of the values for the modified members.

  7. On the Home page, click Application, then click Overview.

  8. From Actions, select Refresh Database, and click Refresh.