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
- Connect to SAC from the Add-in for Office;
- Try to enter functions SAP.GETTABLENAME, SAP.GETDIMENSIONS or SAP.GETDIMENSIONFILTER;
- 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 Office , LOD-ANA-OF-MS , SAP Analytics Cloud, add-in for Microsoft Office , Problem
Product
SAP Analytics Cloud, add-in for Microsoft Office all versions