/* Example One: Using Tail to return the last 5 months*/

SELECT NON EMPTY
{[Measures].[QuantitySUM]} ON COLUMNS, Tail({DESCENDANTS
    ([Time].[YMD_EU].[All YMD_EU].lastchild,
    [Time].[YMD_EU].[Month_num])},5) ON ROWS
FROM [OrionCube]

/* Example Two: Using Tail to return the last 5 months of 2001 */

SELECT NON EMPTY
{[Measures].[QuantitySUM]} ON COLUMNS,
Tail({[Time].[YMD_EU].[All YMD_EU].[2001].Children},5) ON ROWS
FROM [OrionCube]

* Example Three; Displaying the top 50% of Clothes Items in the Product
Category for 2002 */
/* Using the TOPPERCENT function

SELECT
{[Time].[YQM].[All YQM].[2002] } ON COLUMNS  ,
{TOPPERCENT([Product].[All Product].[Clothes & Shoes].[Clothes].Children
,50,[Measures].[Total_Retail_PriceSUM] ) } ON ROWS
FROM [OrionStar]
WHERE  [Measures].[Total_Retail_PriceSUM]


/* Example Four; Displaying the bottom 25% of Clothes Items in the Product Category for 2002 */
/* Using the BOTTOMPERCENT function */

SELECT
{[Time].[YQM].[All YQM].[2002] } ON COLUMNS  ,
{BOTTOMPERCENT([Product].[All Product].[Clothes &
Shoes].[Clothes].Children ,25,[Measures].[Total_Retail_PriceSUM] ) } ON
ROWS
FROM [OrionStar]
WHERE  [Measures].[Total_Retail_PriceSUM]