SAP Knowledge Base Article - Public

2971994 - Waning "Your table contains custom cells or calculations outside the table's data region, that won't be exported" displays when you export data

Symptom

The following warning occurs in SAP Analytics Cloud (SAC) when you try to export data from a story:

  • Your table contains custom cells or calculations outside the table's data region, that won't be exported

However, you cannot see any custome cells or calculations outside the table. All are empty cells.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.14.23

Reproducing the Issue

  1. Open a story.
  2. Table function -> Export.
  3. Warning shows in the export dialog.

Cause

Some empty custom cells are defined on the grid page.
Those empty custom cells do trigger the warning in the export dialog.
However, there is no value or style defined for those custom cells so they cannot be distinguished visually from the grid.

Resolution

The development team are currently working on a more consistent user experience for this.

As a workaround, you can ignore the warning and still export the table as usual.
You can also follow the steps below to delete the empty custom cells:

  1. Select the empty columns to the right of the table and press the delete button on the keyboard.
  2. Select the empty rows below the table and press the delete button again.

If it does not work, please delete all the rows and columns outside the table by Styling -> Show Styling Options for Custom Cell -> Cell -> Delete a row or Delete a column.

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-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0