Corporation Switch User Manual

WebADI Spreadsheets A-1

WebADI Spreadsheets

Financial Consolidation Hub utilizes WebADI spreadsheets to allow you to upload and

manage moderate amounts data. WebADI spreadsheets give Excel a live connection to

your instance, allowing you to both pull information from the environment and upload

it within Excel. This chapter provides in detail how Financial Consolidation Hub uses

WebADI spreadsheets.

Financial Consolidation Hub uses WebADI spreadsheet loaders for the following tasks:

• Create and Update Dimension Members

• Create and Update Dimension Hierarchies

• Create and Update Value Set Maps

• Create and Update Historical Rates

• Create and Update Line Item Intercompany Maps

• Create and Update Adjustments

• Create and Update Acquisition and Disposal Entries

• Perform Data Submission for External Sources

Requirements

You must set the proper security options in Excel to enable WebADI.

Excel 2000

Navigate to Tools > Macro > Security