Skip to Content
avatar image
Former Member

Merged Excel query

I have a Universe query and an Excel query.

The Universe query contains 5 weeks of data while the Excel query contains a full year.

I need to have the data merged on the Week End Date, among other dimensions and when I use the Week End Date from the Universe query I'm able to only show the counts from the 5 weeks of Universe data. I need to be able to remove the Week End Date and show the counts from the Excel file for just the 5 weeks from Universe query.

I have tried ForEach([Week End Date]) but haven't had any success. Is there another way to accomplish this?

1.png (33.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 28, 2017 at 10:28 AM

    in the webi document summary check the option "extended merge dimension" and try.

    Add comment
    10|10000 characters needed characters exceeded