Forum Discussion

LeAnnTDang's avatar
LeAnnTDang
New Contributor III
9 days ago

Matrix Data Load

We are looking to load data from a year-to-date (YTD) consolidated statement of subsidiaries. The statement is in matrix form, with accounts (both balance sheet and profit & loss) in rows and companies in columns. Each company has two sets of columns: one for financial results and one for eliminations.

How can we set up the data source to read multiple companies' statements from one file?

We would like to load eliminations to a separate origin (Elimination). How can we change the destination for the Elimination columns? 

Also, how do we set up bypass row so that the load ignores headers and total rows? I noticed those rows can be identified by the Account column, where if the account is blank, then bypass. 

Data Integration
Data Sources
Import

1 Reply

  • T_Kress's avatar
    T_Kress
    Valued Contributor
    6 days ago

    You can set up a data source as a matrix data load to pull in the entities from various columns.  Here is an example:

    Set up data source as matrix like shown here:

     

    Define your matrix dim as entity (example here is U1 is matrix):

     

    As for loading to O#Elimination, you cannot load to that member.  That is a system generated member from the consolidation process.