59 ResultsMost relevantMatrix Consolidation: Eliminating Beyond Legal EntityPurpose of the document To goal of this document is to share our experience in designing for a matrix consolidation requirement, as well as to drive discussion on the topic. What we mean by “matrix...MatrixElim Sample.txtMatrix Data Load BasicsI have a matrix data load question. I get the concept of how the matrix data load works. I haven't done too many of them, so I want to make sure I'm not missing the basics. The file I h...SolvedView results from repliesMatrix Data LoadWe 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 c...SolvedView results from repliesMatrix Data Load - Data Source SetupI have a Matrix data file with 36 Months of data. The header has the periods in MM/DD/YYYY format. Is it possible to convert this Format to OS Period format like 2023M1 and return in each of the 36-t...SolvedView results from repliesSign Switch on Matrix Data SourceI have a delimited data source as matrix data to fetch opening, debit and credit flows. The credit amount comes in as absolute, and I need to factor it with *-1, but opening and debit flows must r...SolvedView results from repliesMATRIX CONNECTOR MULTI YEAR LOAD...nd the data is in Jan to dec. IS there any way to load all of this together. Right now i can use a matrix data and put in a complex expression which can either say workflow time & "M1" etc or i c...SolvedView results from repliesmatrix parser rule to change date to longHi, I have a matrix data source matrixed on Account. Sample below. One of the Account fields is a Date that I need to convert to a Long to store. I can do the conversion but not s...SolvedView results from repliesMatrix load using a connector data surce...ethod. The data structure type in the data source section in OneStream is setup as Matrix data as I need some of the column names to be mapped to the Accounts dimension members. When I run the data i...SolvedView results from repliesWorkflow Questions - Matrix Load, Load Methods & WF Channels1. It appears WF setup with a Matrix Data Source always imports ALL the periods updated in the Source file regardless of the WF Period I am importing from. Is it possible to limit it to Import only t...SolvedView results from repliesQuestion: A Data Source was created which is a Matrix Data Load “Figure 1” ... Question Continued Is it possible to dynamically reference the Source Field Name mapping “Figure 2”. For example, the application created is a 4-4-5 time series and dependent on the...