Why you should learn more about the MDX Generate function

Generate() can be a little bit tricky to understand but can create information that a grid in a user interface have some problems with. If you use it together with TopCount you can add a lot of business value.

 

Let us start with a simple MDX TopCount select and later add it to the Generate function and see how the value of TopCount will change.