locked
MDX Calculated measure for below requirement RRS feed

  • Question

  • Please tell me how to create calculated measure for the below requirement

    Sales Forward Weight

    ORS_PLN.ALOC_QTY_W – ORS_PLN.RREC_QTY_W

    Where PHD status = L, R or F

    Where Line Number does not begin with X

    Where PO Number does not contain SHR

    and can we use where clause while creating calculated measures in BIDS?

    Monday, May 6, 2013 5:37 PM

Answers

  • Hello,

      Create a calculated measure Sales Forward Weight as null.

    Then use it inside scope like below

    Scope(

    PHD status = L, R or F

    ,Line Number does not begin with X

    ,PO Number does not contain SHR,Sales Forward Weight );

    this=ORS_PLN.ALOC_QTY_W – ORS_PLN.RREC_QTY_W;

    end scope;

    Regards,

    Bharath

    • Proposed as answer by Bharath_RAM Tuesday, May 7, 2013 4:40 AM
    • Marked as answer by Elvis Long Wednesday, May 15, 2013 3:27 AM
    Tuesday, May 7, 2013 4:40 AM