SAP Knowledge Base Article - Public

3589263 - AO Smart Copy/Paste Not Working in SAP Analytics Cloud Workbooks with Live Connections

Symptom

  • In SAP Analytics Cloud, using a transported workbook based on a SAC live connection, the smart copy/paste functionality is not working.
  • This leads to "unsubmitted variables". |ERROR  |AoPlugin |CrDataProvider.GetInplaceMessage |VSTA_Main | Unsubmitted variables 

Environment

  • SAP Analytics Cloud
  • Analysis for Office 2.8
  • HANA 2.0 

Reproducing the Issue

  1. Open a workbook from the SAC Platform in the SAC Production environment.
  2. Use a predefined prompt.
  3. Create a new Excel tab.
  4. Select the crosstab and click on Smart copy of crosstab.
  5. Use Smart paste in the new tab.
  6. When prompted, use the predefined prompt.

Cause

The issue is caused by the workbook attempting to retrieve data from an incorrect URL. The workbook is stored on

Comanyname.eus10.sapanalytic.clouds

but is trying to get data from 

Comanyname-dev.eus10.sapanalytic.clouds

Resolution

  1. Identify the incorrect URL in the data source settings.
  2. Adjust the data source settings to only use Comanyname.eus10.sapanalytic.clouds

Keywords

SAP Analytics Cloud, Smart Copy/Paste, Live Connections, Workbook, Unsubmitted Variables, Incorrect URL, Data Source Settings. Analysis for Office 2.8 , KBA , BI-RA-AO-XLA , Excel Addin , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , LOD-ANA-AD , Analytics Designer , Problem

Product

SAP Analysis for Microsoft Office 2.8 ; SAP Analytics Cloud all versions