WELCOME TO MY WORLD

Hi THERE

I'M INDRAJIT. B.Tech [ CSE ] + MBA [ IT-HR ]. WORKING AS SAP BO-BI WITH S4 HANA SENOR CONSULTANT.

Subscribe to this blog!

Receive the latest posts by email. Just enter your email below if you want to subscribe!

My Other Works
Loading...

Multilevel chart drill down in design studio 1.6

Scenario 

Here I have a chart that shows month wise damage of equipment and data flows as follows -

[ MONTH ] >> [ DIVISION ] >> [ DEPARTMENT ] >> [ EQUIPMENT ]
Level -1
Dimension - Month
Measure    -  Damage count
Level -2
Dimension - Division
Measure    -  Damage count
Level -3
Dimension - Department
Measure    -  Damage count
Level -4
Dimension - Equipment
Measure    -  Damage count















Requirements - 

Data Source - S4 HANA  [ Calculation view  ]
BO Design Studio 1.6 

Canvas - 



The above picture shows the canvas of design studio. I have only one chart component (column chart, Chart_1) and only one data source(DS_2) added. The chart component is loaded with the data source.

Initial view of the DS_2 -



















In the initial view of DS_2 I have selected only one dimension and only one measure. The dimension is month because I need my chart to show the month wise damage count in the initial stage. Afterward I can drill down.

Drill Down - 



















So this is the coding for drilling down to the deepest level of the dimension. Once I select any month from the chart it takes me to the second(dimension) level and so on.

Here I have two global scrip functions.

 1. ClearDataSourceFilter                                
2. getSelectionData
 



Share on Google Plus

About AXEL BLAZE [ FATAL ERROR ]

3 comments:

  1. Hi, i follow ur step to create drill down function but i got an error on drilling down coding for "Level" it said = "Couldn't resolve reference to Variable "Level"

    why? need ur help..

    ReplyDelete
    Replies
    1. Hi Izdiany,
      have solved the above error. If so please help me to solve this error. Me too got the same.
      Thanks,
      Jai Ganesh J

      Delete
  2. Easy "water hack" burns 2 lbs OVERNIGHT

    Well over 160k men and women are utilizing a simple and SECRET "liquids hack" to lose 1-2lbs each night as they sleep.

    It's scientific and works with everybody.

    Here's how to do it yourself:

    1) Hold a clear glass and fill it up with water half the way

    2) And then do this weight loss hack

    so you'll become 1-2lbs lighter as soon as tomorrow!

    ReplyDelete