Level based measures limitation question

Is it accurate to say that level based measures can only be used when the group is used in the insight?  And, when that group is the only group in the insight?   I'm on 4.8.5 , if this statement is correct does it change when we update?


I'm basing this conclusion on this error message: 


INC_04050708: The group by columns in the level based measure should be used in the grouping dimensions and have the same order EDW_ENGRAVING.FCT_ENGRAVING_DATA.ORDER_NO

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Note my current workaround is to create level-specific aggregates in MVs and then create a master MV combining my atomic level data with higher level columns as dimensions:


    e.g.    An order fact might have a column AVG_CUST_ORDERS_PER_YEAR  on every row with the caveat that the aggregate function in an insight can not be additive.

  • Hi Dawson, your conclusion is correct.

    Behavior is same in the latest release as well.

    New features we are working on will have better support in the future release.

    Happy to show you demo in case you are interested. 

    Like 1
    • Anurag Malik Thank you - I wanted to make sure I wasn't creating too many extra steps to get what I need.

Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 3Replies
  • 17Views
  • 2 Following

Product Announcement

Incorta 5 is now Generally Available