Forum Discussion

camagruder's avatar
camagruder
New Contributor III
2 years ago

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.  ...
Dashboards
Parameters
  • JackLacava's avatar
    JackLacava
    2 years ago

    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":

     

JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

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":

 

  • SamRichards's avatar
    SamRichards
    Contributor
    2 years ago

    Hey Camagruder,

    I agree with Jack that Dashboard data sets can be a powerful to. If I understand correctly, you can use a concat in the data adapter statement to join the three columns from the Biblend table to equal the account if the biblend to OS account mapping is one to one.

    Thanks,

    Sam

    • camagruder's avatar
      camagruder
      New Contributor III
      2 years ago

      Thanks Sam, it's good to hear from you!  I will try that.

      • SamRichards's avatar
        SamRichards
        Contributor
        2 years ago

        Hey, sorry I didn't put it together that was you.

        Thanks,

        Sam

  • camagruder's avatar
    camagruder
    New Contributor III
    2 years ago

    Thank you!  I will start going down that route.