Skip to Content

There is an  option when you drill down in a Webi report. In this document I have taken eFashion universe for demonstration purpose. Here we will provide user with an option wherein he can drill either from year to quarter or from year to month (quarter will be skipped). I have taken time hierarchy just for demonstration purpose, you can use any other hierarchy as per business requirement.

Steps:

1. Import the universe on which you want to work upon in the universe designer. Here I have imported efashion universe.

   Go to Tools ->    Hierarchies.

/wp-content/uploads/2013/12/67890_342238.jpg

/wp-content/uploads/2013/12/1_151507.jpg

2. You will see the default hierarchies out there.

2.JPG

3. Go to custom hierarchies & add a new hierarchy named Year to Month. I have also changed the name of the Time Period hierarchy to Year to Quarter.

3.JPG

4. Add Year , Month, Week and Holiday to the new hierarchy and click OK.

4.JPG

5. Save the universe and export it.

6. Go to Webi Rich Client and create a simple report comprising of Year, State and Sales Revenue.

7.JPG

7. Run the Report.

/wp-content/uploads/2013/12/ss1_342317.jpg

/wp-content/uploads/2013/12/8_151530.jpg

8. Click on the drill option on top right.

/wp-content/uploads/2013/12/ddddd_342318.jpg

/wp-content/uploads/2013/12/9_151531.jpg

9. Now when you click on the year dimension, you will be prompted with a pop up which will ask you whether you want to drill down to Quarter or Month,

    thus providing user with the flexibility.

10.JPG

10. Now when you click on the Year to Quarter you will get quarterly data.

12.JPG

11. And when you click on the Year to Month hierarchy you will get monthly data.

14.JPG

Thus if a user wants to drill directly to month, he will have an option at drill down. In this way you can add any number of hierarchies, thus providing user with the flexibility of choosing between them.

To report this post you need to login first.

6 Comments

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

  1. Sushma V

    Hi ,

    Nice Article ,

    But have one doubdt

    is this pop up option available in bo 4.0 sp6.

    Please let me know

    Regards

    sushma

    (0) 

Leave a Reply