Derivative rules
Hi experts, I have a group of GL accounts that I need to map to either an expense / revenue based on the sum of the balances. I thought this would be easy enough with a derivative rule; first create an interim rule to aggregate the accounts and then create a final rule to check if the balance is greater / less than 0. Finally, I have used the final derivative rule in my target account mapping. But, this is not quite working as expected. It seems to just add the negative balances of the individual GL accounts under the "_N" rule and the positive balances under "_P" rule, therefore both my expense and revenue account in OS ends with a balance. Could you please suggest what I am doing wrong? Regards, SSolved6.9KViews1like7CommentsData Imports
I have currently set up a new data source and associated transformation rules (and allocated to the appropriate workflow). Data importing is correctly working for 2022 time period, however I am getting the following error in any other time period...... I have got the Scenario as 'Current Datakey' and Time as matrix datakey in my columns Summary: No valid DataKeys (Scenario / Time) found in data source. Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source. Any ideas? I am assuming this might be one simple setting change somewhere5.8KViews0likes11CommentsTransformation Rule based on a different column in the source
Hi All, We're currently trying to map IC relationships in the transformation rules where the source data doesn't contain this field. We can map this based on the GL account from the ERP system but just unsure on how to do this in OneStream. Essentially we'd like to use 1-1 mapping but based a different column other than the IC in the source, is this possible? Thanks,Solved5.2KViews0likes5CommentsAttaching Intersection Errors to an Email During Automated Load Processing
Does anyone have example code they'd be willing to share here that allows the Intersection Error report to be attached and sent via email when errors are encountered during *automated* load processing? Our users are being notified that an error has been encountered, but they have to log into OS to look up what the error was (new unmapped account, etc.). It would be nice to provide the error detail as an attachment or in the body of the email. Also just curious how others in the community are notifying users that Load Errors have been encountered during automation, and providing the error detail to them? Any input is appreciated. Thanks!Solved4.4KViews0likes9CommentsData load for specific time period pulling data from other time periods
Hi all, I'm having an issue whereby I'm importing profit and loss actual's data via a csv file into one of the data upload workflow steps we have set up. However some of the data is being loaded into months it shouldn't be, even though on the in the csv file the data is pointing to the correct time period. So for example in the upload file, data is put against time periods such as 2023M1, 2023M2 etc. Having imported the data, validated it and loaded it to the reporting cube we have, some of the data is being loaded into 2023M1 and also 2023M2, when on the upload file it's only on there once against 2023M1. I've checked the transformation rules and everything is set up correctly in terms of translating the import file, so I was wondering if anyone has come across this type of issue before or if anyone has any advice as to where I could look next? I'm pretty new to OneStream so any help would be much appreciated. Thanks, Ged4.2KViews0likes5CommentsComposite Rule before 1:1 Rule - Order not Working
Hi I want my UD3 value to be None for all BS and Revenue Accounts and then only look to the department to the 1:1 mapping if it is an expense. I created composite rules that have for an example the expression A#[1*]:UD3#[*] with an order of zero and then the 1:1 mappings with the order of one but it still finds the 1:1 rule first. Does the order only work within the Type and they always trigger 1:1 types first? If that is the case an recommendations? PS we are currently doing this in the data source but we run into a problem when we have a new account that they have to reupload the file again so that it knows what the account mapping is. I figured if I put it in the UD3 transformation that the account transformation would have already happened. Thanks in advance!4.1KViews0likes6CommentsData Cell is read-only because Parent Workflow Profile has no active Input Profiles
Hi all, I have an Import, Validate, Load workflow that hasn't been used for a while. I'm trying to load in data and I'm getting invalid intersections at the validation stage with the following error message: "Data Cell is read-only because Parent Workflow Profile 'Workflow Name' has no active Input Profiles for the Workflow Channels that are assigned to the Data Cell's Account and/or UD member. Entity = Entity, Account=Volume, Origin=Import" Note I've use italics instead of using our entity names and workflow names. We didn't have this issue before so I'm not sure what has changed. The parent workflow profile stated in the validation message isn't actually the parent workflow profile so I'm totally confused. There is another post on this but I didn't understand the resolution. Could somebody please tell me what I would need to do to fix this? Thanks!Solved4KViews0likes3CommentsHow to Load a Data File having multiple columns of data
I'm trying to load a file that has data in multiple columns like below. I have created the data source with a Data Type as Matrix DataKey and created source Time Dimensions for 12 months as stated in the screenshot. But when I try to load the data, I get the below error every time. I have already created transformation rules for Scenario and time as below and not sure what else I'm missing here. Can someone please help with this one? Error Message: Thanks...!!!Solved3.8KViews0likes8CommentsPos / Neg check of total amount but keep all dimensions for future mapping
Hi, I have some accounts I either need to map to an asset account (100000) or liability account (200000). The mapping should be based on the total account incl. sum of all dimensions. e.g. A#12345:I#IcpA = 2000 A#12345:I#ICPB = -3000 Then both accounts should be mapped to the liability account, but still to IcpA and IcpB. If I create a derivative rule with create if < 0 and > 0 then it looks at all individual rows. If I then create a prefix check account where I set all dimensions to e.g. Total_Member, then it will also be Total_Member it includes in the further mapping. Any way I can do this in OneStream? Thank you /Kenneth3.6KViews0likes6CommentsBypass Certified Entities upon Import
Hi, we are using a Central Load workflow to load trial balances for ~1,500 entities(set up as unrelated entities). There are then approx 50 "Central Import" workflows where Entities are assigned and specific work is performed. The central load file pulls all entities and will be loaded at least daily. There are going to be cases when one workflow is certified and another still needs to be reloaded. The import, however, fails in order to avoid loading data to a certified Entity. Looking for any help on settings or BR to bypass already certified entities. Thanks3.3KViews0likes5Comments