Forum Stats

  • 3,825,053 Users
  • 2,260,461 Discussions
  • 7,896,399 Comments

Discussions

Moving from OLAP->IM+Analytic Views

User_MVDEF
User_MVDEF Member Posts: 6 Blue Ribbon
edited Feb 21, 2020 2:56PM in OLAP

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

User_MVDEF

Best Answer

Answers