Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Moving from OLAP->IM+Analytic Views

User_MVDEFFeb 20 2020 — edited Feb 21 2020

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

This post has been answered by Bud Endress - Oracle-Oracle on Feb 21 2020
Jump to Answer
Comments
Post Details
Added on Feb 20 2020
2 comments
385 views