[SAC] Copy Data with Advanced Formula across year is not working

[Juthamard_J]

Hi Expert,

I have problem with Advanced Formula to copy Data across year. But it is working fine within a year. My code as below:

CONFIG.READ_CALCULATED_MEMBER_VALUES=OFF
CONFIG.FLIPPING_SIGN_ACCORDING_ACCTYPE=OFF
CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY =[d/COSTCENTER]
CONFIG.GENERATE_UNBOOKED_DATA=ON

MEMBERSET [d/ACCOUNT] = ("MFG_RM_STD")
MEMBERSET [d/CHANNEL] = ("NO_CHANNEL")
MEMBERSET [d/AUDITTRAIL] = ("INPUT_SAC")
MEMBERSET [d/Date] = "202401" TO "202512"
MEMBERSET [d/PROFITCENTER] = ("PC001100")
MEMBERSET [d/COMPANY_CODE] = ("001")
MEMBERSET [d/Measures] = ("AMT")
MEMBERSET [d/PRODUCT] = "2100000126"

DATA([d/Date]="202501") = RESULTLOOKUP([d/Date]="202401")

If I changed RESULTLOOKUP to be the same year, then it was working fine, as below

DATA([d/Date]="202502") = RESULTLOOKUP([d/Date]="202501")

Please suggest,

Thank you

Juthamard

[Juthamard_J]

Hi All,

It was my mistakes, I did not provide member for COSTCENTER. I left it blank member, then I could not copy not assigned member across year. So I import CC_NONE to year 2024 and now it is working.

Thank you

Juthamard