[BPC 10.1 MS] DESTINATION_APP ( Different TIME )

[Former Member]

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% ....

[former_member186498]

Hi Grégoire,

what will contain %PERIODE_JOUR_SET% variable?

Regards

     Roberto

[Former Member]

Hello Roberto

It will contain some days

In fact the first cube is in Days

ie

2015.FY

     2015.JAN

          2015.JAN.01

          2015.JAN.02

          etc

And i want to put the sum of the days in the correct month in the other cube.

[Former Member]

I have change a bit my approach

//

*SELECT(%ACCOUNT_COPY%,"ID",RUBRIQUE_CA,TOCOPY='Y')

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

// ACCOUNT COPY

*XDIM_MEMBERSET DEVISE= LC    

*XDIM_MEMBERSET FLUX = <ALL>  

*XDIM_MEMBERSET RUBRIQUE_CA = %ACCOUNT_COPY%

*XDIM_MEMBERSET UNITE =  %UNITE_SET% 

*XDIM_MEMBERSET PERIODE_JOUR =

*FOR %D% = %PERIODE_JOUR_SET%

*DESTINATION_APP= BARRIERE

*RENAME_DIM RUBRIQUE_CA = RUBRIQUE

*SKIP_DIM = PERIODE_JOUR

*ADD_DIM INTERCO = I_S9999

*ADD_DIM PERIODE = %MONTH_BUD%

*WHEN RUBRIQUE_CA

*IS %ACCOUNT_COPY%

*REC(FACTOR=1)

*ENDWHEN

*COMMIT

*NEXT

My issue is now i cannot use %D% in the select .. is that true ?

[former_member186498]

Hi Grégoire,

if you want to extract all the days in the month use the SQL like option instead of equal or PARENTH1

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

(I suppose that your month parent is 2015.JAN)

Regards

     Roberto