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

Script Logic not selecting complete member set

116 Views

Hi

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:

*SELECT(%MEMBERS%, "[ID]", "PRODUCT", "OHTYPE='STUFF'")
*XDIM_MEMBERSET PRODUCT=%MEMBERS% //This is where the product are selected

*WHEN ACCVOLUME
*IS VOLSALES_PALLET

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

*DESTINATION_APP=OVERHEAD // Set the destination cube
*ADD_DIM BRAND=0000
*ADD_DIM PROJECT=000000
*ADD_DIM OPTIONAL3=00000000
*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=ENTITY
*SKIP_DIM=MARKET
*SKIP_DIM=PRODUCT //Skips the dimensions that are not included in the destination cube

*Commit 

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!!

Thanks,

Jamie