CrossProductThreshold
The CrossProductThreshold parameter specifies the minimum number of input sheets in one consolidation pass that is required before using the Select Distinct SQL query to assist in retrieving data entry values. Select Distinct searches only existing data (not missing data) from which to retrieve the data necessary to process the request. These settings are available:
| Value | Description |
|---|---|
| -1 | Does not use the Select Distinct query |
| 1000 | (Default) Uses the Select Distinct query if expected input exceeds 1,000 sheets for one consolidation pass |
| <positive integer> | Uses the Select Distinct query if expected input sheets exceed the specified number |
Generally, the setting of around 1000 provides the best performance. Compare the SelectFirstNode statistic from the log file with the total consolidation time to determine whether you need to change this value.
The number of input sheets is calculated as the product of the total members in each hierarchical dimension included in the request. Since one pass is required for each flat dimension (e.g., period-year, version, currency) and the Schedule dimension, the total number of members for these dimensions is assumed to be one (1).
Type: Scripting parameter, Engine property