MEMBERSET for current month in [d/Date] dimension with daily granularity

[ThomasK]

Hi,

I´m using a planning model with time dimension on daily granularity.
In a data action I want to read the Actual data for the last 3 full months and create Projection data for the current month.

Currently my data action has 4 parameters to define those time ranges.

The corresponding two MEMBERSET functions look like this:

MEMBERSET [d/Date] = %ProjectionMonthStart% TO %ProjectionMonthEnd%
MEMBERSET [d/Date] = %ActualsLast3MStart% TO %ActualsLast3MEnd%

The same could be achieved by using 4 attributes in the version dimension.

Both solutions must be maintained manually month by month.

Now I´m looking for a dynamic solution based on the current date, but it seems SAC is not able to provide this.
Remind, the planning model is on daily granularity!

Let´s look on the time range for current month
I can´t find a any function from the set of date functions (TODAY, PREVIOUS, NEXT, FIRST, LAST) to define the 1st and the last day of the current month.

The same is with last 3 months Actuals.

The requirement is easy to solve if the time granularity of the date dimension is month.
But with daily granularity it seems to be impossible.

Has anybody an idea how to solve it or is SAC not capable to make it run?

BR
Thomas

[William_Yu]

Maybe one option is to calculate the range with JS in story, and pass the parameter to data action calling the API from story.

[ThomasK]

I already thought about this solution, but it doesn´t allow me scheduled execution of the data action with the calendar.