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, S
Data 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 somewhere
Data 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, GedComposite 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!
How 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...!!!
Pos / 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 /Kenneth
