SSRS Data Warehouse report that shows LastModifiedBy user
My Incident Management process owner requires an SSRS report with some Incident properties. There is only one I cannot deliver, Last Modified By user.
DWDataMart EntityDimvw contains a LastModifiedBy GUID, but apparently it can only be looked up against tables in the ServiceManager operational database (see link: https://social.technet.microsoft.com/Forums/systemcenter/en-US/0caa815d-5d42-4760-aaba-7251fb090ebd/how-do-i-get-the-lastmodifiedby-value-from-the-scsm-data-warehouse?forum=dwreportingdashboards)
Has anyone solved this differently? OR Has anyone successfully created custom dimension etc?
Appreciate any and all discussion.