SAP Knowledge Base Article - Public

2596102 - Only first Google sheet is acquired when creating a model or story using Google Drive in SAP Analytics Cloud (SAC)

Symptom

When importing data into a story or model from Google Drive, only the first Google spreadsheet (sheet / tab) will be acquired despite changing the Google Sheet URL in SAP Analytics Cloud (SAC).

Environment

  • SAP Analytics Cloud 2018.1.0

Reproducing the Issue

  1. Log into SAP Analytics Cloud.
  2. Create a story by navigating to Menu - Create - Story - Create New Canvas Page.
  3. Select 'Acquire data from a datasource' and select 'Google Drive'.
  4. Log in to your Google account and paste the Google Sheets URL from Google Drive.

Cause

Product limitation.

Resolution

Workaround: Please create a unique Google spreadsheet file for each sheet within your Google spreadsheet you want to upload into SAP Analytics Cloud.

See Also

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, docs.google.com/spreadsheets, Google Sheets, At import file, choose which sheet to import from, mutiple sheets, google sheet, , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0