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.
- 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.
This functionality is not yet available.
It has been added to our backlog of potential features to be developed.
As a workaround, if dedicated copy rules for each month are created the avg aggregation copy works.
- How to find User Assistance for SAP Analytics Cloud?
- Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
Your feedback is important to help us improve our knowledge base.
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-BR , Digital Boardroom (DiBo) , LOD-ANA-PL , Planning Functionality, Planning Models , LOD-ANA-PR , Predictive Scenarios, Smart Predict , Problem