How to Perform RRI from a Design Studio Application to an Analysis for OLAP Workspace (Part 1)
Design Studio is often used to create dashboards. In this use case, it is often necessary to allow users to drill-through to another report which contains more detailed information. An Analysis for OLAP workspace or a WebI document are commonly used to contain these detailed information. But how do you enable such drill-through/RRI? The answer will depend on what data sources are connected to your Design Studio application and how you’ve deployed the Design Studio server (e.g. integrated with the BusinessObjects BI platform or though HANA). In this blog series, I’ll cover how you can configure RRI from a Design Studio application to an AOLAP workspace if you’re using SAP BW as your data source. In this blog (the first blog in the series), I’ll assume you’ve deployed your Design Studio server as part of the BusinessObjects BI platform. In my next blog, I will cover how you can achieve the RRI if you’ve deployed your Design Studio server as a separate instance. The solution I’ll discuss in these blogs can be adapted for WebI documents as RRI targets.
RRI from Design Studio Application on top of BW to an Analysis for OLAP Workspace
If you’re using SAP BW as your DataSource, you’re in luck. Enabling RRI is straightforward as SAP provides standard functionality to configure RRIs using transaction RSBBS. In particular, the standard RRI functionality allows you to configure an RRI from a query (or queries within an InfoProvider) to any web address. You can use this functionality to call an OpenDocument URL that will open an AOLAP workspace and pass the prompt parameters. Since the complete path to the opendocument.jsp page changes as components are moved from the development system into the QA system and beyond that, you need to make sure that the URL you configure in transaction RSBBS is a relative URL (i.e. relative from the base URL of the BusinessObjects Server).
To make sure that the configuration steps are clear, I’ll guide you through the configuration using two simple BEx queries. Query #1 is YEN_DEL_Q001 which contains Fiscal Year and Value Type in rows and Amount in the columns. We will use YEN_DEL_Q001 as our source query (i.e. we will perform an RRI from YEN_DEL_Q001). The row/column definition of YEN_DEL_Q001 is shown below. The important thing to take note is that YEN_DEL_Q001 contains the characteristics which we will base our RRI on. In this case, we will use Fiscal Year and Value Type.
Query #2 is YEN_DEL_Q002 and its filter definition is shown below. The important thing to take note is that YEN_DEL_Q002 contains prompts (i.e. input-ready variables) for Fiscal Year and Value Type. Using RRI, we will populate the values of these variables.Take note of the technical names of the variables. They’ll be needed later.
Here are the steps that need to be followed to configure an RRI to an AOLAP workspace from a Design Studio Application. Note that to use a WebI document as an RRI target, you simply need to change the syntax of the field names in step #10.
1. Launch transaction RSBBS (Maintain Sender / Receiver Assignment)
2. In the “One Query” tab, enter the technical name of your query as the sender. In our example, this is YEN_DEL_Q001. Note that you can also go to the “All Queries in InfoProvider” tab and enter the name of your InfoProvider.
3. Click the “Create Receiver” button. A dialog box with the title “Maintain Sender / Receiver Assignment” appears.
4. Select “Local” as the Target System.
5. Select “Web Address” as the Report Type.
6. Under the “Report” section, use the input help to bring up a text box in which you can enter a Web Address.
Type a Web Address of the form /BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=<CUID of your Analysis OLAP Workspace> and click Apply . In this example, I’ve created an Analysis OLAP Workspace for Query #2 (YEN_DEL_Q002) and its CUID is ActPNwZm.g5PuAwXXpA6G2I. Hence, the Web Address text box looks like this:
Notes: a) You can find the CUID of your Analysis Workspace by right-clicking the document/workspace in the BI Launchpad and selecting “Properties”.
b) If you’re BI platform is .NET-based, use openDocument.aspx instead of openDocument.jsp.
7. After you’ve entered the Web Address and clicked “Apply”, the “Maintain Sender / Receiver Assignment” dialog box should look similar to the following:
8. Change the Report Description to something meaning full. In the screenshot below, I’ve changed it to “RRI Receiver Test – Details Report”.
9. It’s now time to maintain the field assignment details. Hence, click the “Assignment Details” button.
10. In the assignment details, we need to maintain the field names and select the mandatory column check boxes for all InfoObjects that are needed by the target query. In this example, the target query YEN_DEL_Q002 needs both the Fiscal Year and Value Type. Hence, I’ve ticked the checked boxes for those fields. The syntax of the field name should be lsS<technical name of BEx variable>. The screenshot below shows how it should be configured for the example. Note that MPE_HFMVTYPE_001 is the technical name of the input-ready variable in query YEN_DEL_Q002 for Value Type and MPU_0FISCYEAR_01 is the name of the input-ready variable for Fiscal Year.
Note: If you need to pass multiple single parameters, use lsM instead of lsS in the fieldname.
11. Once you’ve finished configuring the assignment details, save your RRI configuration.
You’re now all set. The description that you’ve put in step #9 above should now appear as in the “Jump To” context menu of your Design Studio Application. The screenshot below shows how the RRI appears in the example application:
Note that because we’ve used a relative URL in step #6. The RRI will only work when you’ve launched the Design Studio application in the BI platform.
A very thorough and detailed write-up, especially with the supporting BEx Query examples. Readers may also find the following blog relevant: Design Studio 1.4 RRI and Open Document.
Thank you for your document, very informative. I followed your instruction and set fields assignments in RSBBS exactly as you described (“IsS” followed by technical name of variable).
But for some reason value is not passed from Design Studio to Analysis for OLAP.
To simplify whole scenario for testing purposes I created query having just one key figure and one characteristic with variable (definition of variable as shown below).
In BIP I created OLAP conection to mentioned query and on top of that I created AfO report.
Having RRI configured to launch the Report Type “BW Query” works correctly, but for Web Address type it just opens document in AfO but no parameters are passed.
Any hints where I should look for any mistake?