SAP Knowledge Base Article - Public

3191765 - Functions returning "#N/A" in SAC Add-in for Office

Symptom

When using the functions SAP.GETTABLENAME, SAP.GETDIMENSIONS or SAP.GETDIMENSIONFILTER in SAC Add-in for Office, the value "#N/A" is displayed in the cell.

Environment

SAP Analytics Cloud, add-in for Microsoft Office

Reproducing the Issue

  1. Connect to SAC from the Add-in for Office;
  2. Try to enter functions SAP.GETTABLENAME, SAP.GETDIMENSIONS or SAP.GETDIMENSIONFILTER;
  3. Confirm they return "#N/A".

Resolution

Try to delete the Add-In cache as described in Microsoft's document "Clear the Office cache".

Keywords

error, formula, cell, not working , KBA , LOD-ANA-OF , SAP Analytics Cloud, add-in for Microsoft Office , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud, add-in for Microsoft Office all versions