Display Contribution Total in the integration settings of HFM
To view Contribution Total in the integration settings for HFM in CXO:
- Open Microsoft SQL Server Management Studio
- Connect to Database Engine
- Open cxo_hfmstaging database
- Find the dbo.application_variables table
- Edit Top 200 Rows
For HFMexpress adapter
- 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
- Find ShowInputCurrencies and set av_value to 1