Fetch Metadata values from Text file in Transformation Event Handler
Hi Experts, I am working on TransformationEventHandler rule in which we need to read the first 4 columns of a text file that is being uploaded to Workflow Import so I can do some sanity checks and error out if they are not correct. Does anyone have sample code that reads the values of file? I checked everywhere but not much documentation on this. Also, I placed this code in "ParseSourceData" BREventOperationType. Not sure if this is correct or need to put under "ParseTransformationRules"? Thanks in advance, PM136Views0likes4Commentssign flip in complex expression
When loading data, all of our accounts from source match the names of the account in OneStream so we've always used a *:* rule for the account maps. However, we have a new dataset coming in and we need to flip the sign for those accounts that are of account type Revenue in OneStream: not assets or anything else, just revenue. I have working code that will conditionally dosomething if it's a revenue account else pass through... but I don't know what thatsomething should be to flip the sign. Other people have posted questions about how to do a sign flip in a complex expression but there are no answers. I definitely do not want to maintain a manual list of 1,500 1:1 rules that do nothing but flip the sign. The complex expression feels like the only scalable solution but this detail is missing.3.8KViews0likes12CommentsHelper Classes
I feel like an idiot asking this question but I can't find anything on google. Where do all of the 'Helper' classes come from? TimeDimHelper,StringHelper,ApplicationZipFileHelper,ScenarioDimHelper Are these all OneStream specific? Is there any documentation or good posts about their use? Thanks, ScottSolved1.2KViews1like4Commentsderivative rule syntax
Hello, Im tryin to derive few rows like this: E#[*]=HQ_MANTUGR:A#[R69204ALLOC]=R79204ALLOC:U7#[MREA01]=AREA01:U8#[EUR]=None is there any otpion i can use to tell the system to replace only the "6" in the account nameR69204ALLOC by 7 to getR79204ALLOC and the "M" in the UD7 Name by A to getAREA01 ? if this requires a business rule and you have one exemple please share it with me 🙂 thanks for you help124Views0likes0Commentsdocumentation: file having all functions syntax/ library/ libraries
Dear all, Is there any file containing the detail/syntax of the functions? I'm thinking for instance in an XML file or something similar. This is a similar question already posted, but I'd like to know if there's an update. Solved: documentation/list of functions in OneStream Namespaces/Libraries - OneStream Community (onestreamsoftware.com) Thank you in advance. Carlos446Views0likes3CommentsParser Business Rule
I am trying to write a parser business rule to give the portion of a string that begins with US and the 6 characters after from a data source. For example, the imported line reads "mmmmmmmmmUSxxxxxxmmmmmmm" and I want to parse out USxxxxxx to which is mapped in the transformation rules. I also need it to be dynamic because the line will not always be in the same character place. It could also be "mmmmmUSxxxxxxmmm" or anywhere else within the text. I have tried using the rule below but it is not bringing back any values. The import is reflecting "blank." Dim sText As String = args.Value Dim result As String = "" If sText.Contains("US") Then result = sText.Substring(sText.IndexOf("US"),8) End If Return result702Views0likes4CommentsC#Aggregated and Custom Translation Rule
I am looking to create a FX Rate finance rule or calculate to go get the planning scenario's last actual month's closing rate from the ClosingRate FX table. I am using the consolidation member C#Aggregated in the planning scenarios. I know that C#Aggregated executes business rules at the base level only. Is there a workaround here or if I use C#Aggregated am I stuck creating FX rate tables for each planning scenario and copying last actual month rates forward to the planning periods? Appreciate any help or guidance. Thanks563Views0likes1CommentType 'SqlBulkCopy' is not defined.
Hello everyone, I am trying to create a table in OS with the fx rates by calling an API while calling the API, i can get the data needed but i have this error <Type 'SqlBulkCopy' is not defined.> that's doesn't allow me to copy the data in a table in OS. this is a part of the code, the lines in orange are the ones not working. 'create table ' #Region "Create Table Currencies_Mantu" Dim sSQL As String = $" IF OBJECT_ID('Table_rate_mantu') IS NOT NULL BEGIN DROP TABLE Table_rate_mantu END CREATE TABLE Table_rate_mantu ( fromCurrency varchar(255), exchangeRate numeric(18, 5), date varchar(255) ); " Dim strPeriod As String = "" Dim strCurrency As String = "" Dim strPivot As String = "" Dim strclo As Double = 0 Dim vavg As Double = 0 For Each row As DataRow In dt.Rows strCurrency = row("fromCurrency") ' strclo = row("Value1") vavg = row("exchangeRate") strPeriod = row("Date") Dim fxRatePkUsingNamesAvg As New FxRatePkUsingNames("exchangeRate", strPeriod, strCurrency, "EUR") Dim objFxRateUsingNamesAvg As New FxRateUsingNames(fxRatePkUsingNamesAvg, vavg) Dim objXFResultAvg As XFResult = BRApi.Finance.Data.SetFxRate(si, objFxRateUsingNamesAvg) ' Dim fxRatePkUsingNamesAmount As New FxRatePkUsingNames("ClosingRate", strPeriod, strCurrency, "EUR") ' Dim objFxRateUsingNamesAmount As New FxRateUsingNames(fxRatePkUsingNamesAmount, strclo) 'Dim objXFResult As XFResult = BRApi.Finance.Data.SetFxRate(si, objFxRateUsingNamesAmount) ' BRAPI.ErrorLog.LogMessage(si, "PBO objXFResult=" & objXFResult.Message) ' BRAPI.ErrorLog.LogMessage(si, "ClosingRate= " & strclo) BRAPI.ErrorLog.LogMessage(si, "exchangeRate=" & vavg) BRAPI.ErrorLog.LogMessage(si, "Currency=" & strCurrency) Next Using dbconn As DbConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si) BRApi.Database.ExecuteActionQuery(dbconn, sSQL, False, True) Using bulkCopy As New SqlBulkCopy(dbconn.ConnectionString) bulkCopy.DestinationTableName = "Table_rate_mantu" bulkCopy.WriteToServer(dt) End Using End Using #End Region Do you have any idea why this is not working in OS ? ThanksSolved1.4KViews0likes6CommentsPop Up Notification
Dear Community, I have a requirement to generate a pop-up or warning message during the Data import process based on a specific condition. If the condition is met, the pop-up should inform the user, but the import process should continue without causing a hard fail. Is this achievable ? Can anyone please suggest a method to achieve this. Thank you.2KViews1like8Comments