Processing Cost—Very High
Process Cost Explanation—Conditional mapping process returns recordsets with all dimension fields to the application server; results in high amount of data transfer and memory utilization
Server Resources Used—Application server
Recommendation—Restrict IN lists. Rather than using one large list, divide the list into multiple, smaller lists; optimizes memory utilization
Restrictions—None
Good Example—IN(xx,yy,zz) —> #Script
Poor Example—NA