SAC Memberset - Version Property

[SAC_Newbie]

Dear all, 

I am currently creating a model in SAC, where I am building a few data actions. There is one copy data action which shall be used to populate zeros in the data range of the year of the version.

For that I have the following script:

Unfortunately, I am seeing the error code. When using a fix year in line 12, e.g. "2024", it works fine.

Do you have any idea, why I cannot use the version property, in which i am stating a year?

Best

[MoonJun · Accepted solution]

Hi @SAC_Newbie 

Unfortunately, "MEMBERSET [d/Date].[p/YEAR] = [d/Version].[p/Year]" is not supported on the Advanced Formulas script.  

You can get your expected DATE scope which is "202401" to "202412" on the below script;

• MEMBERSET [d/Date] = [d/Version].[p/Year] TO NEXT(11,"MONTH", [d/Version].[p/Year])

The Version property "[p/Year]" has a value of "2024" and it is recognized as 202401 in a model with month granularity. 

In addition, the data type of [d/Version].[p/Year] should be TEXT type, Numeric data type is not recognized as date type(202401) value.  

I hope this is helpful to you, and if I have misunderstood anything, please let me know.

Moonjun

[William_Yu]

Instead of using Year property, you can maintain start and end period in version properties, the statement can be :

MEMBERSET [d/Date] = [d/Version].[p/FIRST_PERIOD] TO [d/Version].[p/LAST_PERIOD]