Have you every wanted to pass a parameter to a view? It’s a standard request that can be a bit difficult to implement.
Unfortunately, there are more than a few tools still out there that aren’t prepared to accept a result set from a stored procedure or function.
In these cases you can inject your parameter into the database somewhere where the view can read it.
Read the rest on the Optimal BI blog.