Database Reference
In-Depth Information
In the previous query, you have added a second dimension on the rows axis. What
youhavedoneinboththesequeriesistocalculatethesumofallthecellsinthecube
that build up the result set. In the previous query, it calculates the sum of
[Meas-
ures].[Sales Amount]
per
[Product].[Product Hierarchy].[Product
Category]
. This means that all bikes and accessories will be summed together;
you have positioned yourself in the multidimensional cube space to get the data.
Search WWH ::
Custom Search