Anyone use the HsGetVariable in Smart View??

Content

G'day, all!

I had a request to make Smart View Ad hoc reports used in reference doclets for Narrative Reporting more dynamic. So my thought was to add substitution variables. However, we all know with this comes the limitation that if you save the spreadsheet, you save the actual value of the substitution variable and not the substitution variable itself. So on to the HsGetVariable function; however, every time I use Build Function, I keep getting the error "Selected connection does not support this function. Select new connection."

Additionally, when I try to add the function in the cell directly, I either receive a