SAP Knowledge Base Article - Public

2768816 - The measure value shows as negative after creating model with Account type data

Symptom

The measure value shows as negative after creating model with Account type data.

Environment

  • SAP Analytics Cloud 2019.6.0

Reproducing the Issue

  1. Prepare a sample CSV with data like below:
    Account,AccountsDescription,AccountType,Value
    0001,Sample,INC,10000
  2. Log on to SAP Analytics Cloud.
  3. Create a model with importing the CSV file
  4. Make 1st column Account as Account type.
  5. Add AccountsDescription as the Description for Account.
  6. Add AccountType as the Type for Account.
  7. Make 4th column Value as Measure.
  8. Click Create Model to complete model creation.
  9. Based on this Model, create a story.
  10. In Data tab, select the Account Sample.
  11. Find that the measure value is shown as -10000 which is negative.

Cause

This issue is judged as BY Design by Development team.

Resolution

After the model is created, re-import the CSV data with Convert value symbol by account type option check on in Mapping Options as the steps below:

  1. Import the CSV file again to the created model.
  2. In Mapping Options check on Convert value symbol by account type.
  3. In Import Method, choose Clean and replace the selected version to clear the old data.
  4. Perform the import process and check the data in story, notice that the measure value is now positive.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0