Map source account to target account member and Ud4 member
Hi Everyone, I have a source file which contains multiple accounts in the columns for one month. These accounts are not there in the cube. I do not have a ud4 dimension in the source file. Each source account should be mapped to an account and Ud4 member. for ex: Account a001 has to be mapped to account A#a1 and Ud4#cost. Similarly Account b001 has to be mapped to account b#b1 and Ud4#sale. A#[a001]=A#[a1]:UD4#[cost] A#[b001]=A#[b1]:UD4#[sale] How can this be achieved in the transformation rule. Also, the data source needs to have ud4 or not. Thanks, Jeevanapi.data.clearcalculateddata vs. clearing data using databuffer
Hi OS Community, Hope you are doing well! Out of curiosity, I wanted to check which approach is more efficient for clearing data: using api.data.clearcalculateddata or clearing combinations using databuffer? Few examples would be really helpful. Thank you!
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 help
documentation: 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
