In this article, we will discuss the Multi-Company Load (MCL) tool. We will discuss its features, its capabilities and when it is the right solution for you. Depending on what you are looking for in your consolidation process, BI360 offers a couple consolidation options.
What is Multi-Company Load (MCL)?
The MCL tool allows an organization to consolidate its company databases into one database for consolidated reporting. The BI360 MCL tool does the following:
- Consolidates at the General Ledger level only.
- Actual and Budget data ONLY.
- Supports organizations with many company database.
- Can be scheduled.
- Full load and incremental load options available depending on the ERP.
Is this the tool for me?
If you are looking for consolidations at the General Ledger level, then this is the tool for you!
Some requirements that can steer you away from this tool are:
- You need consolidations at the subledger level.
- You need real time or as close to real time consolidated numbers as possible. Data within the MCL application is based on the last time the MCL was run, so it is not live.
- You have a large number of company databases or a large set of data.
- The MCL process can take some time. The MCL will write to tables and cause the table to be "Locked". This can lead to Reporting speed issues.
The BI360 Data Warehouse
Solver BI360 can accommodate these requirements through the use of the BI360 Data Warehouse Manager. With the use of the Data Warehouse Manager, organizations can expect:
- Consolidations at the General Ledger and Subledger levels.
- New real time consolidation numbers via SSIS process.
- Easy handling of large data sets and organizations with a lot of company databases.
Plus, the Data Warehouse Manager allows for the consolidation of data from multiple data sources, currency translations, operational reporting, and much more.
- Multi Company Load 4x