Data Sources Reading Rows with No Amounts

Question

Is there a way to make a data source process rows that do not have a value in the Amount column?
For example,&nbsp; an import file has 4 rows:

Account Name
Cost Center Name
Amount

Cash
G&amp;A
5,000

AR
G&amp;A
5,000

AP
G&amp;A
&nbsp;

Retained Earnings
G&amp;A
10,000

OneStream will only process the Cash, AR, and Retained Earnings rows becuase the AP row has no value in the Amount column. While a complex expression can evaluate the empty amount in the AP row and retun "0", the Data Sources only processes the three rows into Stage.
&nbsp;

tschilling · Answer

Hi Gidon - There should be an option on the data source field in the Numeric Settings called 'Zero Suppression'.&nbsp; Set that to False and it should work.&nbsp;&nbsp;

Gidon_Albert · Answer

Right... This works with all source dimensions except for the Amount source dimension. The Amount source dimension determins whch rows a processed by the data source. Using complex expressions on other source dimenison works as long as the Amount source dimension has a value in it.

Setting the Zero Suppression to False does not make the Data Source process the record without an amount.

tschilling · Answer

Correct, I didn't realize you were trying to do it on the amount field.&nbsp; It is required to have a value.&nbsp;&nbsp;

Forum Discussion

Data Sources Reading Rows with No Amounts

Related Content

Reading an XFGetCell

Importing XFD multiple amount columns

SAP SIC Data Source

Loading Amount and Annotations together

Reading a file written to a user folder.

Account Name	Cost Center Name	Amount
Cash	G&A	5,000
AR	G&A	5,000
AP	G&A
Retained Earnings	G&A	10,000