CognosMDX.UseProviderCrossJoinThreshold

Applies the data source provider cross join strategy, even if it is not explicitly enabled in IBM® Cognos® BI.

Parameter type: optional, static

This parameter is applicable only when using TM1® with Cognos BI.

When you enable CognosMDX.UseProviderCrossJoinThreshold, this has the same effect as enabling the UseProviderCrossJoinThreshold parameter in the qfs_config.xml file of Cognos BI.

UseProviderCrossJoinThreshold controls whether combinations of members on an edge, which have no measure values, are retrieved from the TM1 server. UseProviderCrossJoinThreshold is enabled when it has a value greater than 0.

Note: If UseProviderCrossJoinThreshold is enabled in the Cognos BIqfs_config.xml, it takes precedence over the CognosMDX.UseProviderCrossJoinThreshold parameter in the tm1s.cfg file.

To enable CognosMDX.UseProviderCrossJoinThreshold, add it to the tm1s.cfg file and specify a value greater than 0, for example:

CognosMDX.UseProviderCrossJoinThreshold=1000

Default value: 0