Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Data Warehouse Deduplication

Avatar

Level 1

I'm trying to match up a Data Warehouse report to an Adobe Analytics Workspace, but the values aren't matching. I'm using 5 dimensions and 1 metric. When I filter for the same Dimensions on both, the Data Warehouse reports back a much higher number (2x-5x). I'm assuming that the Data Warehouse data hasn't been deduplicated but the Workspace data has. Is this the case? Is there a way I can dedupe the data before pulling it? 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

There are some basic difference between how Data Warehouse and Workspace data is processed. It depends on the metric/dimension which are used. Since, you cannot share the report here, the best way to troubleshoot would be to contact Customer Care.

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

There are some basic difference between how Data Warehouse and Workspace data is processed. It depends on the metric/dimension which are used. Since, you cannot share the report here, the best way to troubleshoot would be to contact Customer Care.