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

Amount and Annotation Confirmation Rule

Audit Trail for Calculated amounts

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