To be more specific, any statistic on the cube that is calculated on the server-side on a non-sparse cube can be used with the CubeLookup() expression. Furthermore, the resulting expression can then be turned into a virtual variable if required as well.
Conclusion
We’ve demonstrated a use-case for the CubeLookup expression function, which allows us to compare the value in a particular record against the value in a particular category. with Mean(<variable>) type statistics for comparison of this record against an average value.
In the Q4 2017 release we introduced cyprus mobile number example the ‘on-the-fly aggregation’ capabilities and published two introductory blog posts on this (which you can find here and here). In this blog post we’re going to delve a bit deeper into this functionality.
Firstly, we’ll show a new type of aggregation (MaxCategory).
Secondly, we’ll show how the general functionality can be used recursively to answer more complicated questions whilst avoiding the need to create intermediate virtual variables.
In the final section, we’ll show some examples of segmentation selections that use on-the-fly aggregations within expressions to also extend the capabilities in this area.