Skip to Content
0
Former Member
Dec 17, 2008 at 11:44 AM

Filter on %SET% property

57 Views

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