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_Yu1 · 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.

[MoonJun]

Hi @ShoaibSyed 

I am not clear about "I add another dimension table in the model i-e Profit center or Cost Center or both". This means that you added a new dimension (Profit center or cost center) to the default model(= Modifying model on the Modeling page) or added the dimensions that already exist in the model to the SAC Story table (Row or column).

Regards,

Moonjun

[ShoaibSyed]

Dear MoonJun, thank you for your time. I figured out that I was not applying restriction on the leaf node while writing the data action. once i did that, everything was working.