Skip to Content
0

Merged Excel query

Nov 28, 2017 at 10:20 AM

24

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Nov 28, 2017 at 10:28 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded