Skip to Content

Create RRI Drill Down in Analysis for OLAP 4.1

The functionality has been around for a long time via BEx and has proved extremely useful in many projects and is widely implemented across the industry. Here I detail how to set up RRI drill down in Analysis for OLAP a new feature in 4.1 releases, it’s very similar to the previous set up although this provides a very nice feature for the one Enterprise  reporting suite methodology especially when incorporated with jump links.

1. Logon to the BW system which the query is based and your OLAP connection has been set up for.

  • 2. Execute transaction RSBBS,select the query to use as your first point of navigation then select create.
  • /wp-content/uploads/2013/08/1_257562.png
  • 3. In the sender reviver assignment screen we will be drilling down into another BW query, though other options are available such as opening a relevant ECC transaction. In this case select BW query and then enter the receiver query technical name in the receiver object field.

    /wp-content/uploads/2013/08/2_257563.png

    4.  Select the assignment detail selection; this will define how the user navigates the drill down from one query to another. In this case the user selects an individual country which will provide a more detailed report in the same analysis space. Select your drill down type, field assignment and selection range
    in this case single, now select apply and save your settings.

    /wp-content/uploads/2013/08/3_257570.png

    5. Logon to Launch Pad and select Analysis for OLAP, create a new analysis workspace using your original query. 

    6. As before, right click the country characteristic you want to filter by and select go to > Your report which will then filter the report by the country you have selected and insert the analysis view into your session.

    /wp-content/uploads/2013/08/4_257571.png

    /wp-content/uploads/2013/08/5_257572.png

    7. Further analysis can then be completed on the view all within one workspace.

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