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, PM
sign 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 do something if it's a revenue account else pass through... but I don't know what that something 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.
derivative 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 name R69204ALLOC by 7 to get R79204ALLOC and the "M" in the UD7 Name by A to get AREA01 ? if this requires a business rule and you have one exemple please share it with me 🙂 thanks for you helpdocumentation: 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. Carlos
Parser 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 result
C#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. Thanks
