Hi,
I am using BPC 5.1 SP3 and I am trying to perform different calculations based on the time period.
The user select one month to run the script (let's take 2008.JUL) and I have an *XDIM_MEMEBERSET command that expands the scope of the Time dimension to all months of the year 2008.
*XDIM_MEMBERSET TIME = Descendants([TIME].[%TIME_SET%].Parent.Parent,99,LEAVES)
I would then like to perform a different calculation, whether the month is a past period or a future period.
I tried the following WHEN statements:
*WHEN TIME.TIMEID
*IS <= %TIME_SET%.TIMEID ==> executed for all months (not just the past periods)
...
*ENDWHEN
I also tried
*IS <= FLD(%TIME_SET%.TIMEID) ==> not executed for any months.
When I hardcode the parameter, the calculation works.
*IS <= 20080700
It looks like the filter on %TIME_SET% properties are not working, has anybody had success with a similar setup ?
Only workaround I found so far was to create to *COMMIT section with two *XDIM_MEMBERSET statements, but I would like to avoid having two *COMMIT sections.
Any suggestions are welcome.
Regards,
Marcel