Analysis for Excel - currency conversion types available?

[#1]

Dear SAP Community,

I am trying to figure out how I can edit the dropdown list with available currency conversion types in analysis for office. E.g. I insert an Infocube and browse through it and I can translate the data with predefined in rscur conversion types. But in the dropdown list only some of the available ones are shown:

So I have conversion type 1 and 2 available. Conversion Type 3 is available in the system, but not in my drop-down in analysis for excel.

Thank you in advance for any helpful answer!

[former_member678691]

Hi

I have a same related problem.

In Analyzer, we have the option in Local Query Properties--> Currency Conversion

We have a check box for " First Apply Currency Translation from Query Definition"

How can we achieve above functionality in Analysis for Excel