Hi!
We are historical users of OLAP option. Considering migration to IM+AV
While doing POC hit a major issue. We are unable to define multiple aggregates per measure in Analytic View.
This is important as we are trying to avoid COUNT DISTINCT with MAX-SUM aggregation.
Documentation states: "Each base measure may specify a default aggregation. The aggregation may be a simple operation like SUM
or AVG
, or a complex nesting of operations that vary by attribute dimension.". We were not able to find any examples of this declaration.
Question: How is it possible to define multiple (nesting) aggregations per measure in Analytic View?
Thx!
Regards,
Kirill