Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Data Warehouse Deduplication

Avatar

Avatar
Level 1
rabisaab
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
rabisaab
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
rabisaab
Level 1

18-06-2020

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? 

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Boost 5
Employee
Khurshid_Alam
Employee

Likes

49 likes

Total Posts

181 posts

Correct Reply

37 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Employee
Khurshid_Alam
Employee

Likes

49 likes

Total Posts

181 posts

Correct Reply

37 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
Khurshid_Alam
Employee

15-07-2020

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.