on 05-23-2013 7:14 PM
Hi Guys,
I am in BPC 10 MS and i am trying to copy from previous month to the month selected by the user. I am using PRIOR function, but it is getting the wrong timeid.
*XDIM_MEMBERSET TEMPO = PRIOR(1, %TEMPO_SET%)
....
*REC(EXPRESSION= %VALUE% , TEMPO = NEXT(1,%TEMPO_SET%) )
I ran the package with 2013.JAN but the script is running with timeid 20201100, the expected was 20121200.
-> 2020 is the last year in my time dimension.
I add the property PRIOR, NEXT and CURRENT in time dimension. Follows the record for 2013.JAN
ID | TIMEID | PRIOR | CURRENT | NEXT |
2013.JAN | 20130100 | 2012.DEC | 2013.JAN | 2013.FEB |
Could you help me in this issue?
Thanks in advance.
Mauro
Hi Mauro,
can you please share the entire script?
Thanks
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Roberto,
follows the script. I don't know if the statement PRIOR(12, %TEMPO_SET%) is possible. I want to copy the records from last year to current year. I could change to *XDIM_MEMBERSET TEMPO = %TEMPO_SET%, but i want that user select the current month/year.
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET ENTITY = %ENTITY_SET%
*XDIM_MEMBERSET TEMPO = PRIOR(12, %TEMPO_SET%)
*WHEN TEMPO
*IS *
*REC(EXPRESSION= %VALUE% , TEMPO = NEXT(12) )
*ENDWHEN
Tks,
Mauro
Hi Mauro,
Can you please try below code once -
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET ENTITY = %ENTITY_SET%
*XDIM_MEMBERSET TEMPO = PRIOR(12),%TEMPO_SET%
*WHEN TEMPO
*IS * PRIOR(12)
*REC(EXPRESSION= %VALUE% , TEMPO = %TEMPO_SET% )
*ENDWHEN
If you pass 2013.JAN, it should copy data of 2012.JAN onto 2013.JAN.
Regards,
Ashish
User | Count |
---|---|
15 | |
3 | |
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.