How to create custom drive types in icCube?

Question

How to create custom drive types in icCube?

Let's say I need WAvg (which is already implemented there) instead of the simple Avg function. But I'm not on the drop-down list in the form of creating a measure. What should I do now?

Answer 1

Alexander, I suppose you are talking about a cube-builder.

the weighted average is not available in the list of available aggregation types, because there is no easy way to implement it at the cube level. The aggregation types available for standard measures are simple calculations. These calculations are designed for very fast execution for millions of lines. You have two types of average values ​​for standard measures: "average on sheets (rows)" and "average on children", which may be next to what you are looking for.

In the case of a weighted average, you must create a calculated measure: you need to determine the values ​​for the "weight" of your base measure. The weighted documentation provides some examples.