*SELECT bad performance

[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.

[Former Member]

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"

[former_member186338]

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

[former_member186338]

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/