All of the quantity data in our cube is in Kilograms, is there a way to allow the user to select Kilograms or US Pounds for quantities? The difficult part is the units associated with the quantity should appear in Excel as KG when the user selects KG, and LB (pounds) when the user selects pounds.
The paper "How to Report Data in Alternate Units of Measure" is much more extensive than we would like, it is inefficient (a select for each distinct 0MATERIAL), requires a change to SAP standard function module, and requires maintenance of all material units in pounds. We were hoping for a simpler solution.
Thanks for your input!