Skip to Content
avatar image
Former Member

*SELECT bad performance

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 25, 2017 at 07:21 AM

    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/

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 25, 2017 at 12:02 PM

    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"

    Add comment
    10|10000 characters needed characters exceeded