Post reply

Order Function Users

  • July 26, 2005 at 2:08 am

    #110789

    if any buddy use this Order Funtion on Dimensions then write the Syntax of

    This function with example

  • July 29, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • July 31, 2005 at 5:07 pm

    #578390

    Below is a simple example.  There is more power in this function when you use the breaking order (ie orders the items regardless of their position/location in the hierarchy).

    WITH

     SET SampleSet AS '{[Customers].[All Customers].[USA].[USA].CHILDREN}'

    SELECT

     Order(SampleSet, [Store Sales], ASC) ON 1,

     {[Measures].[Store Sales]} ON 0

    FROM

     [Sales]

    Steve.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply