(Resolved) Triplicate data when performing a YTD data import from FCCS to TRCS via Data Exchange
Summary:
When running a data integration from FCCS to TRCS. Data was first coming through on a periodic basis. Based on the administration of data integration guidance I found the following steps:
"Not: When pulling YTD from Financial Consolidation and Close and Tax Reporting, the optimal method is to convert the application to a DSO application, or use a DSO enabled application, and then select "All Data" as the extract data type, and then use "FCCS_YTD" as the filter for the View dimension."
I have performed these steps and the data integration works however in the workbench I note that I am getting triplicate data so, I have 3 copies of the same amount. The issue is that all the members in the data intersection are the same across all 3 rows so it is unclear why 3 copies are reflected in the workbench.