BI_REPORT_CURRENCY - Version 2020 (10.0) - Hexagon

Smart Materials Web Installation (10.1)

Smart Materials/Smart Reference Data Version

With BI_REPORT_CURRENCY, you define the Smart Materials Web default currency. This currency is used in the reports where the spent money is shown. Enter the unit_id of the selected currency in the Setting Value field. Use this statement in SQL*Plus to determine the unit_id for the currency USD:

select unit_id from m_units where unit_code='USD';

For other currencies, replace USD with the unit_code of the currency.

The currencies are defined on the A.10.12 Units of Measure screen, underneath the CURRENCY unit group.

If different currencies are used in a project, ensure that the unit to unit conversion rules are defined on the A.10.13 Unit to Unit screen.