Symptom
- Advanced formula Copy Data Action does not copy all the data of the source dimension members to the target dimension members.
- Let's suppose that there is transaction data as below, and # of the PARTNER_PROFIT_CENTER dimension is "Not in Hierarchy" and "A" is included in the H1 hierarchy.
ACCOUNT | TIME | PARTNER_PROFIT_CENTER | Signed Value
Total_Revenue | 201501 | # | 100
Total_Revenue | 201501 | A | 200
If copy all this data in the next year, only the values below will be copied.
ACCOUNT | TIME | PARTNER_PROFIT_CENTER | Signed Value
Total_Revenue | 201601 | A | 200
Environment
SAP Analytics Cloud 2020.8.9
Cause
Calculation scopes of Advanced Formulas does not include the members in "Not in Hierarchy".
Thus, the values in the "#" member of the dimension are not included in the calculation scope when copying, but only the rest are copied. So, on the whole, it seems that only a part is copied.
Resolution
Add "#" member into any hierarchy.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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 , Data Action , DA , advanced formula script , "#" member , Not in hierarchy , # , scope , target version , source version , KBA , LOD-ANA-PL-AF , Advanced Formulas , Problem