Moving data from periodic app to ytd app

[Former Member]

Hi,

I have the following Problem.

We have one application for consolidation. This application is set to INPUTYTD=1.

For budgeting we like to enter the values periodic. So I created an appliaction with INPUTYTD=0.

Both are running fine.

What I want to do now is the following. In the default logic script I want to enter a code that the periodic entered budget data will be transferd to the YTD application.

I tried a lots of codes but I did not come to an end. It always copies me the periodic vaule (budegt app) into the ytd value (consol app).

I tried the following:

// Move YTD to Consol application

*DESTINATION_APP=FINANCE

*XDIM_MEMBERSET Category= BUDGET

*XDIM_MEMBERSET RptCurrency= LC

*XDIM_MEMBERSET MEASURES=YTD

*WHEN *

*IS *

*REC(FACTOR=1,Category=Budget)

*ENDWHEN

*COMMIT

Can someone please tell me how to get the correct result???

Thanks and regards,

Fabian

[JHattendorf]

Fabian - measures is not a true dimension so logic is unable to pull those values. At least I have not been able to access utilize in logic.

To address this issue, the logic files needs to calculate a YTD value prior to or during the push to the YTD app. The admin user guide provides a good example for calculating CYNI, which is also a YTD value. You can use an approach similar to the CYNI sample logic to calculate the YTD value for each month and then push the data.

Hope this helps you.

Jeff

[Former Member]

Hi Jeff,

thanks for your quick reply. I will have a look on it and if this does not help I'll repost it.

Thanks for your help!

Cheers,

Fabian

[Former Member]

Hey Jeff,

Did you figure out how to do this? I am trying to do the same.

Thanks...

[Former Member]

Jeff,

How did you acheive this? I am trying to do the same?

Thanks..

[Former Member]

Hi,

We faced and resolved the same problem. We need to send some periodical data to a YTD application.

What we did was to copy the previous month from the YTD application using a lookup sentence. Then add this information to the information that is being processed by the default logic (periodic app) and send it back (REC sentence) to the YTD application.

The point is that you need to do an special treatement for january since for this month YTD and Periodic is the same so you need to extract nothing from the YTD application.

JAN YTD = JAN Periodic

FEB YTD = JAN YTD + FEB Periodic

MAR YTD = FEBYTD + MAR Periodic

...

DIC YTD = NOV YTD + DIC Periodic

Regards.

Jesus.

[Former Member]

Hi Jesus,

this is an easy and verry good approach! Thanks for that comment. I think this would be the easiest to do. Of course we have to check first the type (INC,EXP or AST,LEQ) but this sould be no problem.

Thanks again,

Fabian