SAP Knowledge Base Article - Public

3401098 - Formula SAPGetWorkbookInfo("LogonUser") returns empty string when refreshing a workbook saved locally

Symptom

The formula SAPGetWorkbookInfo("LogonUser") returns empty string when refreshing a workbook saved locally.

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Refresh an Analysis Office workbook which is stored in the local machine and contains the formula SAPGetWorkbookInfo("LogonUser");
  2. Confirm that the workbook is refreshed fine but the formula returns an empty string instead of the user logged to BW or BI platform.

Cause

The product is working as designed. The formula SAPGetWorkbookInfo("LogonUser") returns empty string when refreshing workbooks stored in the local machine or in SAC platform.

The formula only returns the user when the report is stored in the BW or BI platform.

Resolution

Save the workbook either in BW or BI platform. Alternatively, the formula SAPGetSourceInfo can be used as described in chapter SAPGetSourceInfo.

See Also

Chapter SAPGetWorkbookInfo in User Guide

Keywords

LogonUser, SAPGetWorkbookInfo, empty, blank, not working, formulas , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions