CognosMDX.PrefilterWithPXJ
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:
CognosMDX.PrefilterWithPXJ=true
Default value: false