Aggregate data is what reports are made of; speaking ANSI SQL, this means
GROUP BY. MicroStrategy applies
GROUP BY to all the attributes present on a report grid. Well, this is not completely correct, but we begin with this simple concept:
Every attribute on a grid is reflected in the
GROUP BY clause of the resulting
Hence, we have:
I hope this is clear enough, because this concepts will return every now and then with metrics. In this recipe, anyway, we'll see an example of how it works.
We are using now the
SalesAmount metric and the
Product attribute. Before going on we need ...