How to use alternative Unit of Measures in add-in excel for APO DP ?

[Former Member]

Hello,

We use addin Excel to download several key-figures and build forecasts.

By default values are fisplayed in the UoM of the planning area.

This UoM can be displayed with function EPMMemberProperty( ; key-figure ; "PA_BASE_UoM")

Do you know if there is a possibility to use alternative unit of measures ?

thanks for your help

Michel

[Former Member · Accepted solution]

Hello,

We contacted SAP and it seems that there is no standard solution.

May be in next release 😉

Best Regards,

Michel Condemine

[Former Member]

Hi Michel,

See if this helps:

http://help.sap.com/download/apo_dp/EDP_HowTo_Guide_110.pdf

Local Members - SAP Advanced Planning and Optimization, Demand Planning Add-In f - SAP Library

Thanks, Nikhil

[Former Member]

Hi Gurus,

Nobody has an idea on how to convert UoM in add-in Excel for apo DP (EDP) ?

Am I asking too obvious question ?

On BEX reports, UoM are handled easily

Reporting Data in Alternate Unit of Measure in BI 7.0

scn.sap.com / docs / DOC-11561

Is there something similar in EDP ?

Best Regards,

Michel Condemine

[former_member187047]

Hi Michel,

Here you can find all relevant information about unit of measure in add-in excel for DP:

http://help.sap.com/saphelp_apodp_addin_10/helpdata/en/5a/40ea52dc7ea436e10000000a423f68/content.htm...

Best regards,

Georgia

[Former Member]

Hello Georgia,

thanks for replying

I have read carefully  sap online help and there is nothing on alternative unit of measure (UoM) used in product master. So far, what I have understood is that only UoM used in the Planning Area can be found with function EDPMemberProperty.
So my question is to know whether there is a possibility to work in  addin Excel with one of the alternative UoM of the product.