Skip to Content
avatar image
Former Member

Exceptional Aggregation AVG in BO-Cloud

Hi there,

currently when using the AVG as aggregation, only one dimension as exceptional aggregation can be selected. For other aggregations types like SUM more than one dimension can be selected.

Will the AVG aggregation combined with multiple dimensions available in future?

Thanks

Best regards

Patrick

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    Jan 09, 2017 at 11:41 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 06:58 PM

    Hi Patrick,

    The help says you can select 1-5 dimensions. Are you not able to?

    https://uacp2.hana.ondemand.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/15d49a3a617a4f608a7b7a27c129be85.html?search=exception%20aggregation

    Exception Aggregation Type attribute.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2017 at 08:42 AM

    Hi,

    If using AVG Aggregation I am able to use only 1 dimension as exception aggregation dimension.

    When adding one more than 1 dimension, the cell is being highlighted red.

    Any chances to solve this issue?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2017 at 09:02 PM

    Hi Patrick,

    The warning / error message that appears is "Only one dimension is allowed if no formula is set"

    This is also documented in the help:

    Exception Aggregation DimensionIf an exception aggregation dimension is required for the member (depending on the account type or aggregation type), enter it here. Choose a dimension from the dimension selector dialog, which shows all dimensions in the model and the built-in Time dimension.

    If no formula is specified, only one dimension is allowed. Otherwise, up to five dimensions are allowed (except for FIRST and LAST, which can have only one dimension).

    What are you trying to achieve?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2017 at 07:44 AM

    Hi John,

    we are facing the critical requirement to plan percentages (%) from a top-down perspective . The top-down value should be distributed to a lower granularity.

    For example "Sales growth (%)" is planned on:

    • Yearly level (value on Year 5%) = Disaggreagtion to Months (value on all months 5%)
    • Top-level of organization (value on top-level 5%) = Disaggreagtion to profit centers (value on all profit center 5%)
    • Top-level of Product Groups (value on top-level 5%) = Disaggregation to products (value on all products 5%)

    Since it is a percentage value, the value should be "copied" to the lower granularity- not "allocated".

    After the top-down planning phase, the bottom-up planner can modify the percentage and on parent level it is shown as AVG value.

    How can we achieve this requirement with BO-Cloud?

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2017 at 10:01 PM

    Hi Patrick,

    What are the dimension settings for that Sales growth (%) account?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi John,

      the dimension settings are shown in my screenshots above.

      Exception Aggregation: AVG

      Exception Aggregation Dimension: Time (here we need to add more dimensions, but currently not possible)


      Thanks!