Skip to Content
avatar image
Former Member

Missing Measurement in BEX: Weighted Average Unit Price (Variance)

Hi All,

I found issue in Savings Analysis Report that the value of Weighted Average Unit Price (Global Curr/Global Unit) (Variance) is 0.

When I investigate this in BEX Query Designer, I couldn't find this measurement in Query: Spend Analysis Final (0ASA_MP01_Q1002) even though it's displayed in SPM GUI (Java).

I couldn't find the definition of this measure in Note: 1915678 - SPM Key Measure Definition

Anyone of you know the definition of this measurement? What's the formula? Is it using standard aggregation/exception aggregation?

If it's exception aggregation, could you provide the detail?

Thank you

Satria

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 29, 2015 at 07:26 PM

    Hi Satria,

    I did find it in BEx.

    Weighted Average PO Unit Price (Global Curr/Global Unit)

    0ASA_MP01_CK106A

    Aggregation-Use Standard Aggregation

    [0XSAPOA]/[0XSAPOQ]

    Kind Regards,

    John

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi John,

      Thank you for your prompt reply.

      The one that you mention in here is different with what I need.

      Weighted Average PO Unit Price (Global Curr/Global Unit) - [0ASA_MP01_CK106A] --> I know this one exist on BEX, I can see it

      Weighted Average PO Unit Price (Global Curr/Global Unit) (Variance) ---> this one not exist on BEX but exist on SPM UI. I think the formula contain [0XSAPRVAR] Purchase Price Variance Amount.

      Do you know the formula?

      Thank you

      Satria