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
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.