3.11.3.1 Limit on Large Cross Products

The Static Table Driver user interface is designed to allow you to specify coefficient values for any combination - or even for every combination - of your Key leaves and Target leaves. For example, a simple Static Table Driver having 50 Key Leaf values (in one Key Leaf dimension) and 100 Target Leaf values (in one Target Leaf dimension) could have as many as 5,000 "active" combinations (that is, combinations for which coefficients are defined). Typically, the number of defined combinations is a small fraction of the number of possible combinations.

The number of possible combinations is determined by the Cartesian product of the number of leaf values in each dimension in your Static Table Driver rule. For example, a Static Table Driver rule having 5,000 Key Leaf values (in one Key Leaf dimension) and 5,000 Target Leaf values (in one Target Leaf dimension) has a cross product of 25 million. The performance and response time of the Static Table Driver user interface can degrade with extremely large cross products. For this reason, the application applies a limit of 20 million on the size of the cross product. You may modify the default limit by manually updating SETUP_PARAMETERS_MASTER.STATIC_TABLEID_TEMP_TABLE_CROSS_JOIN_LIMIT.

When you are working with a Static Table Driver whose cross product exceeds the cross-join limit, the Coefficients tab of the Static Table Driver user interface displays only the "defined" combinations, which are combinations where coefficients are previously established.