on 04-11-2017 1:37 PM
Hello Experts
I have 2 models : 1. is Consolidation (YTD) and 2. Planning (PER).
I want to copy Periodic data of consolidation into my Planning Model.
I tried by using a simple script logic in my source model :
XDIM_MEMBERSET MEASURES = YTD
*DESTINATION_APP = MIS_PLANNING2
*ADD_DIM P_COSTCENTER = NONE
*WHEN Z_ACCOUNT
*IS *
*REC(EXPRESSION= %VALUE%, MEASURES = PERIODIC)
*ENDWHEN
But I am getting the below error "UJK_VALIDATION_EXCEPTION:Unknown Dimension Name in Keyword: "MEASURES:"
Any help on the same will be highly appreciated.
Regards
ATG
First - it's better to use your real name!
Second - try:
*XDIM_MEMBERSET MEASURES = PERIODIC
*DESTINATION_APP = MIS_PLANNING2
*ADD_DIM P_COSTCENTER = NONE
*WHEN Z_ACCOUNT
*IS *
*REC(EXPRESSION=%VALUE%)
*ENDWHEN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vadim
Thanks for the reply!!
While testing the logic in UJKT, even If I select just 1 entity and time selection as 3 months, I am getting an error as
"Memory Low.Leave the transaction before taking a break"
If I remove"*XDIM_MEMBERSET MEASURES = PERIODIC" , I am getting success with below RECORDS
CALCULATION BEGIN:
QUERY PROCESSING DATA
QUERY TIME : 5952.00 ms. 963 RECORDS QUERIED OUT.
QUERY REFERENCE DATA
CALCULATION TIME IN TOTAL :9529.00 ms.
963 RECORDS ARE GENERATED.
CALCULATION END.
SCRIPT RUNNING TIME IN TOTAL:15.96 s.
If I run the above script alongwith "XDIM_MEMBERSET MEASURES = PERIODIC" in Data manager package, The package gets aborted
Can you please help me in resolve this issue.
Regards
Ankur Goel
Unfortunately your user name is not changed...
And for sure you have to test script first on some small scope.
Please test it for single month, one entity and single account.
Check results!
Show UJKT log.
Dear Vadim
I am sorry since this is a company provided S User ID, I dont have the authorization to edit my name.
I got success when I try to test it for single entity and single TIME.Please see the below records.
FILE:\ROOT\WEBFOLDERS\PLATINUM \ADMINAPP\Z_CONSOL\TEST.LGF USER:AGOEL APPSET:PLATINUM APPLICATION:Z_CONSOL [INFO] GET_DIM_LIST(): I_APPL_ID="Z_CONSOL", #dimensions=10 MEASURES,TIME,Z_ACCOUNT,Z_CATEGORY,Z_DATA_SRC,Z_ENTITY,Z_FLOW,Z_INT_CO,Z_RE_CURRENCY,Z_SCOPE #dim_memberset=5 Z_ENTITY:2000,1 in total. TIME:2017.02,1 in total. Z_CATEGORY:Final,1 in total. Z_RE_CURRENCY:SAR,1 in total. MEASURES:PERIODIC,1 in total. REC :%VALUE% CALCULATION BEGIN: QUERY PROCESSING DATA QUERY TIME : 27421.00 ms. 329 RECORDS QUERIED OUT. QUERY REFERENCE DATA CALCULATION TIME IN TOTAL :8912.00 ms. 329 RECORDS ARE GENERATED. CALCULATION END. SCRIPT RUNNING TIME IN TOTAL:36.55 s.
However , can you suggest how can I scope the logic.Should I create a Company and time Selection and run the logic for every month and for individual company.
Regards
Our community is community of individual persons not a community of some generic accounts belonging to some company! Please register your personal account based on some e-mail (on gmail.com for example) and I will answer your questions!
P.S, And when posting please look on the post results - your last post is unreadable!
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.