I was wondering if anyone has insights on the potential performance impact of using ConsolidatedAvg() in a rule. My goal is to apply it only at the C level within a rule structured like this:

[Sales] =C: ConsolidatedAvg(3, '', !Versions, !Currencies, !Sources, !Regions, !Periods, !Countries, !Article, 'Sales');

Thanks

I use this all the time and as long your cube dimensions order is optimized, this will not cause any performance issues

I was wondering if anyone has insights on the potential performance impact of using ConsolidatedAvg() in a rule. My goal is to apply it only at the C level within a rule structured like this:

[Sales] =C: ConsolidatedAvg(3, '', !Versions, !Currencies, !Sources, !Regions, !Periods, !Countries, !Article, 'Sales');

Thanks