Skip to Content
Author's profile photo Dirk Mayrock

Enable “Drill” navigation behaviour like in WebI

Hi all,

in my training sessions for Design Studio I often get the question if it is possible to make the “drill” navigation style like known in web Intelligence available in Design Studio.

If you do not know what I mean with the drill navigation here is a short description:

Lets say you have a pre defined navigation path like Country, Region, Customer and a crossable showing the Country.

The user wants to click on the Country he is interested in and automatically this table navigates down to the Regions of the selected Country.

Clicking on one of the Region it shows the Customers. It is like what BEx clients know as “Filter and drilldown” functionality in the context menu of tables.

To navigate back the path upwards you can think of having a back button or something like that. And to visualize the actual navigation status you will have a bread crump text information.

In the end this szenario might look like this:

If you like use these reproduction steps to adopt it to your applications.

1. Create your Datasource (DS_1) showing Country in the Rows

2. Add a Crossable showing DS_1 and a Text component with Text “You are here: Country”

3. Add a button with the label “Back to start”

4. Create a Global Script Variable called “level” and define the default value as “country”

5. In the properties of your Crossable enable the selection option

6. Now define the onSelect code. The logic is…

  • depending on the actual level the filter for DS_1 has to be set,
  • the level variable has to be set
  • the actual dimension has to be removed from Axis,
  • the next dimension as to be placed on the Axis,
  • the Breadcrump Text has to be changed.

Find the detail code for the Crossable and the Button in the attached code.txt file

Of course there are adoptions to more levels possible or e.g. that you jump back to the start or the region when you select a customer, and so on…

General Remark: This scenario only make sense if you have a real predefined way to drill through your data. This is not suitable if you want to enable “free-style” navigation for your user.

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Senthilkumar VP
      Senthilkumar VP

      Amazing... Expecting the function to deploy.. Thanks for you post.

      Author's profile photo Former Member
      Former Member

      Dirk,

      Good post thank you. I was a little bit taken by surprise at how much code has to be written to deliver a basic "Webi Like" feature like drill down. I thought you may be intrested how DecisionPoint from SAP Partner Antivia handles such a scenario with no coding and leverages the SAP BusinessObjects Platform at the same time.

      http://antivia.wistia.com/medias/fwti5vhifq

      You can also try it for yourself at http://www.antivia.com/test-drive/try-decisionpoint.php

      Cheers

      Mark

      Author's profile photo Senthilkumar VP
      Senthilkumar VP

      Looking Nice ! Can this support complete functions as DS 1.3.

      Author's profile photo Former Member
      Former Member

      Great!

      Thanks for sharing!

      I wonder why DS does not have this function integrated.

      Hopefully this will be available without coding in the future but for now I am pretty happy with your code!

      Regards

      Steffen

      Author's profile photo Former Member
      Former Member

      Nice Information. Please share attachment, I am unable to find

      Regards,
      BD

      Author's profile photo Sumit Dubey
      Sumit Dubey

      Hi Dirk,

      I am following your article and this seems to be best possible solution for drill down within the crosstab in Design Studio. However, I couldn't find the txt file containing the sample code for this solution. Would you be able to share this ?

      Many thanks

      Sumit

      Author's profile photo Gino Terrigno
      Gino Terrigno

      Dirk, very interesting article.  Drilling-up is a feature Webi users have had access to for years.   Would you be able to share the code.txt file?

      Regards

      Gino