When applying currency conversion to Balance Sheet accounts, certain financial reporting standards require different balances & movements (or "flows") to be translated using different exchange rates. These different balances & movements are usually distinguished in a separate dimension to the account dimension. For example:
Tools like SAP BPC enable this method of movement type dependent currency translation. From what I can see, there is no equivalent option in SAP Analytics Cloud. All currency conversion options, across classic account and new model type planning models, require a single rate type to be associated with a given account.
Is there a standard way of achieving this in SAC that I am missing? Or alternatively has anyone come up with creative workarounds for this requirement?
I can understand SAC does not allow custom RATETYPE. Using the new model with multiple measures I think you can achieve the same impact. You will need separate measures to hold different types of currency conversion using different rate types. In Currency Table you have to use Category as Specific and for Rate type type you can maintain the different types of rate like Ope, CLO etc. Now when you configure currency conversion data Action, Use separate measures to hold different measures to hold each of this currency translation results. Finally you can copy results from these measures to your main measures for reporting.
Please refer to the below link on how to use the specific Category and Rate Type.