Insight (OBIEE): Demystifying unique totals
Have you noticed a difference in ‘unique totals’ between Classic and new Insight? New Insight delivers more accurate ‘unique totals’ than Classic Insight.
Insight aggregates unique totals differently than Classic Insight. So, when columns like unique open, unique open rate, unique clickthroughs are totalled, you will see values different than you saw in Classic Insight.
Let’s break down why there is a difference.
Here is a sample report comparing Classic Insight and Insight.
If you didn’t notice, here is the key difference: unique opens and as a result unique open rate: