Database Reference
In-Depth Information
If you do not want your values to be grouped based on hierarchy, you can use the Break Hierarchy version
of the
Order
function. To do this, specify in the third argument that you want to use break ascending or break
descending, as shown in Listing 14-35. Figure
14-28
shows the results.
Figure 14-28.
The results of the last example in Listing 14-35
Listing 14-35.
The Break Hierarchy Argument
Select
{ [Measures].[SalesQuantity] } On Columns,
{
Order( [DimTitles].[TitlesByPublisher].AllMembers
, [Measures].[SalesQuantity]
,
BDesc
)
} On Rows
From [CubePubsSales];
When the second query is run, the results will look like those shown in Figure
14-28
. Notice that each of the
values in this example are sorted out sequentially regardless of the hierarchy.
