SAP Analysis for Office - Resolving MIXVU error

[Former Member]

Stuck with the MIXVU issue in AFO/BEx?

Issue: The values in the AFO column comes as MIXVU instead of actual values. Refer the below image:



Analysis: The issue arrives basically due to the KPI/Key figure in the report contains more than one currencies.

Lets understand it with an example:

In the below Image, for SO India, the Sales value is MIXVU (error).



If we drill down the report at plant level, we would get the values in different currencies (INR and LKR). The result is still in MIXVU.



After currency translation to INR, The issue is resolved as shown below:



Solution: Always translate the currency if we are expecting more than one currencies in the values of the KPI. The above issue will be resolved.

Note: If the currency translation is already taken care at the query designer level during the development of the query. It reduces this type of errors to come while executing the report. If not, then follow the above solution.

Good Day to all.

Regards,

Sagar Gupta