In B1 Dashboard you can host SQL Reports, but many ask us how they can reference the values of that SQL Report when doing LB: Golden arrows (aka where the action of a Golden Arrow is macro that custom open something).
The answer is quite simple. You just do the same as if it was a normal SQL Report on an SAP screen.
To reference it the syntax needs to be $[$BOY_1.<ColName>.0]
NB: It is only possible to read values in a B1 Dashboard SQL Report. You can't set values in them
Here is an example (image is high-resolution click link below to see in high resolution):