SAP Knowledge Base Article - Public

3324227 - Import Data Source - File .xlsm not Available for Selection in SAP Analytics Cloud

Symptom

  • Importing file from SharePoint to SAC in .xlsm format is greyed out.

Environment

  • SAP Analytics Cloud version 2.0
  • SharePoint.

Reproducing the Issue

  1. Log in to SAC.
  2. Click on Modeler.
  3. Select and Open the model.
  4. Below workspace click on dropdown and select Data Management.
  5. Click on import data option.
  6. Click on Data source.
  7. Select SharePoint.
  8. Choose the connection.
  9. Click on Next to continue.
  10. Click on folder to see the list of available files.
  11. The file with .xlsm format are not available for selection.

Cause

  • This is a limitation.

Resolution

  • Import from .xlsm format is not supported in SAP Analytics cloud.
  • SAC only support the import from XLSX or CSV files.
  • Kindly raise enhancement request if you want this feature in future releases.
  • 2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?

See Also

Keywords

SAC, SharePoint, SAP Analytics cloud, .xlsm , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0