Merged Dimension: Left Join not working as expected

40 Views

I have a fairly simple problem. I have a list of employees in one query and list of employees who have submitted their timesheets in another.

I need a report that shows me a list of all the employees with their timesheet status. If an employee has not submitted then it should show up as a blank.

I've gone through the link below and a few others and followed whatever has been suggested but I'm not getting the expected result.

Merge Dimensions and extended merge in Webi

Image below shows what I've done. The 2 tables on the left are the results from query 1 and 2. The 2 on the right are 2 variations of what I've tried.

Note: The Timesheet Status - Detail variable is a detail variable on the Merged Portal ID dimension.

As per the blog post what I've done in the 2nd(rightmost table) should work but it is showing all blanks in Timesheet Status - Detail column.

Any suggestions?

Attachments

Merge.png (38.0 kB)