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 Import error in Workflow : Global scenario member is not initialized
Team While importing data from local drive to Onestream through Import step (Load and Transform), i get an error "Global scenario member is not initialized". Can you please help:- 1. Why do i need to select the data source manually everytime from local file even after uploading the file in Data Source 2. How can i troubleshoot the issue "Global scenario member is not initialized" Regards SKVK
Intercompany Mapping using Derivative Rules
Hi, I am using Derivative Rules in order to generate additional records in Stage. In this example, I have two derivative rules per I/C transaction. The account mappings will bypass the original source value and one condition will be met and therefore loaded to the cube. If the value is greater than 0, then the value will go to 40L1CA.001A_DER. If the value is less than 0, then it will go to 40L1CA.001L_DER. Derivative Rules: Account Mappings: IC Mapping: The value shown below is $224,469.18 therefore the rule is correct. However, the IC is this case is mapping to None. I was expecting IC to map to IC partner 170 based on the IC mapping shown above. How can I ensure that the IC partner is mapped correctly to the cube? I want to ultimately tie out IC matching report.
