Skip to Content
0
Jul 29, 2016 at 08:41 PM

BPC Default LGF

216 Views

Need help, I have the below Default LGF but the way I wrote it's specific to 2016 year. I would like this to be dynamic basically as the year changes it should apply the default lgf as well. so how I can code this? I'm new to script logic and any help is appreciated.

*XDIM_MEMBERSET TIME=%TIME_SET%

*XDIM_MEMBERSET AUDITTRAIL=Input

*XDIM_MEMBERSET CATEGORY<>Actual

*WHEN TIME.MONTHNUM

*IS 1

*REC(EXPRESSION =[TIME].[2016.01])

*IS 2

*REC(EXPRESSION =[TIME].[2016.01]+[TIME].[2016.02])

*IS 3

*REC(EXPRESSION =[TIME].[2016.01]+[TIME].[2016.02]+[TIME].[2016.03])

*IS 4

*REC(EXPRESSION =[TIME].[2016.03]+[TIME].[2016.04])

*ENDWHEN