Advanced Configuration Options (Analytics)

copyLastUpdateDateOnFLush

Copies the last update date on flush to DS or Datamart.

Type – boolean

disable1eq1_BE_PA

Since 8.2 PFUN-13820 - Pricefx does not create these dummy 1 == 1 filters, so allow aligning the BE to that behaviour

Type – boolean

Sample value – false (default 8.2 to 9.x)

disable1eq1_Classic

Since 8.2 PFUN-13820 - Pricefx does not create these dummy 1 == 1 filters, so allow aligning Classic to that behaviour

Type – boolean

Sample value – false (default 8.2 to 9.x)

maxPATablesFetchLimit

Sets a default limit for the number of columns that are displayed in Datamart and Data source data tables.

See also – Data Sources and Datamarts

Type – number

paAutoLoadData

If disabled, data grids in PriceAnalyzer (Data Feeds, Data Sources, Datamart, Simulations and Rollups) are not populated with data automatically after you open them but only after you click the Refresh icon.

Configured on page – Administration > Configuration > Analytics > General Settings

See also – PA General Settings

Type – boolean

Sample value – false

paDailyCurrencyConversionRates

Allows you to increase the speed of queries on a Datamart with a Currency Data Source with daily rates.

Configured on page – Administration > Configuration > Analytics > General Settings

See also – PA General Settings

Type – boolean

Sample value – false

paDMFilterDropdownUsesUnderlyingDS

If enabled, filter dropdown queries on dimension fields in a Datamart are quicker because they are delegated to the underlying Data Source.

Configured on page – Administration > Configuration > Analytics > General Settings

See also – PA General Settings

Type – boolean

paDmNoGroupAllAccess

If enabled, data in Data Sources with set data entitlements are visible also to users who are not members of any of the entitled user group.

Configured on page – Administration > Configuration > Analytics > General Settings

See also – PA General Settings

Type – boolean

Sample value – true

paShowHiddenFieldsInDataGrid

If set to true, hidden fields are shown (and queried) in PriceAnalyzer data grids in the Classic UI. Default is false.

Type – boolean

paToPbMappingCustomerId

When mapping the product key from PriceAnalyzer to the Product key from PriceBuilder, it allows you to set the Customer ID.

Configured on page – Administration > Configuration > Analytics > Analytis to Price Setting Mapping

See also – PA to PB Mapping

Type – json object

Sample value – {
    "DM.TransactionsDM_Sales" : {
        "mapping" : "CustomerNumber"
    }, 
    "DM.ClickstreamDM" : {
        "mapping" : null
    }
}

paToPbMappingSKU

When mapping the product key from PriceAnalyzer to the Product key from PriceBuilder, it allows you to set the SKU.

Configured on page – Administration > Configuration > Analytics > Analytis to Price Setting Mapping

See also – PA to PB Mapping

Type – json object

Sample value – {
    "DM.TransactionsDM_Sales" : {
        "mapping" : "ProductId"
    }, 
    "DM.ClickstreamDM" : {
        "mapping" : null
    }
}

truncateDatamartOnNonIncRefresh

A DM Refresh can be run in two different modes: Incremental mode - Only the DS data modified or added since the last DM refresh is loaded in the DM. Non-incremental mode - All the source data is (re-)loaded in the DM. When the DM is already populated, a non-incremental refresh usually results in a costly merge of mostly the same data from the DSs into the DM. To prevent this, the DM is truncated first, resulting in a much faster load. But if a DM Truncate is performed before the DM Refresh, the DM can be without data for quite a long time (until the DM is fully populated again). When truncateDatamartOnNonIncRefresh = true new solution here is to do the Truncate and Refresh in one and the same DB transaction, and let this be driven by the DL’s incremental mode setting. To avoid disruptions in existing projects (even though it is strongly recommended that it should always be possible to rebuild a DM from its source data, there could be e.g. a PA Calculation DL that enriches the DM data once loaded and this DL may stop working after the full (non-incremental) DM refresh), the new non-incremental DM Refresh behavior is enabled only when an advanced setting 'truncateDatamartOnNonIncRefresh' is set to true.

See also – Data Loads

Type – boolean

Sample value – true