3654074 - Aggregate_dimensions() function unsupported in Data Actions – SAC

• The aggregate_dimensions() function, although documented for use in advanced formulas and scripts, is unsupported or throws errors during execution in Data Actions within SAP Analytics Cloud.
• Aggregation is not occurring at the cost center level in the planning data.

•  SAP Analytics Cloud

1. Attempt to use the aggregate_dimensions() function within a data action script in SAP Analytics Cloud.
2. Observe that the function either throws errors or does not execute as expected.
3. Verify if the model includes multiple measures, as this may also contribute to the issue.

• The aggregate_dimensions() function is part of advanced formula features that are only supported in the script editor and not in the visual tool of SAP Analytics Cloud.
• Models with multiple measures do not support the aggregate_dimensions() function due to limitations in measure aggregation.

1.  The aggregate_dimensions() function is not supported in Data Actions within SAP Analytics Cloud.
2. For models with multiple measures, note that measure aggregation using aggregate_dimensions() is not allowed.
3. As an alternative, consider restructuring the model or using supported functions in the script editor to achieve the desired aggregation.

• Refer to: SAP Analytics Cloud Documentation for further details on supported functions and limitations.

aggregate_dimensions, sap analytics cloud, data actions, unsupported function, advanced formulas, script editor, measure aggregation, planning model, cost center aggregation, sap planning , KBA , LOD-ANA-PL-DA , Data Actions , Problem