My problem is: the data (number of rows) that I'm exporting with DWH is different from the data that I get in the Adobe workspace in a Freeform table. The number of rows that I get with the DWH tool is different from the data I get doing (theoretically) the same thing in the Workspace.
What I've tried:
I'm exporting data using the DWH tool to get data from two custom dimensions let's call them (ID_AUTHOR and NAME_AUTHOR), so that the second dimension breaks down the first one like in the example below. I'm using a specific VRS (it filters a specific set of data) to perform the test. I don't have a clue why is this happening because it happens the same with other VRS that the customer is already using.
For the sake of simplicity the report I'm trying to extract follows this structure:
Dimension 1: ID_AUTHOR
Dimension 2: NAME_AUTHOR
VRS: Product_1.
Date_range: 2021-01-01 to 2021-01-02 please mind that (yyyy-MM-dd)
so the freeform table looks like this:
------------------------------------------------------------------
The DWH report I've created looks like:
and of course same date range and VRS as above.
Let's say that my test set in the AA workspace is retrieving 100 registers and the report I get form DWH retrieves 122 registers. As you can see there is a big difference in the number of lines retrieved but the most funny thing is that there are some registers in the AA workspace that don't appear in the DWH exportation and vice-versa.
I'm probably doing something wrong when I get the information from DWH but I don't have a clue what is happening. Am I using wrongly the VRS in DWH?
Am I missing somethin when I break down the dimensions?
Solved! Go to Solution.
Views
Replies
Total Likes
I suspect that it could be due to the segment used in the VRS and how they are evaluated in DWH v/s Workspace. I'd recommend that you reach out to Client Care team for a thorough investigation and findings.
Views
Replies
Total Likes
I suspect that it could be due to the segment used in the VRS and how they are evaluated in DWH v/s Workspace. I'd recommend that you reach out to Client Care team for a thorough investigation and findings.
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies