SAP Knowledge Base Article - Public

2943640 - Failed to create Custom Expression for some specific columns when editing dataset in SAP Analytics Cloud (SAC)

Symptom

Failed to create Custom Expression for some specific columns when editing dataset in SAP Analytics Cloud (SAC),

Error message showing:

  • Failed to execute transform

Environment

  • SAP Analytics Cloud (Enterprise) 2020.14.0

Reproducing the Issue

  1. Create an Excel and add two columns to the Excel:
    A                          B
    4000000000          200000
  2. Logon to SAC tenant > Create Dataset > Data uploaded from a file.
  3. Select the Excel to create a new dataset.
  4. Now both columns will set Data Type as "Integer" automatically.
  5. Click Toggle Custom Expression Editor to create a new custom expression.
  6. Set formula as " B = B * 1.5 ".
  7. Confirm it's created successfully in column B.
  8. Create a new Expression and set to " A = A * 1.5 ".
  9. Following error happens and new expression failed to create:
    Failed to execute transform

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

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, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0