Solved
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 compani...
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.
