Frequently Asked Question

Symptom

• You want to display in the Multi Drill, a measure that must no be aggregated on each level of drill (for instance, a ratio or a distinct count)

Environment

• Linux/Windows Server
• Need4Viz : versions >= 2025.2

Resolution

When you provide a measure in the Multi Drill, an aggregation is automatically done by the N4V engine on each level (the sum is the default aggragation function). This works very well when you ant to display an amount or another aggregation measure.

But when you want to display a special measure like a ratio (percentage) or a distinct count, the values displayed can be wrong because the N4V engine hasn't any access to the full dataset of Webi and cannot calculate correctly the measure on each level.

We have introduced in the 2025.2 release a new specific data feed measure called "Precalculated Measure". The goal of this data feed is to provide directly to the N4V engine a measure precalculated directly in Webi for all the drill levels and only displayed as it by the component (without any additional aggregation).

For instance, in the report below, we want to display on the same drillable chart, the amount of orders (measure "Price") and the count of distinct orders (Order ID = "Num Commande") , for each categories of materials (cat level 1, 2 & 3) :

We create 3 Webi variables to calculate the count of order on each level (Count_CMD_Lev1, Count_CMD_Lev2, Count_CMD_Lev3), defined by :

Then in the Multi Drill data feed, we assign data as following ("Price" will be a standard aggregated measure, othe measures will be displayed without any aggregation) :

It is mandatory to have the same number of objects to assign the "Precalculated measure" thant there are dimension objects (for the drill levels).