...
Topic | Tip | Details |
|---|---|---|
Incremental mode in Internal Copy | The incremental mode in Internal Copy tasks is not exactly the same as in the Refresh or Calculation type. Here, incremental means the Data Source will not be truncated before the copy, i.e., it will keep old records instead of being a true copy. | |
Deleting Data Loads | The Delete button only shows if all selected Data Loads can be deleted, i.e., they are either invalid (e.g., their target object is deleted), or they are not the default Data Load created by the system. (These system generated Data Loads cannot be deleted by a user, only if they are invalid.) | |
Activate Data Source to propagate changes | The changes and additions are not available in Analytics unless you successfully activate the Data Source. | |
Datamart does not store attribute values | Datamart is a physical table but it does not store a copy of all attribute values (for the default Normalization settings with value High). Only keys and calculated columns are stored, the rest of the data is joined dynamically when a query is run. | |
Expressions and joining tables | An expression cannot be used as a key for joining tables. | |
No field names changes in Datamart | It is not possible to modify field names (of fields coming from a Data Source) in a Datamart. The change has to be done at the Data Source level. | |
Responsiveness of Data Tables | To improve responsiveness of a Data Table, use filters if more Group By levels are required, use rollups where possible and save the Data Table in a grouped state. | |
CAST from DateTime to Date supported | Pricefx implementation only supports the CAST from a DateTime field to a Date. In other words, you can only convert a date with a timestamp to a date without a timestamp. | |
Charts | Only data fields marked as Dimension can be selected for aggregation and banding. | |
For Data Tables, there are hardcoded limits of maximum 10,000 displayed rows and 8 'Group by' levels. | ||
In Waterfall, two price points cannot be consecutive. There must be a surcharge or reduction in between. | ||
Only the settings of the chart are stored, not the underlying data. If the data changes, the chart will change accordingly. | ||
When you change the chart type, only values that can be mapped to the options in the new chart are kept. Data not supported in the new chart will be lost and additional data might be required to render properly the new chart. | ||
All charts in Pricefx are designed to display aggregations, i.e. rollups on the database level. This means that any formula must include an aggregation function to work correctly. |
...