[BPC 10.1 MS] DESTINATION_APP ( Different TIME )

43 Views

Hello There

My first message here !! Congratz to me 😉

I have a tricky issue with my DESTINATION_APP

I have 2 model

One with a PERIOD Hierarchy Year / Month / day

One with a PERIOD Hiearchy Year / Quarter / Day

I wanna push some Income Data from the Day Model into the Month Model

I have test this logic

*SELECT(%MONTH_BUD%, "ID",PERIODE_JOUR,"ID=LEFT('%PERIODE_JOUR_SET%',8)")

*DESTINATION_APP= BARRIERE

*RENAME_DIM RUBRIQUE_CA = RUBRIQUE

*SKIP_DIM = PERIODE_JOUR

*ADD_DIM INTERCO = I_S9999, PERIODE = %MONTH_BUD%

*XDIM_MEMBERSET DEVISE= LC

*XDIM_MEMBERSET FLUX = <ALL>

*XDIM_MEMBERSET NATURE = <ALL>

*XDIM_MEMBERSET RUBRIQUE_CA = R70601 //%ACCOUNT_COPY%

*XDIM_MEMBERSET UNITE = %UNITE_SET%

*XDIM_MEMBERSET PERIODE_JOUR = %PERIODE_JOUR_SET%

*WHEN PERIODE_JOUR

*IS %PERIODE_JOUR_SET%

*REC(RUBRIQUE_CA = R70601)

*ENDWHEN

*COMMIT

The trouble is that my var MONTH_BUD work only with a single PERIODE selection

Any idea ? It would be so kind

I have also Follow the way of the CAL_DUMMY_ORG on PERIODE_JOUR = PARENTH1 but the bottleneck is on the GET in the REC ... as far as i'm in the MONTH model i cannot use %PERIOD_JOUR_SET% ....