CognosMDX.UseProviderCrossJoinThreshold
Applies the data source provider cross join strategy, even if it is not explicitly enabled in IBM® Cognos® Analytics.
This parameter is not applicable to Planning Analytics Engine.
Parameter type: optional, static
This parameter is applicable only when using Planning Analytics database with Cognos Analytics.
When you enable CognosMDX.UseProviderCrossJoinThreshold, this has the same effect as enabling the UseProviderCrossJoinThreshold parameter in the qfs_config.xml file of Cognos Analytics.
UseProviderCrossJoinThreshold controls whether combinations of members on an edge, which have no measure values, are retrieved from the Planning Analytics database. UseProviderCrossJoinThreshold is enabled when it has a value greater than 0.
CognosMDX.UseProviderCrossJoinThreshold=1000
Default value: 0