on 01-08-2015 11:59 AM
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
Hi Fernando,
Use this
*SELECT(%YR%,"[YEAR]",TIME,"[ID]='%TIME_SET%')
Shrikant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you very much for all your answers, but they are not enough.
I need the year to to run CALC_ACCOUNT logic for all months of the year selected.
The logic is like this:
....
*SELECT(%YR%,"[YEAR]",TIME,"[ID]='%TIME_SET%')
*RUN PROGRAM RUNCALC_ACCOUNT
CATEGORY=%CATEGORY _SET%
TID_RA= ?????
OTHER=[COMPANY=%COMPANY_SET%]
CALC=DEPN
*ENDRUN_PROGRAM
After this logic, other logic is run to calculate the opening flow of everymonth using closing month of previous month:
*RUNALLOCATION
*FACTOR=1
*DIM ACCDETAIL WHAT=BAS(DT_CLO); WHERE=DT_OPE
*DIM TIME WHAT = %YR%.01; WHERE = %YR%.02
*ENDALLOCATION
*RUNALLOCATION
*FACTOR=1
*DIM ACCDETAIL WHAT=BAS(DT_CLO); WHERE=DT_OPE
*DIM TIME WHAT = %YR%.02; WHERE = %YR%.03
*ENDALLOCATION
.....
Which is the code I must write after TID_RA=? If I write for example %YR%.01, when I run the package, I get an error saying: "Member 2011 is not a valid base member". It is like when you write %YR%.01 in the TID_RA section, it only understand until the point.
Any ideas?
Hi Fernando,
have you tried to select 2015.TOTAL
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can use BAS(%TIME_SET%) in your *XDIM_MEMBERSET statement.
This way, if a user then selects a node, for example 2015.TOTAL, this will run the calculation for all basmembers of the selected node. If an individual bas member is selected, the logic script will run for this specific month.
With kind regards,
Tim
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.