Bypass 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...
Forum Discussion
EricOsmanski
OneStream Employee
OneStream EmployeeGreg - have you considered a different approach? By bypassing Entities through Transformation Rules, the Source File/Connector or even on the Load Cube step (or other) I can see there being an issue where Stage doesn't reflect what is in the Cube (although what you are asking is possible). You may want to consider loading the Entities on the Workflows where they are assigned (and can take advantage of parallel processing) and then if the Profile is certified then the whole Import wouldn't get executed.
Hi Eric, thanks for the reply. Due to the ERP vendor, there is no direct connect available, so we have a fairly static TB file from the ERP with no parameters passed from OneStream to isolate specific workflow entities. Creating 50 different versions of the import files, in the ERP, to match the entities seemed cumbersome. Is there another way to load from one file through specific workflows?
We are going down the SFTP path. I would imagine Martin's group could parse and load the file by workflow entities, although to automate he would have to check for certification as well?
Appreciate the help on this.