SAC Data Action Advanced Formula - Copy Actual's value to Forecast

[ShoaibSyed]

Dear Gurus,

I am trying to copy a value from the Actual version of a month provided from a user parameter to the rest of the months in Forecast version. In my model I have GL account dimension table having different hierarchies.

I am successfully able to copy using the Advanced formula but when I add another dimension table in the model i-e Profit center or Cost Center or both, having hierarchies too. The Data Action stops working. It doesn't give any error but also doesn't give any output.

Below is the code that i am using, and I would really really appreciate if you can help me find a solution to it.

Thank you.

CONFIG.HIERARCHY = [d/GlAcc_MD].[h/HIR_OTHER]

MEMBERSET [d/Date] = %MonthIP%

MEMBERSET [d/GlAcc_MD] = BASEMEMBER([d/GlAcc_MD].[h/HIR_OTHER], "034")

INTEGER @i

INTEGER @Month

INTEGER @Iterate

//Assigning Values to Variables

@Month = MONTH(%MonthIP%) 

@Iterate = 12 - @Month

FOR @i = 1 TO @Iterate

DATA([d/Date] = NEXT(@i, "MONTH", %MonthIP%))= RESULTLOOKUP([d/Version]="public.Actual") 

ENDFOR

[William_Yu · Accepted solution]

Data action execution is irrelevant to your table layout, and data action execution is always on the leaf nodes cross all dimensions. I would suggest you to check your table setting and filtering after having adding additional dimensions into table. 

[ShoaibSyed · Accepted solution]

Dear William, thank you for explaining this major point. This lead me to understand that everything was fine I just had to add a new filter in my data action so that it works on the leaf node.