Can ERP transactional data be loaded into OS?
Hi, my company's OS data integration with the ERP system has been set-up to load monthly TB's into OS and for transactional tables to sit outside of OS but with the ability for OS to query and drill-back to view transactions. The transactional drill-back function is limited in that a drill-down first needs to be performed to get to the detailed dimensional intersections at the lowest UD level before a drill-back to view transactions (at that precise lowest level set of dimensional intersections) can be run. It is therefore easier to use a stand-alone BI viewer outside of OS to view transactions. Am wondering - is it possible to load ERP transactional tables into OS (this may contain millions of rows spanning multiple years) and for OS to then display transactional level detail across higher-level roll-ups (e.g. viewing transactions across a cost centre parent rather than only at an individual cost centre level), or even display transactional detail in quick views, essentially making OS have similar functionality to a BI viewer?
Audit History for Forms - CubeView drill down (v8.4)
I have drilled down to the bottom of both Origin and UD6 dimension which shows the data was loaded by corp accounting team. However, i cannot view Audit history for Forms - it continues to show as grey'd out. Does anyone know how to enable the audit history? thank you.
Use 2 fields to determine dimension value in datasource
Hi all, I need to set up a complex expression to assign a specific value to the U6 dimension based on 2 source fields. Below part of the list of those source fields. The code I set up for the complex expression is the following: Dim fields As List(Of String) = api.Parser.DelimitedParsedValues() Brapi.ErrorLog.LogMessage(si, "Field count (List.Count): " & fields.Count) If fields.Count > 4 Then Dim loadedAccount As String = fields(4) Brapi.ErrorLog.LogMessage(si, "loadedAccount: '" & loadedAccount & "'") If Left(loadedAccount, 2) = "00" Then Return Right(loadedAccount, 8) End If Else Brapi.ErrorLog.LogMessage(si, "WARNING: only " & fields.Count & " fields; skipping Account logic") End If Every time I launch the loading process, however, it prints the WARNING message for all the rows, as if it didn't find any source field. Am I doing something wrong / is there an alternative way to retrieve the fields values that I am not considering? Thank you for the help!OneStream and D365 Integration
Hi everyone, I'm currently working on integrating OneStream with Dynamics 365 (D365) and would love to hear about your experiences. Specifically, I'm interested in knowing which connector you used for the integration. Did you opt for OData, Synapse Link, or another method? Any insights, tips, or recommendations would be greatly appreciated! Thanks in advance!Matrix Data Load Basics
I 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 have has the year on one of the first lines in column 9. The next row contains the headers with periods in 12 separate columns. Is there an easy way to get the year from the first line (without a lot of code)? Or should I get year based on the POV? Then I am guessing a complex expression in the time columns to build the OS time key? I know I can do all of this in code, but I don't want to skip over any out of the box functionality or best practices. Any good guides on some of the best approaches with the Matrix load? Thanks, Scott
Data source Complex Expression in Logical Operator
I have 2 Datasource imports that I want to use the same mapping tables. The first workflow is an actual monthly GL load. The datasource is a comma delimited file and uses 2 different columns to determine the source value for the UD1 dimension. The second Datasource will use an Excel Matrix to Load Budget data for multiple periods. There is logic in the first Datasource to use the Account source value instead of the UD1 source column as defined by position. This is based on the value in the Account source field. See the code below: Dim Accountcol As String = args.Value 'Reminder - (2) column is 3th column in excel - need to count "0" as a digit Dim CostCentercol As String = api.Parser.DelimitedParsedValues(6) 'Identify PL Accounts (greater than 39999) If Accountcol > 39999 Then 'Need to bring in Cost Center Return CostCentercol Else 'Use Account as UD2 source Return Accountcol End If My question is How do I create a datasource using an excel Matrix load that refers to the Columns defined with A# and UD2# ? Is there a method similar to api.Parser.DelimitedParsedValues(6) that I can code into the Matrix based Datasource to test the source value coming from the Excel cilumn value ?
