Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  •  Cost

    • In DS – Is marked as a 'per unit' measure. This means that the amount of money (number) coming from Data Feed is meant as a 'per unit' amount.

    • In DM – Is already multiplied by Quantity (so by default it shows the total amount).

      • If the user wants to see the 'per unit' cost (e.g. in a chart), the system will divide the cost (stored in Datamart) by the Quantity column and return it.

      • If the user wants to see the cost as a percentage, the system will divide the Cost by the Invoice Price column (because it is marked as the 'percent' basis).

  • Invoice Price

    • In DS – Is marked as an 'extended' measure. This means that the amount of money (number) coming from Data Feed is meant as the total amount (for all quantity).

Limit the Number of Columns in Datamart

Excerpt
nameLimitNumberofColumns

Set the soft and hard limit for the number of columns. You can change the setting in pricefx-config.xml in the warnFieldCount and maxFieldCount properties.

Value

Message Type

Closable

Description

warnFieldCount > X

(info) Info

Yes

An info message is displayed in application.

warnFieldCount <= X <= maxFieldCount

(warning) Warning

Yes

A warning message is displayed in application.

XmaxFieldCount

(error) Error

No

An error message is displayed in application. Such field collection is invalid.

Example

Code Block
languagexml
<warnFieldCount>150</warnFieldCount>
<maxFieldCount>500</maxFieldCount>
Info

Note that only the support team can change the server configuration.