Skip to Content
Former Member
Nov 23, 2011 at 12:30 PM

Script Logic not selecting complete member set



I am hoping somebody can help me with some script logic. The script should move data from the origin cube to the destination cube, change a member name and skip other dimensions that are not included in the destination cube. The code is as follows:

*XDIM_MEMBERSET PRODUCT=%MEMBERS% //This is where the product are selected


*REC(FACTOR=1,ACCVOLUME="VOLSALES_PALLET_W") //This is where the member name is changed

*DESTINATION_APP=OVERHEAD // Set the destination cube
*ADD_DIM OHCOSTCENTRE=NOCC //Adds and sets the new dimension members ready for import into the destination cube

*RENAME_DIM ACCVOLUME=ACCOH //Rename dimension name to correct one in the destination cube
*SKIP_DIM=PRODUCT //Skips the dimensions that are not included in the destination cube


The problem I am having is that for some reason not all of the data is being transferred. I have checked the logs and it appears that not every member in the "PRODUCT" dimension is being selected in the query. There are a total of 1146 members in our PRODUCT dimension that meet the criteria in lines 1 and 2 of the above code. However only 964 members appear to have been selected in this query accroding to the log file.

I was wondering if there was limit on the amount of members that can be selected in a script logic query?

Hope someone can help!!