Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
SOLVED

List vars in Data warehouse reports

Avatar

Level 2

Hi- this might be a fairly basic question for someone familiar with Data warehouse reports, but I'm new to it, any help would be appreciated!

 

I was trying to fetch data as follows-

The first dimension (say d1) was broken down by another dimension (say d2), further broken down by dimension d3 which is a list var.

 

I expected the report to look something like this-

d1           d2                 d3

A             X                  a,b

 

However, the report looked something like this-

d1           d2                d3

A             X                  a

A             X                  b

 

Is this an expected behaviour or am I missing something?

Thank you!

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi @prerna ,

This is an expected behavior. Each unique de-limited listvar value show up in a different row.
For example:

s.list1 = “value1|value2|value3”;
When we will look at the report in UI for listVar1 (de-limited by ‘|’) we will see different rows as “value1”, “value2” and "value3".
Furthermore, we also have the DW report preview section to know how the report format will look like-

HemanginiS_0-1624751417111.png

 

View solution in original post

1 Reply

Avatar

Correct answer by
Employee

Hi @prerna ,

This is an expected behavior. Each unique de-limited listvar value show up in a different row.
For example:

s.list1 = “value1|value2|value3”;
When we will look at the report in UI for listVar1 (de-limited by ‘|’) we will see different rows as “value1”, “value2” and "value3".
Furthermore, we also have the DW report preview section to know how the report format will look like-

HemanginiS_0-1624751417111.png