on 06-16-2015 9:48 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bastien,
What service pack of BPC is this?
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
//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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bastien,
could you add the script as text to the thread?
BR,
Arnold
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.