Forum Discussion

Franz's avatar
Franz
New Contributor II
4 years ago

How do I set up drill down for relational sources in BI Viewer?

BI Viewer
  • Franz's avatar
    Franz
    4 years ago

    Setting up drill down for relational sources in BI Viewer is a two-step process.

    First, you must add all of the dimensional levels you wish to the columns, rows, or arguments of the visualization on which you wish to drill down. Put the starting level for your drill down that the top and the lower levels beneath it, consecutively. An example can be seen here:

    In this example, our drill path starts at Region which drills to State and then finally to Customer.

    The second part of setting up drill-down is the enable drill down thru in the visualization section of the data menu of your visualization. 



    With these steps completed, your visualization is now drill-down enabled.

      

  • Franz's avatar
    Franz
    New Contributor II
    4 years ago

    Setting up drill down for relational sources in BI Viewer is a two-step process.

    First, you must add all of the dimensional levels you wish to the columns, rows, or arguments of the visualization on which you wish to drill down. Put the starting level for your drill down that the top and the lower levels beneath it, consecutively. An example can be seen here:

    In this example, our drill path starts at Region which drills to State and then finally to Customer.

    The second part of setting up drill-down is the enable drill down thru in the visualization section of the data menu of your visualization. 



    With these steps completed, your visualization is now drill-down enabled.

      

  • tsandi's avatar
    tsandi
    Contributor
    4 years ago

    Thanks Franz, can you please mark the asnwer as correct since this is the right way of enabling drill donw in a bi viewer?

  • erikstijnen's avatar
    erikstijnen
    New Contributor III
    3 years ago

    Hi Franz,

    just checking, are you saying that you can drill down on a single dimension this way? Because I can only add a single dimension and....that's it (unless I'm overlooking something).

    • Franz's avatar
      Franz
      New Contributor II
      3 years ago

      No. You are drilling on all of the dimensions that are included in the arguments pane. These arguments could include fields from any number of dimensions (e.g. state, customer, product.)