How can I force a delimited data source to not skip blank values in an Amount field?
I have a situation where I'm trying to load trial balances from QuickBooks. The source file I'm receiving has three comma-separated columns - Account+Description, Debit, Credit. QuickBooks has a quirky output format where some debit balances are shown as "$-" (presumably to represent 0.00), leaving the credit column blank. If there is a credit value in the credit column, the debit column is blank. This is messing with OneStream's numeric processing of the Amount column when Amount is mapped to Column 2 (Debit column). It is rejecting the "$-" field values and the blank field values as Non-Numeric Amounts (verified in the XFL log file for the load). I can successfully replace '$-' with 0 using the Substitute Settings in the data source's Amount dimension, but I cannot figure out how to replace 'no value' in the Debit column with 0 (so that the valid Credit column values don't get skipped). I'm using a Parser Business Rule to return the net amount (debit column 2 minus credit column 3) for the Amount value, but the records where the Debit column is blank never make it to the parser rule (e.g. accounts 1170, 2000, and 2002 in the screen capture of the source file) because of OneStream's built-in Non-Numeric Amount preprocessing. I've tried various combinations in the Substitution Strings settings, hoping to find one that replaces the empty field with '0', but with no luck. I've tried all of the following Find combinations (the '$-' does successfully produce a 0 by the way). And yes, I know the documentation lists |Null| as a valid Replace value, not a Find value, but I thought I would try it in the Find string just to see if it worked: $-^ ^$- |Null|^$- $-^|Null|
Monthly Data from D365 into OneStream
Is there an interface from Dynamics 365 into OneStream? I have seen some comments mention direct connection with D365 using oData API. We have several business units across the world that will need to push month end data from D365. Is there a way they can just push the data from their end or would it have to come from OneStream to get the data?
Annotation Matrix load
Hi, we would like to know if it is possible to load multiple columns of amounts and annotations as a matrix load ( we have 3 date columns and 3 columns for amounts and it would be an account matrix as each column would go to a different account). We are able to load a matrix load where one column is an annotation and there are multiple amount columns, but when there are multiple annotation and amount columns, we have not been successful. See screenshot. The date columns would be loaded as annotations, the Begbal, Pmt, Interest columns to amount. Each column would be going to a different account. Please advise, thank youInclude Site Certificate when using HTTPClient
I'm trying to write a BR that returns data using HTTPClient. I've tested out the api.open-meteo.com example and can successfully pull data from this site. The site that I am trying to query requires a site certificate for authentication and I'm not sure how to tell my BR to use the site certificate that is already installed on the SIC server. On the SIC server, I can manually run the query to the source site via a web browser which prompts me to select the appropriate certificate. Has anyone been able to include a site certificate to a HTTPClient request? Thanks, Cosimo
Why 2+ Import of a Matrix Flat File of One Workflow Profile to Load Certain Months into a Data Cube?
For the first Import of a Workflow Profile, data in certain months in a "Matrix flat file" failed to be loaded into a Data Cube. For the second+ Import of that Workflow Profile, data in those months in that "Matrix flat file" could be loaded into a Data Cube. - In summary, data in certain months in a "Matrix flat file" must be Imported > 1 time of a Workflow Profile to be loaded into a Data Cube. Please share the root causes for v9.2. Thank you, SMEs.Unable to Post Journals to Locked Entity Despite Central Journal Input Step
Hello Everyone, I’m encountering an issue in OneStream when trying to post a journal via central workflow to an entity whose workflow is locked. Normally, central journal input steps are designed to allow journal postings even when the entity’s workflow is locked. In my case, I have configured a central journal input step within the workflow profile of the entity, so I would expect journal entries to still be accepted despite the lock. However, when attempting to post the journal, I receive an error indicating that the entity is locked. Has anyone experienced a similar issue where central journal input steps do not bypass the workflow lock as expected? Are there specific configuration points or workflow setup details that could explain this behavior?Need to send data from OneStream to Snowflake using an existing SIC ODBC connection
Hello, What is the best way to send data from OneStream to Snowflake using an existing SIC ODBC connection? Currently I am using SIC ODBC connection to query data from Snowflake and now I would like to send data back to Snowflake.File Explorer Incoming workflow folders missing in copied applications
This post is to provide information about File Explorer Incoming workflow folders. Based on what we've seen in our environments, when an application is copied, the new application does not contain the folder structure located at: \File Share\Applications\<Application Name>\Incoming\<Cube Root Name>_Cube\<Workflow Base Input Name>\<Workflow Import Name> We noticed these folders were missing in our last application copy when we were trying to copy files through SIC and drop them into the workflow import folders since our requirement was to drop them there for users to manually import when they choose (instead of automatically loading the files through batch import from batch harvest). To fix this issue we exported the Workflows and re-imported them back into the copied application. This triggered OneStream to create the cube root folders and workflow folders for the workflows that were imported. Hope this helps someone else who might be running into the same issue.
