SAP Knowledge Base Article - Public

2927148 - Data Action Advanced Formula does not copy all the source data to target data - SAP Analytics Cloud

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

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

Product

SAP Analytics Cloud 1.0