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)

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply