Skip to main content

Display Contribution Total in the integration settings of HFM

To view Contribution Total in the integration settings for HFM in CXO:

  1. Open Microsoft SQL Server Management Studio
  2. Connect to Database Engine
  3. Open cxo_hfmstaging database
  4. Find the dbo.application_variables table
  5. Edit Top 200 Rows

For HFMexpress adapter

  1. Find IncludeInputCurrencies and set av_value to 1

When 'IncludeInputValues' is enabled, it only retrieving input values. 

Instead of EUR Total the  EUR and EUR adjs are being extracted, therefore a cube calculation needs to be created in CXO to show a summation of EUR and EUR Adjs, to have the EUR TOTAL value.

For older adapters 

  1. Find ShowInputCurrencies and set av_value to 1

Was this article helpful?

We're sorry to hear that.