Workflow and Data Integration

Originally posted by Sam Richards3/29/2018 Has anyone leveraged the transformation process on an import to do a weighted average? I am thinking this is possible leveraging the derivative mappings but I wanted to confirm. For example if I have 5 loans that have an outstanding balance of different amounts and all have different rates. In the transformation process these then loans are going to have a many to one mapping all going to one market. What I would load into the cube for the market would be an weighted average based off of the loan balance.

Originally posted by Michael Malandra6/18/2018 Do we have a KB article on using Excel files as a source for an Import? I have formatting questions.

Originally posted by Matthew DeCarlo1/10/2020 I am trying to load budget data (which contains the 12 amounts in a single record, in multiple columns) from Excel using the import template, but unable to figure out the syntax for the column headers for the amounts. I have tried various formats but no luck. The latest version that I tried was: AMT#::[T#2019M1] AMT#::[T#2019M2]... I received an error indicating that there was no business rule [T#2019M1] . Any help would be appreciated.

Originally posted by Hans van der Kemp3/20/2020 I am trying to map historical data from SAP-BPC into OS. BPC has some accounts where 3rd P and Interco are booked on a single account.The ""top"" member is stored and is called ""TPTOP"". This member contains the sum of 3rd P + Interco. The Interco partners are also stored as ""IC1"" etc The issue is that the 3rd P component (our I#None) is generated by analysis services, and is therefore not stored. It cannot be extracted from BPC.So I would like to create a complex expression or BR that does ""I#None = TPTOP minus IC1, IC2 etc""Does someone have a snippet available for that?Another option could be to (manually) create an additional 3rd P load file, just for I#None, and merge it with the regular source file. But I prefer the code solution, because it is repeatable. 

Originally posted by Craig Masters4/5/2018 Is there a setting that needs to be changed to allow Zero's to loaded? When I load a file with zeros, those lines are stripped out in the staging table. I need to merge a file with zeros to replace the amounts currently in the system.

Originally posted by Chul Smith4/27/2020 How can you re-open workflows?

Originally posted by Chad FortmanOS Version: 6.0 Platform: Cloud   Hello, I am working on an enhancement for our automated change management process.  Lately the focus has been on Workflow Profiles.  Within the AuditWorkflowProfileEntityCalcs table (Application Database) you will find a column for CalcType which holds a numerical value.  I would like to find the enum or table that holds the friendly name that correlate to these values.  The API Details & Database Documentation help file does not seem to contain anything related to this column.  Anyone know anything about this?

Originally posted by Sarika PatilData from particular workflow profile, Scenario and time has been cleared. Trying to reload data  for the same workflow profile scenario and time. Got below error while loading .csv file Error: An Entity with same key already exist for .csv type file.    

Originally posted by Sheila GraffOur company is in the build stage.  We are looking for some input from OneStream clients on their experience with building a granular workflow profile.  Looking for pros and cons.  If you stayed with this approach or ended up pulling back.   Any insight is appreciated! Thanks!