SAP Knowledge Base Article - Public

3269642 - Data action steps that have no source data still take execution time in SAP Analytics Cloud for Planning (SAC)

Symptom

The following behavior occurs in SAP Analytics Cloud for Planning (SAC):

  • You have a data action that has some steps. Although no data exists as the source of one step (for example, all members are excluded from Memberset syntax), this step still requires some seconds to be processed.

Environment

  • SAP Analytics Cloud (Enterprise) 

Reproducing the Issue

  1. Run a data action.
  2. Check the execution time from the data action monitor.

Cause

Data action scripts create HANA stored procedures and they are executed when you execute the data actions.
The HANA stored procedure is processed on your model and there is a mandatory execution time to process HANA stored procedure.
Although there is only one or zero fact record in the calculation scope, the stored procedure is processed for all defined and out of the calculation scope.

Generally, the data action execution time is a proportionally increasing number of the calculated results. But the data action HANA procedure is processed with or without calculated result anyway, so there is a mandatory execution time to execute the data action.
The data action processes and retrieves data to calculate for defined calculation scope regardless of existing or not existing fact records.  

Resolution

This is the designed behavior.

See Also

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

Keywords

SAP 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,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, SAP 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,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, advanced formula, formulas, scoping , KBA , LOD-ANA-PL-AF , Advanced Formulas , LOD-ANA-PL-DA , Data Actions , Problem

Product

SAP Analytics Cloud all versions