SAP Knowledge Base Article - Public

2885236 - Only local currency shows in story regardless of currency chosen in SAP Analytics Cloud for Planning (SAC)

Symptom

A planning model with currency conversion enabled does not show any currency conversion regardless of the currency chosen in a story.

An alternate symptom is that some account members show currency conversion while others do not.

Other models on the same tenant may work as expected using the same currency conversion table as the problematic model.

There are no error Messages.

All the currency rates are maintained.

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

Create a planning model with currency conversion enabled.

Assign an Account dimension where dimension members.

Cause

This issue occurs if:

  1. there is no rate type specified for account dimension members. For instance you may not wish to specify a rate type if all the data being imported is already normalized and you do not wish to have any sign reversal on the data
  2. AND the "Units & Currencies" column is blank.

In this case the code logic of SAC considers the dimension members as NFIN (non-financial) and does not apply any currency conversion.

Resolution

Add the CURRENCY value to the "Units & Currencies" column for SAC logic to consider account members as financial data and apply currency conversions.

See the following help guides for more information:

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, , KBA , only local currency shows in story regar , why the currency conversion is not worki , error in currency conversion , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0