Drill from Cube Views to Headcount Details using Linked Dashboards
I want to be able to drill to HR details in BIBlend from any users cube view, so I set up a linked Dashboard using Default NavLink parameters, and a SQL data adapter using these default parameters. ...
When you start having to do that sort of trickery, it could make more sense to "invest" in learning how to use Dashboard DataSets. There is a simple (if a bit outdated) example in this post, to give you an idea of what is involved. Basically you make the necessary query (or queries) yourself, eventually returning a DataTable or DataSet containing the results. This can then be run by a Data Adapter, with Command Type "Method" and Method Type "Business Rule":
