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.

To report this post you need to login first.

6 Comments

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

  1. Mark Hudson

    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

    (0) 
  2. Steffen Bruckner

    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

    (0) 
  3. 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

    (0) 

Leave a Reply