Skip to Content

Script logic in packages: take variables from package

Hi all,

I have a package where the user must select Time dimension member. I know that the selected value is saved in the variable %TIME_SET%. Imagine the user select 2015.JUN. I would like to run a script for all months of 2015, but I don't know how to code the selection of the year of the member selected by the user in the package.

I have tried using %YEAR%, but it does not work, as %YEAR% is the year of the temporal registers, not the year selected in the package.

Any idea?

Best regards,

Fernando

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 08, 2015 at 01:47 PM

    Hi Fernando,

    Use this


    *SELECT(%YR%,"[YEAR]",TIME,"[ID]='%TIME_SET%')


    Shrikant

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 01:31 PM

    Hi Fernando,

    have you tried to select 2015.TOTAL

    Andy

    Add comment
    10|10000 characters needed characters exceeded