Versions Compared

Old Version 1

changes.mady.by.user Ondřej Tesař

Saved on

compared with

New Version Current

changes.mady.by.user Ioana Kocurova

Saved on

Key

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

...

  • Product – Product master data. Usually a copy of data from Master Data.

  • Customer – Customer master data. Usually a copy of data from Master Data.

  • uom – Unit of measure (needed to compare different units of measure and recalculate values, e.g., kg to gram). For details on UOM, see /wiki/spaces/KB/pages/30048258How to Load Units of Measure.

  • ccy – Currency conversion table to recalculate money values to reporting currencies. For details on currencies, see /wiki/spaces/KB/pages/22183992How to Set up Currencies.

  • cal – Calendar to create week, month, quarter and year fields from the date fields. In every new partition, this Data Source is present. It is used for filling the Time Dimension columns in Datamarts (usually transactions) which are marked as Pricing Date (during refresh). By default this Data Source is empty. To generate rows for it, you need to run the Data Load DMDS.cal of the type Calendar. This Data Load is present by default as well. By default, this Data Load generates date rows 4 years back and 2 years to the future. This is configurable on the server. You should schedule this Data Load to run periodically, otherwise you will run out of dates some day in the future.

...