Skip to Content
avatar image
Former Member

Hierarchy Aggregation Slow

Hello smart people,
Is there a way to store the aggregated data of a hierarchy or push the aggregation to the database? We have some large hierarchies and the aggregation on OLAP takes forever.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 18, 2017 at 10:52 PM

    We figured out what was going on. We have a key figure that uses exception aggregation, and we were adding it to a key figure that used standard aggregation. BEx was not performing any of the aggregation on any of the key figures because we were adding them. When we split the data in two key figures the performance improved 90% +

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 13, 2017 at 10:20 PM

    We are on BW 7.4 on DB2. We use Analysis for Office which causes pain points because we can't pull only the roll ups we want because they may want 2 nodes that are not siblings, so they have to expand the hierarchy to get it.

    Add comment
    10|10000 characters needed characters exceeded