cancel
Showing results for 
Search instead for 
Did you mean: 

SAC - TODAY() minus X is it possible?

ychernikov
Discoverer
0 Kudos

Hi,

I need to build a data action which clears all the data in the model older than X days from the DATE dimension.

How can this period be defined within the MEMBERSET ?

I tried :

MEMBERSET [d/DATE_BACKUP] = PERIOD("2023-01-01") TO PERIOD(TODAY()-14)

Doesn't accept the syntax.

Will appreciate any advise,

Thanks

Yulia

View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi ychernikov

  You may try the PREVIOUS keyword like this: PREVIOUS(14, "DAY", TODAY())

Best regards, William 

ychernikov
Discoverer
0 Kudos
Thank you very much William! That worked for me 🙂