Recent Discussions
Workflow Lock / Unlock Dashboard
Was asked to create a dashboard that gives the HQ admin the ability to lock and unlock Workflow profiles. Found bits and parts to use the user POV and descendants. Unlock descendants isn't working but.. Was looking at member tree and some of the other tree functionality, but couldn't get it to work for profiles. My thought is the profile hierarchy then they would select what to lock or unlock. Was curious if anyone had any recommendations or solutions they could share? Appreciate it in advance!
Including Journal Entries from Different Origin Member in Account Reconciliation Discovery
Hi Community, I’m working on an Account Reconciliation solution where I need to ensure posted journal entries balances are also included in the Account Reconciliation discovery process. Currently, by design the Discovery process only pulls trial balance information already imported and validated in the Stage. Therefore, I wanted to check if there’s a recommended, or best practice approach, to accomplish this requirement. Any guidance or examples would be greatly appreciated, thanks in advance for your help!
Delimited data source with skipped rows
Hi, we have delimited data source implemented in application. In data source we have two additional rows on top and one empty row- file works fine but now we want to retrieve information("Chicago") from skipped row(number 2). It looks that OneStream read data starting from row number 5. Could you please help me with understanding why these first rows were skipped? Thank you in advance.NetSuite to OneStream Integration
Hello all, I need to verify and confirm the method of choice to set up an NS to OS 8.5 integration WITHOUT the SIC in play. Here is what I have uncovered thus far.... A SuiteAnalytics Connect is being considered via ODBC so OS can pull data from NS. I read a few things about this. One is that a BR would be set up in OS to call on a SuiteScript in NS initiate the data pull. Now, the missing piece is how to set up the connection in OS if there is no ODBC installed. Another thing is that SIC would not be needed. I also perused a blog that stated that Support can set up s direct connection to NS from OS, provided they have the NS info. Can anyone please confirm this approach? Rest API could be leveraged but looking for an alternative. Any input would be greatly appreciated. Thanks, Ed PNo valid DataKeys (Scenario / Time) found in data source.
Hello everyone, I'm trying to create my first import from scratch. Unfortunately, it always gives me the same error : No valid DataKeys (Scenario / Time) found in data source. Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source. And no line is imported or displayed in the logs. However, I've gone down each parameter and everything seems correct and consistent with what I have on other import files. Could you help me investigate? My settings : All the UD1 to UD8 are on None. And the log :
Import parser on a Batch File
Hello, I've successfully set up an automatic upload using the Harvest Folder. However, I want to use the Skipline functionality within the file to reduce the import size. This works perfectly when I manually import the file into the specific Import Step. But when using the automatic upload via the Harvest Folder, the Skipline functionality doesn't seem to be applied. Does anyone have an idea for a possible workaround?
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.
