Skip to Content
0

*SELECT bad performance

Jul 25, 2017 at 07:07 AM

50

avatar image
Former Member

We just finished migration on SAP BPC NW 10.1 SP11. Now we have problems with performance of script logic. The execution time of script logic has increased several times. Most of our script logic contain rows like:

*SELECT(%ACCOUNT_SEL_AST%, [ID], ACCOUNT, [ACCTYPE] = AST)

*XDIM_MEMBERSET ACCOUNT = %ACCOUNT_SEL_AST%

*XDIM_MEMBERSET CATEGORY = TEST

*WHEN ENTITY.CALC

*IS N

*REC(......)

*ENDWHEN

*COMMIT

Account dimension contain about 10,000 members and half of them are AST accounts.

When we change these rows on something like this:

*XDIM_MEMBERSET CATEGORY = TEST

*WHEN ACCOUNT.ACCTYPE

*IS AST

*WHEN ENTITY.CALC

*IS N

*REC(......)

*ENDWHEN

*ENDWHEN

*COMMIT

it works fine.

So we decided problem is *SELECT statement. Have you any suggestions about this?

P.S. before migration *SELECT statement worked fine.

Thank you.

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

2 Answers

Vadim Kalinin Jul 25, 2017 at 07:21 AM
0

SELECT itself is a very simple statement and is executed only once...

May be the issue is in scoping.

Please provide UJKT logs for both variants.

Also please explain, how do you launch this script - using DM or default.lgf?

Please read: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 25, 2017 at 12:02 PM
0

Vadim, thank you for your reply

Version and SP level of BPC system:

Current engine is JAVASCRIPT.

Script logic launched by DM package.

Problem was solved after implementing sap note "2455162 - Script logic performance is decreased after install note 2358637"


system.png (173.5 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Yes, the problem was related to scoping with huge number of members in XDIM_MEMBERSET...

0