Skip to Content
Author's profile photo Uladzislau Pralat

Model Drill Down Using Out the Box Functionality

    Standard Design Studio analytic components such as chart and crosstab do support of drill downs along a hierarchy. Drill Down functionality can be modeled a number of different ways. In any case, drill down implementation should meet following requirement:

  • intuitive user interface;
  • convenience of use;
  • consistent look with other components.

In my drill down implementation I tried to meet all the requirements mentioned above.

I created an analytical application that uses SFLIGHT data model data and drill downs along following hierarchy Carrier -> Airplane Type -> Flight.

If user clicks on Carrier, then data is filtered by selected Carrier, drill downs changes to Airplane Type.

Drill Down 1.jpg

Selected Carrier is displayed in custom built Filter Line.

Drill Down 2.jpg

If user clicks on Plane Type, then data is filtered by selected Plane Type and drill down is changed to Flight.

Drill Down 3.jpg

Selected Airplane Type is displayed in custom built Filer Line.

Filter Line displays not only filter values, but also drill down level.

Filter Line allows to navigate one level up by clicking on Airplane Type tile cross icon.

Drill Down 4.jpg

Drill Down 5.jpg

Filter Line also allows quickly navigate all way to the top of the hierarchy clicking on Carrier tile cross icon.

Drill Down 6.jpg

Drill Down 7.jpg

Attached is an exported model (change extension to zip prior to importing)

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Ulad,

      I have a similar requirement in the project. Can you please share the script to achieve the drilldown? The one attached is not downloadable.

      please send it to


      Rajeev Dhawan

      Author's profile photo Former Member
      Former Member

      It works. It just seems to be a zip file inside the zip file.