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 ?
"Detail Cache summarization did not produce any Summary Data Rows" error
Hi, I am working on an Import/Validate/Load step and built a Connector which gets data from an Application table and a Data source which use the said connector. The connector/Data source seem to work in the sense that that gets pulled in during the import step. However, when the import step is run I receive the following error: "Summary: Detail Cache summarization did not produce any Summary Data Rows." Does any of you know what could cause the issue and what the error message means? Thank you
