Hi Manoj, Thank you for your response. I'm not sure if my company will go for storing photos that way, but this solution is a definite possibility. I have moved in the direction of trying to extract the employee photos directly from the table using a DM. I am hoping to be able to show that in a report that can be pulled…

This will work to replace the hard-coded date: SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}{@{system.currentTime}[YYYY-MM-DD]}';

I was able to return results in edit mode of the analysis when I use this Advanced SQL Prefix: SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}{2017-01-01}'; I've tried many variations to replace the hard-coded date with a keyword such as CURRENT_DATE in YYYY-MM-DD format, but I can't seem to get the syntax quite right.…

I tried opening an SR and got the following response: "When you have presentation variable with set variable in the report advance tab, you have to execute this report from BI catalog Open link"