Expands the data source provider cross join approach to nested filtered sets.

This parameter is not applicable to Planning Analytics Engine.

Parameter type: optional, static

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

This parameter is active only in the following cases: ·
  • CognosMDX.UseProviderCrossJoinThreshold has a value greater than 0 in the Planning Analytics database configuration
  • UseProviderCrossJoinThreshold has a value greater than 0 in the Cognos Analytics qfs_config.xml configuration file.

To enable CognosMDX.PrefilterWithPXJ, add the following line to your Planning Analytics database configuration:


Default value: false