The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Data Integration with source table
Hi, we are currently in the process of Finalizing a Data integration process (via connector) between some temporary staging tables created in the Onestream application (on cloud), but when i try to...
Hi, I haven't had that issue before, but the first thing I would check are the numeric settings of the Amount field in the connector data source. For example, is the Decimal Indicator option set to "."?
Thanks for your Answer. I did check the decimal separator and it's correctly set to ".".
Just for testing i tried removing all of the decimals, and also tried fixing the value in the source query to "100".
In the log file i can correctly see that it takes the 100 as 100.00, but still it tells me the amount is non numeric.
From your screenshot I can see you have some Attribute Value dimensions too, like Value10 or Value11. Are those all correctly mapped to numeric fields? (it is fine if they are not mapped to any source column, but they should not be mapped to non-numeric columns)
Hi, i checked and there was no column assigned to the Value columns. i also tried assigning the same Amount value but there was no change...
Hi MarcoG. Did you ever figure out the issue? We're facing the same.
