BPC Currency Translation high execution time

[former_member1254457]

Hi community,

I`m having a problem with the execution time of the currency Translation process, the process its executed in 2 hours average, We have SAP BPC 11.1 - Classic Implementation.

The Process is called using this logic:

// Currency conversion is handled by a program called CURR_CONVERSION. This program is launched using the following logic statement

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %VERSION_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

RATEENTITY = Global

// INCREMENTAL_MODE = X // FULL Execution

*ENDRUN_PROGRAM

The initial Data is about 6 million records, after the execution in the formula log of the process the submitted records are about 15.5 million records.

In order to improve the system performance we have this parameters mantained in SPRO:

Global Parameters:

BUFFER_MAX_PART_COUNT 1000

BUFFER_MAX_ROW_SIZE 90000

BUFFER_ROW_SIZE 40000

BUFFER_WAIT_TIME_TO_EXIT 5

DISABLE_TRANS_POPUP_WARNING X

ENABLE_PARALLEL_EXECUTION X

ENABLE_QUERY_CACHE X

MAX_SESSION_COUNT 12

MONITOR_WAIT_TIME_TO_EXIT 10

PARALLEL_SERVER_GROUP BPC

REFRESH_STATUS_INTERVAL 10

RFC_CUA_DESTINATION BPC_SERVICE

RFC_DESTINATION BPC_SERVICE

THRESHOLD_HIER_SEL_BUF -1

TRANS_AUTO_OFFLINE Y

Environment Parameters:

ACCELERATOR_ON X

ALLOW_EXTENSIONS XLS,XLT,DOC,DOT,PPT,POT,XML,MHT,MHTML,XLSX,XLSM,XLSB,ZIP,PDF,PPTX,PPTM,POTX,POTM,DOCX,DOCM,DOTX,DOTM,CDM,TDM,PNG,GIF,JPG,CSS,MRC

ALLOW_FILE_SIZE 104857600

CT_NEWCAL X

DEFAULT_EXTENSIONS XLS,XLT,DOC,DOT,PPT,POT,XML,MHT,MHTML,XLSX,XLSM,XLSB,ZIP,PDF,PPTX,PPTM,POTX,POTM,DOCX,DOCM,DOTX,DOTM,CDM,TDM,PNG,GIF,JPG,CSS,MRC

ENABLE_SHARED_OBJECT Y

LOGLEVEL 3

Consolidation Model Parameters:

BACKGROUND_SERVER_GROUP BPC

BPC_STATISTICS OFF

CT_PACKAGE_SIZE 1000000

ENABLE_FIXED_CUBENAME X

ENABLE_HANA_MDX

ENABLE_PARALLEL_CONS X

INTERVAL_NR 10

JRN_MAX_JOURNAL_ENTRY 20000

MULTIPLY_COEF 50

NW_VERSION 0

PACKAGE_SIZE 1000000

RECLEVEL_NR 50

SPARSITY_COEF 5

I have executed different escenarios with different values in CT_PACKAGE_SIZE but the result its the same, I`m trying to increase the package size of the process to improve the time response but always are the same records in the packages 40,000 records.

It seems like the system is not taking into account the SPRO parameters CT_PACKAGE_SIZE and PACKAGE_SIZE even when incremental mode is off.

Can you please check if something is missing?

Thanks in advance,

RB