Hello,
I di have difficulites to write a variablemember for measure to a measure which I created in the data model. The calculation works fine and I receive the expected result. However, I cannot use the variablemember in the DATA() formula via a RESULTLOOKUP(). Change the model measure as a test against another variablemember measure shows me that I would receive the correct results:
This works and I receive the correct result (variablemember measure included as test):
DATA([d/AUDIT_TRAIL]="SAC_PREASSIGNMENT",[d/DEBITCREDITCODE]="C",[d/IMPL_BudgetHierarchy]= %CostCenter%,[d/Measures]="Flow_Changing_LC",[d/IMPL_COABudget]=%AllocationAccount%)=
RESULTLOOKUP([d/AUDIT_TRAIL]="SAC_PREASSIGNMENT",[d/DEBITCREDITCODE]="C",[d/Measures]=#PerentageOfPeriod,[d/IMPL_PartnerCostCenter]=#P1,[d/IMPL_BudgetHierarchy]= %CostCenter%,[d/IMPL_COABudget]=#C1)
*RESULTLOOKUP([d/AUDIT_TRAIL]="SAC_PREASSIGNMENT",[d/Date]=#M1,[d/DEBITCREDITCODE]="C",[d/Measures]=#Totals,[d/IMPL_BudgetHierarchy]= %CostCenter%,[d/IMPL_COABudget]=%AllocationAccount%)
This does not work (trying to create the data records with the models measure):
DATA([d/AUDIT_TRAIL]="SAC_PREASSIGNMENT",[d/DEBITCREDITCODE]="C",[d/IMPL_BudgetHierarchy]= %CostCenter%,[d/Measures]=#PlannedAmount,[d/IMPL_COABudget]=%AllocationAccount%)=
RESULTLOOKUP([d/AUDIT_TRAIL]="SAC_PREASSIGNMENT",[d/DEBITCREDITCODE]="C",[d/Measures]=#PerentageOfPeriod,[d/IMPL_PartnerCostCenter]=#P1,[d/IMPL_BudgetHierarchy]= %CostCenter%,[d/IMPL_COABudget]=#C1)
*RESULTLOOKUP([d/AUDIT_TRAIL]="SAC_PREASSIGNMENT",[d/Date]=#M1,[d/DEBITCREDITCODE]="C",[d/Measures]=#Totals,[d/IMPL_BudgetHierarchy]= %CostCenter%,[d/IMPL_COABudget]=%AllocationAccount%)
I do not know why I cannot write the data to my models measure? Do you have an idea?
I attached the data action in the files
SAP Analytics Cloud for planning SAP Analytics Cloud @Sisn
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.