SCSM SSRS SQL
Can anyone help, i need to get fields for affected user and also assigned to user on my reports. I can do one or the other using the following but doesnt work with both (using same code):
WorkItemAffectedUserFactvw AS AffectedUser ON workitem.WorkItemDimKey = affecteduser.WorkItemDimKey LEFT OUTER JOIN
UserDimvw AS userdim ON AffectedUser.WorkItemAffectedUser_UserDimKey = userdim.UserDimKey
Any help with this is appreciated.