Skip to Content
0

How to transfer data from a periodic model to a year todate model

Oct 26, 2016 at 10:01 AM

48

avatar image

I want to transfer data from a periodic model to YTD using script logic.The data must add prior month plus the current month to the YTD model and gives an aggregated year to date value.The periodic model has an entity dimension and account dimension which are at lowest level which posts to an aggregated entity and account in the destination. E.g 5 Entities in the source model maps into 1 entity in the destination model. The same for account dimension. When running the script it says invalid entity and account in the destination model, which means its not recognizing the mapping. We have a property in the entity dimension in the source model which maps to the entity in the destination model. Please note that the source and destination models don't share the entity and account dimension. Please see UJKT dump below:

CALCULATION BEGIN:
QUERY PROCESSING DATA
QUERY TIME : 1.00 ms. 45 RECORDS QUERIED OUT.
QUERY REFERENCE DATA
CALCULATION TIME IN TOTAL :1.00 ms.
45 RECORDS ARE GENERATED.
CALCULATION END.

ENDWHEN ACCUMULATION: 45 RECORDS ARE GENERATED.
Invalid Members [ACCOUNT]=642013030
Invalid Members [ACCOUNT]=642013025
Invalid Members [ACCOUNT]=638004005
Invalid Members [ACCOUNT]=638001015
Invalid Members [ACCOUNT]=636041020
Invalid Members [ACCOUNT]=636033010
Invalid Members [ACCOUNT]=636023025
Invalid Members [ACCOUNT]=636023015
Invalid Members [ACCOUNT]=636021050
Invalid Members [ACCOUNT]=636021035
Invalid Members [ACCOUNT]=636021020
Invalid Members [ACCOUNT]=636010015
Invalid Members [ACCOUNT]=636007010
Invalid Members [ACCOUNT]=636006190
Invalid Members [ACCOUNT]=636006035
Invalid Members [ACCOUNT]=636006025
Invalid Members [ACCOUNT]=636004005
Invalid Members [ACCOUNT]=636003030
Invalid Members [ACCOUNT]=636001025
Invalid Members [ACCOUNT]=636001020
Invalid Members [ACCOUNT]=636001015
Invalid Members [ACCOUNT]=636001010
Invalid Members [ACCOUNT]=636001005
Invalid Members [ACCOUNT]=632049005
Invalid Members [ACCOUNT]=535032010
Invalid Members [ACCOUNT]=535026010
Invalid Members [ACCOUNT]=531006025
Invalid Members [ACCOUNT]=531006015
Invalid Members [ENTITY]=PCAP02085

45 RECORDS ARE Rejected:
ACCOUNT ANALYSIS AUDITTRAIL CATEGORY ENTITY FLOW INTERCO RPTCURRENCY SCOPE TIME SIGNEDDATA ERROR MESSAGE
642013030 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 952683.23
642013025 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 2038986.76
638004005 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 6418.92
638001015 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 12676.94
636041020 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 133.14
636033010 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 37.04
636023025 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 2268.00
636023015 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 436419.04
636021050 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 600.00
636021035 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 83.33
636021020 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 16920.72
636010015 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 950.74
636007010 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 6416.00
636006190 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 1280.09
636006035 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 633.65
636006025 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 941.28
636004005 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 2000.00
636003030 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 67494.58
636001025 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 398.40
636001020 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 2379.52
636001015 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 80242.28
636001010 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 4277.45
636001005 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 650837.71
632049005 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 48710225.00
535032010 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 1358332.00
535026010 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 3948333.41
531006025 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 1052965.00
531006015 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 55615410.00
250006000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 22587.18
250004000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 9319995349.00
250003000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 298249.00
226001000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 952683.23
225001000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 2038986.76
224006000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 430805.61
224002000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 2000.00
224001000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 69.00
219004000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 97738749.66
116003000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 9323.60
113400000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 55.00
113101000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 7.11
106004000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 0.01
106001000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 122252.20
104002000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 1026025945.00
104001000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 - 1.60
102001000 NO_ANALYSIS AUD_1000 ACT PCAP02085 F_NOFLOW NO_INTC LC NO_SCOPE 2016.01 9459179137.98
0 RECORDS HAVE BEEN WRITTEN BACK.
WRITING TIME :0.00 ms.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Mar 08, 2017 at 09:42 PM
0

Log without script? Impossible to help!

Share
10 |10000 characters needed characters left characters exceeded