BPC MS 75 - performance script send data to other application

[wissler_bastien]

Hello,

I have the performance problem with the following script

Can you have any idea in order to improve the script ?

Best regards

Bastien

script.txt.zip

[cecilia_petersson2 · Accepted solution]

Hi Bastien,

I haven't tried it myself but according to the documentation, using *XDIM_MAXMEMBERS breaks down the query into smaller ones which improves performance if the number of members of any of dimensions is very large. Try for example *XDIM_MEMBERSET Entity = 50 if Entity has many members. You can use *XDIM_MAXMEMBERS for max two dimensions.

/Cecilia

[wissler_bastien · Accepted solution]

Hi Cecilia

I add the row:

*XDIM_MEMBERSET Time = 1

but We dont win the time

[cecilia_petersson2 · Accepted solution]

Sorry, typo from my side... I meant *XDIM_MAXMEMBERS Entity = 50. Also, I assume Time may not be the dimension where you have scoped most members, so try it with a dimension that has many members.

/Cecilia

[wissler_bastien]

Hi, Sorry for the delay I modified the script *XDIM_MEMBERSET VERSION = %VERSION_SET% *XDIM_MEMBERSET TIME = %TIME_SET% *DESTINATION_APP = PLANNING *WHEN * *IS * *REC() *ENDWHEN *COMMIT But , after 3hours, BPC gives the error message : out of memory. According to SAP notes, It must to stop and restart all COM+ components and perform an IIRESET on the server.(in process) I think that there are 2 solutions. Solution 1 : copy the records to planning application directly in table of SQL serveur but I don't know this technical process . Anyone know the process it? Solution 2 : perform this script. According to the SAP documentation, in the script,the problem is that  BPC memorizes all records in memory So, It must to find the 'function' in order to limit the records during to execute the script Anyone know the 'function' it? Thanks Bastien

[wissler_bastien]

Remarks : We stoped and restarted  all COM+ components and perform an IIRESET on the server.but the copy the records is still very long

[JohnL]

Hi Bastien,

What service pack of BPC is this?

Thanks,

[wissler_bastien]

Version 7.5.106

[cecilia_petersson2]

Hi Bastien,

What's the purpose of using PROCESS_EACH_MEMBER in your case? I believe that when it's used, it's mostly with the Time dimension to ensure all periods are processed even if empty and that carry forward works correctly. But it also affects performance, so I suggest you try to omit it.

/Cecilia

[wissler_bastien]

//SEND DATA TO PLANNING

*PROCESS_EACH_MEMBER_MEMBER=ORGANIZATION

*SELECT (%ACCOUNT_ID%,"[ID]", "ACCOUNT" , "[GROUP] = 'GROUP' ")

*XDIM_MEMBERSET VERSION = %VERSION_SET%

*XDIM_MEMBERSET ORGANIZATION = %ORGANISATION_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET ACCOUNT = %ACCOUNT_ID%

*DESTINATION_APP = PLANNING

*ADD_DIM = MOVTYPE = F99

*WHEN *

*IS *

*REC(ACCOUNT=ACCOUNT.ID)

*ENDWHEN

*COMMIT

[Former Member]

Hi Bastien,

could you add the script as text to the thread?

BR,

Arnold