Database Reference
In-Depth Information
The CrossJoin Operator (*) and Function
As expected, there will be times when you would like your data to include subtotals based on a combination of
multiple dimensions. For example, you can use the
CrossJoin
function to request the subtotals of sales quantity
for all years and all titles. The
CrossJoin
function can be represented either with the
*
operator or with a function
call. Listing 14-36 shows an example of both the cross join
*
operator and the function call. The results returned
are the same no matter which version you use and are displayed in Figure
14-29
.
Figure 14-29.
The results of the Listing 14-36
Listing 14-36.
he
CrossJoin
Operator and Function
Select
{ [Measures].[SalesQuantity] } On Columns,
{ NonEmpty(
[DimDates].[Year].AllMembers
* -- This symbol is the cross join operator
[DimTitles].[TitlesByType].[Title].AllMembers
) } On Rows