Skip to Content
0
Former Member
Jul 25, 2017 at 07:07 AM

*SELECT bad performance

94 Views Last edit Jul 25, 2017 at 07:14 AM 2 rev

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.