3481673 - The data action is slower in the new model compared with the classic model in SAP Analytics Cloud for Planning (SAC)

There are 3 models, a classic model, a new model converted from this classic model (one measure model), a newly created new model.
For each model, a data action doing the similar calculation with the similar script is created.
It is observed that the data action runs slower in the converted model and new model compared with the classic model.

SAP Analytics Cloud (Enterprise)

The data action of the classic model is faster than the new model (including the converted model) because the data action populates almost the same number of records from the classic and new model. Technically, the data action code is different for the classic & new model. So, we can't say that the data action of the new model is always faster than the classic model. It is affected by various factors and the structure of data which is populated by Data action. However, for a data action populating the same data, the number of records should be fewer and the execution time should be faster in a well-designed new model compared with the classic model.

Please refer to the following contents for more details.

Comparing the Classic model & Converted model:

• The converted model is slower than the classic model because the data action script of the converted model has to manage and process the measure which does not need to be processed in the classic model.
• In the converted model, the measure is processed like one of the dimensions. Let's say the classic model has X dimensions. Then the converted model will have X dimensions + 1 measure. To process the measure, the data action takes more execution time.
• In the classic story, although there is a Signed data column for the measure, the data action script does not do anything for the Signed data because it is fixed in one column. The converted model has one measure but it is not fixed and can be added more measures. So the data action script has to manage and process it. 

Comparing the Classic model & New model:

• It is due to the fact data structure of the models.
• For example, the ideal fact data structure of the new model should be something as below:
  

  Dimension A	Dimension B	Measures	Value
  member A1	member B1	Measure1	100
  member A1	member B1	Measure2	200
  member A1	member B1	Measure3	300
  member A1	member B1	Measure4	400

  
  The corresponding fact table on the HANA is as below:
  

  Dimension A	Dimension B	Measure1	Measure2	Measure3	Measure4
  member A1	member B1	100	200	300	400

• If the actual fact data of the new model is as below, the populated number of the records for the similar data action of the classic model and the new model will be almost the same. In this case, the date action based on the new model will take more execution time & system resources.  
  

  Dimension A	Dimension B	Measures	Value
  member A1	member B1	Measure1	100
  member A1	member B2	Measure1	200
  member A1	member B3	Measure1	300
  member A1	member B4	Measure1	400

  
  The corresponding fact table on the HANA is as below:
  

  Dimension A	Dimension B	Measure1	Measure2	Measure3	Measure4
  member A1	member B1	100	null	null	null
  member A1	member B2	200	null	null	null
  member A1	member B3	300	null	null	null
  member A1	member B4	400	null	null	null

• Generally, increasing the number of records(=increasing rows) requires more resources. In addition, an increasing number of measures(=increasing columns) also requires more resources. 
• Data action performance can be influenced by various factors, and it may be slower in new models. However, in a well-designed new model, the execution of the data action requires smaller system resources and execution time should be better. In addition, it will benefit the overall performance of the following tasks (e.g., Publish, Concurrent user).

For a data action populating the same data, the number of records should be fewer and the execution time should be faster in a well-designed new model compared with the classic model.

Regarding the performance comparison between the classic & converted model, the development team agree that the data action of the classic & converted model should be of the same performance at least. The feature is in the team's backlog and will be worked upon. However, we cannot provide a timeline for this feature at the moment.

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.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://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, dashboard , KBA , LOD-ANA-PL-AF , Advanced Formulas , LOD-ANA-PL-DA , Data Actions , Problem