Skip to Content
0

SAP BPC 10.0 Copy Consolidation (YTD) periodic data to Planning (PER) periodic

Apr 11, 2017 at 12:37 PM

293

avatar image
Former Member

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

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

1 Answer

Vadim Kalinin Apr 11, 2017 at 01:03 PM
0

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

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

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.

1
Former Member

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

0

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!

0