How to get reference data from another measure (It Could be JOIN/UNION)

• bagusprasojo

  SSC Journeyman

  Points: 90

  More actions

  November 23, 2010 at 12:02 am

  #388285

  Dear All,

  I have a cube that consist of :

  Measure

  Sales Return

  - Customer ID

  - Disc Amount

  - Gross

  - Nett

  - QTy

  Sales Order

  - Customer ID

  - Disc

  - Gross

  - Nett

  - QTy

  Dimension

  Customers

  - Customer ID

  - Customer Nama

  Ineventory

  - Inventory ID

  - Inventory Name

  - Inventory Category

  I want to retrive Sales Return data and its referece from Sales Order Data. Now I just display the sales return data.My MDX is :

  select

  {

  ([Measures].[Customer ID _ Sales Return]),

  ([Measures].[Disc Amount - Sales Return]),

  ([Measures].[Gross - Sales Return]),

  ([Measures].[Nett - Sales Return]),

  ([Measures].[Qty - Sales Return])

  } on columns,

  {

  ([Dimension Date].[Calendar Year].[Calendar Year].MEMBERS)

  } on rows

  from above mdx i still don't know those sales return data refer to which sales order data.

  somebody could help me?

  thx

• gtschech

  Ten Centuries

  Points: 1351

  More actions

  November 23, 2010 at 12:22 am

  #1254205

  Hi,

  to assign the returns to the orders, the corresponding ID must be a dimensio´n. Then you can select it on axis 1 and you get the sales and returns ordered by year and ID.

  Guenter