Creating cross-hierarchical sorting with custom MDX

This example is based on the Samples application, which can be enabled in on-premises environments. It uses a hyperblock created from the Product dimension.

This expands the aggregate elements in a dimension to show all its elements without any hierarchical structure. It sorts their captions in descending order.

  1. In the List Designer create a new sorting criterion and select Custom MDX as the type.
  2. In the Edit Custom MDX dialog, specify [Product].CurrentMember.name,BDESC.