SAP Knowledge Base Article - Public

3123514 - Failed to export model data to File Server by filtering Version dimension in SAP Analytics Cloud (SAC)

Symptom

  • Failed to export model data to File Server by filtering Version dimension with error "There was an error in the export of <Model Name> to CSV" in SAP Analytics Cloud (SAC)
  • The following error detail could be found in HTTP trace:

    {\"exception\":\"EPM_SERVICE : oHierarchy is undefined\\n_getDimensionMembers@/sap/fpa/services/modeling/exportModel/RestExportModelHana.xsjslib:770:19\\ngetFilterDefinitionWhereClause@/sap/fpa/services/modeling/exportModel/RestExportModelHana.xsjslib:620:35\\ngenerateSqlForTempTable@/sap/fpa/services/modeling/exportModel/RestExportModelHana.xsjslib:453:13\\nRestExportModelHana.prototype._createTempTableFromOptions@/sap/fpa/services/modeling/exportModel/RestExportModelHana.xsjslib:208:27\\nRestExportModelHana.prototype.exportCsvToFile@/sap/fpa/services/modeling/exportModel/RestExportModelHana.xsjslib:110:30\\n_exportCsvToFile@/sap/fpa/services/dm/schedule/CSVDataExportJobAction.xsjslib:134:28\\nExportCSVToFileTask.prototype.run@/sap/fpa/services/dm/schedule/CSVDataExportJobAction.xsjslib:571:32\\n_runTaskOnce@/sap/fpa/services/async/TaskManager.xsjslib:87:30\\n_runTask@/sap/fpa/services/async/TaskManager.xsjslib:69:42\\nexecuteNow@/sap/fpa/services/async/TaskManager.xsjslib:17:79\\nCSVDataExportJobAction.prototype.execute@/sap/fpa/services/dm/schedule/CSVDataExportJobAction.xsjslib:90:9\\nrun@/sap/fpa/services/job/Schedule.xsjs:140:21\\n\",\"fullException\":{},\"result\":\"\"}

  • It works fine when exporting model data to file server without filter or with filter on other dimensions
  • It also works fine when exporting model data to file repository with filter on Version dimension

Environment

  • SAP Analytics Cloud (Enterprise)  2021.20.12

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Open one model having multiple versions.
  3. Switch to Data Management.
  4. Click Export Data in Exports Job section and then select Export Model As File > Create New Schedule.
  5. Set Export Model to as File Server in Export Details tab.
  6. Go to Select Data tab and then add filter on Version dimension by selecting any value.
  7. Click Export.
    => After a while, error message "There was an error in the export of <Model Name> to CSV" appears.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

AP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, export, File Server, filter, filtering, version, dimension, location, SCC, model data , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0