/
I can't see prices/dates in the Datamart

I can't see prices/dates in the Datamart

Question

I have all the data in Data Sources and everything seems to be set up properly, but the prices in the Datamart just don't show up.

Answer

Missing Currency conversion rates

If one of the fields in the underlying data source is of the Currency type, then make sure:

  • You have one of the date fields in the Datamart marked as Pricing Date.

  • You have currency conversion rates filled in the Currency (ccy) Data Source with a valid date.

Each partition has a base currency. If your Datamart's currency differs form the base currency, you need to insert a conversion rate from the DM's currencies to the base currency.

Missing Unit of Measure conversion factors

  • You have UOM conversion rates in the Units Of Measure (uom) Data Source.

Each partition has a base unit of measure. If your Datamart's UOM differs from the base UOM, you need to insert a conversion factor from the DM's UOMs to the base UOM.

Missing Year, Quarter and Week dates

If you deployed the Datamart and the Year, Quarter and Week date fields were generated for you but are missing data, make sure:

  • You have one of the date fields in the Datamart marked as Pricing Date and set as a dimension.

  • You run the Calendar task in the Data Loads for the Calendar (cal) data source.

The Calendar task populates the Calendar (cal) data source with the necessary dates which are then pulled into the Datamart.

However, if you want to use a calendar with custom values, e.g. a calendar for your fiscal year, the steps are:

  1. Truncate the Calendar Data Source.

  2. Truncate and reload the Data Feed Calendar.

  3. Navigate to Data Loads and flush the Calendar. If you run the Calendar job, it will reload the Gregorian calendar only.

About missing conversion rates for currencies and UOMs, it’s important to note that you need all the 1 to 1 rates (due to the conversion being computed at the DB level). For currencies, since you need to provide some validity dates, you can simply import then with validFrom 1/1/1900 to 1/1/2100.

Related content

Datamart Setup - Important Settings
Datamart Setup - Important Settings
More like this
Set up Currency Conversion in Datamart
Set up Currency Conversion in Datamart
More like this
ccy - Currency Conversion (Data Source)
ccy - Currency Conversion (Data Source)
More like this
Set up Unit of Measure Conversion in Datamart
Set up Unit of Measure Conversion in Datamart
Read with this
Some fields are missing after Datamart Refresh
Some fields are missing after Datamart Refresh
More like this
Advanced Configuration Options (Analytics)
Advanced Configuration Options (Analytics)
Read with this

Found an issue in documentation? Write to us.