SAP Knowledge Base Article - Public

2717037 - Pivot Table Does Not Work in Different Language

Symptom

You created a pivot table using SAP Excel Add-in, and when opening it with the business user ABC (ABC represents the business user ID) it does not work.

Environment

  • SAP Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Open a report using Microsoft Excel SAP Add-in.
  2. Insert a pivot table on the report.
  3. Save the report into your computer.
  4. Open the report as the business user ABC.
  5. The pivot table does not work for the opened report.

Cause

You have saved the pivot table in one language (e.g. EN) and tried opening it in a different language (e.g. DE), therefore the pivot table will not load properly since there will be a conflict with the language used in its creation.

Resolution

Configure your business user in My Settings to the same language in which the pivot table has been created and then try opening the report again. Make sure that the business user opening the report has the proper accesses to the same.

Keywords

Pivot Table; Excel; Add-in; Report table; Report , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions