MDX

• Mark Beringer-730383

  SSCommitted

  Points: 1824

  More actions

  October 13, 2008 at 10:05 am

  #199756

  Hi

  I have a product dimension with following attributes:

  [Product Code]

  [Product Display Code]

  [Product Name] (Key)

  [Product Type]

  There is also a hierarchy of [Product Type], [Product Name]

  Using MDX I want to display all members of [Product Display Code] but they must be sorted by Product Type, so I need all the [Product Display Codes] that are of the same [Product Type] to be next to each other.

  Anyone have any ideas as I can seem to figure this out?

  Have have been trying queries like the one below but with no luck.

  SELECT

  NON EMPTY

  { Order([Products].[Product Display Code].members,

  [Products].[Product Type ID].CurrentMember,BASC) }

  ON columns,

  NON EMPTY { [Measures].[Deal Count] }

  ON rows

  FROM [SMart]

  Thanks

• Will Riley

  Ten Centuries

  Points: 1030

  More actions

  October 14, 2008 at 5:45 pm

  #884966

  Using BASC and BDESC will effectively ignore parent hierarchy groupings, so to retain them you should just use ASC/DESC

  Kind Regards, Will