SAP Knowledge Base Article - Public

2806854 - Not possible to copy data with daily granularity to monthly granularity using automatically generated copy rules in data action SAP Analytics Cloud (SAC)

Symptom

It is not possible to copy data from a model with daily granularity to a model with monthly granularity using automatically generated copy rules in data action for accounts that are defined with an AVG exception aggregation in regards to time.

The expectation is that the monthly AVG value is copied and not the single values of every day of the month.

Environment

  • SAP Analytics Cloud 2019.11

Reproducing the Issue

Create a Data Action to copy data from a model with day granularity to one with monthly granularity.

Use option to automatically generate copy rules

Execute the data action from within a story. Data from each day will be summed rather than copying the monthly average to the monthly model.

Cause

This functionality is not yet available.

It has been added to our backlog of potential features to be developed.

Resolution

As a workaround, if dedicated copy rules for each month are created the avg aggregation copy works.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , 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