Business Rule | One-to-One Transformation - E# Parent to its first E# Base
We need your help to Import flat files: 1. Number of Rows: > 100k 2. Organized under E# Parent Members: a few thousands 3. E# is extended We've been fortunate to be advised to build a BR to generate a one-to-one Transformation Rule file. - E# Parent to its first E# Base Is it possible for you SMEs to be generous enough to share with us/Community: - a sample BR to look up its first E# Base Member of an E# Parent Member - under extended E# - how to call that BR in an Import Workflow Thank you, OS SMEs.
composite mapping rule by period
Hello, I am new to Onestream and trying to solve something that seemed easy but it doesn't work:( We need to map an account by the entity and by the time. I used composite mapping. to be exact; A#[651200]:E#[8*]:T#2019M12} has to be mapped to account A A#[651200]:E#[8*]:T#[2019M3] has to be mapped to the account B - also all other instnaces of #651200 for all other entities are mapped to the acount B. I have only composite mapping for this account. It doesn't work. It totally ignores the time dimension. Any tips? thank you, Ola
Validation Error: No security access to data cell being cleared
Hi Team, We have a client that upload excel templates using xfdrange into OneStream. They have different files per Business Unit (UD2). Two of the files run into the following intersection error during the validation step: All the other files are correct, however, when they upload these two files, all data intersections (from all other files) are suddenly also invalid intersections. For examples, the line listed here is not from either of the two files but from a seperate file that has no errors when uploaded individually). When you would navigate to "Intersection" instead of "invalid Intersection (1)" all data intersections from all files are there. Only the local users get this validation intersection, when I (administrator) would run "Validate" from this screenshot, the error dissapears. Strange thing is: they have uploaded data on this intersection before in previous Forecast Scenarios without errors Security has not changed for either the application, user, workflow profile, entity etc. these two files both have an account that is only used there but is set up in the same way as all the other accounts (and previously could be loaded in other scenarios). Could just be a coincidence. Application Security: ModifyData is set to Everyone One thing to note is that this is a new forecast scenario we recently created for them, however, setup is the same way as the other forecast scenarios in terms of security. I am also having a hard time understanding the error and why it is refering to "clearing data" in the validate step. Anyone that can help me a little bit more in understanding the error or knows what could cause this? Thanks in advance!
Ability to refer to a source field in a composite transformation rule
When we created our application years ago for a particular source our account mapping only needed the Source Account to map. Now I have a need to do the account mapping based on a Location Source field that denotes a location for just two records exceptions. Can I make a Composite Rule mapping that somehow includes the location from the Source file to create a composite rule for this exception or is the only solution to now include the source location field on my data source, and modify all the current mappings to have a wildcard for that field except my exceptions that need to be mapped to a different account.Get Transformation Errors from a Batch Harvest job
I am running some data loads using Batch Harvest. I want to be able to capture the Validate Transformation and Validate Intersections errors to include in an email. I am able to get the Validate Intersections errors from the application table. Does anyone know how I would get the Validate Transformation errors? If I run the entire job within a BR then I can get the Transformation Errors, but I would rather run it through the Batch Harvest. I appreciate any input. Thank you. Scott
Validation Errors mapping to placeholder
Hey Folks, I am looking to map all validation errors that might occur during an automated load to a placeholder member in the UD1 dimension, but i am running into issues as the mask rule approach is not working. Does anyone else have any other way to make this work? Below is what i have tried but i still get kickouts in the validation step of the load process.
