OneStream V7.0.1We have a Data Source that takes data file that has 12 data columns Oct ... Sep.The year for the data in the 12 data columns is a field "Fiscal Year", the first column of the data file.We have a Parser BR that is called on each of the...
Hello- I'm trying to load Headcount into our Finance model as a statistic. The table has no not data fields, just people records and emp ID. When I try to put a "static value" override of 1.00 in the "Amount" source dimension, I get an error stating ...
Has anyone used or familiar with OneStream SAP Connector. Need confirmation on couple of questionsIs it SAP certified?Can it connect to SAP On-Premise (with OneStream On Cloud) ? If so what config are needed? Do we need VPN connection? Thanks,Sachin
If you encounter an Amount field that has spaces as the thousands separator AND includes a DR/CR indicator (e.g. 12 345 678 D) then you'll need this to parse the value: Dim strRawAmount As String = api.Parser.DelimitedParsedValues(4) ' Zero-based and...
I am looking for an option to read the parsed Excel file XFD range and check if it contains any #Value! cells. I am able to find a point in TransformationEventHandler business rule to capture the parsed data (TransformerObject.Parser.DelimitedParsedV...
