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

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

• SAP Analytics Cloud 2019.6.0

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.

This issue is judged as BY Design by Development team.

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.

• How to find User Assistance for SAP Analytics Cloud?
• Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
• SAP Analytics Cloud > Learning > Guided Playlists

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

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