Open document lingo (hyperlink) through the whole BI platform & SAP Design Studio & SAP Lumira & SAP Analytics Cloud

This document shows how to jump from the most aggregated level (dashboards) to the most detailed level (ECC),  including, interactive  and advanced analysis jumps.  The document attached includes screenshots as well.

0.      Linking wizard

1.      PassingValues between Dashboards

1.A   Calling a dashboard and filter the bex-variable via the link

2.      Passing values between Dashboard (Parent) to WebI (Child)

3.      Passing values between WebI – reports

3.A    Embed image into WebI – reports (via url)

3.B    Passing values between WebI – reports with Bex-variable

4.      Passing values between WebI and Olap-Analysis

5.      Input parameters

6.      Embedded dashboard

7.      Jump to ecc

8.      Design Studio

8.A    Passing Range from Design Studio to Explorer

8.B    Passing Data from Design Studio to WebI

8.C    Design Studio RRI & Open Document

9.      Hyperlink of a variable

10.     Lumira

11.     SAP Analytics Cloud to WebI

How to obtain the Open Document wizard.

Set your preferences in the BI Launchpad to HTML.

Example, check out the setting in underneath screenshot.

When you open your document as viewer (read mode), then click on design mode, you will be able to use the link-wizard.

When you open your document directly via Modify (you will go via Applet) and you will not be able to use the link-wizard.

Step 1: Create Child Dashboard (Flash 2)

• Create combobox (dynamically – linked with cell “B1”, here we will enter the passed value) and chart
• Create connection (Flash Variable)
• Link the range to your spreadsheat (important:the name of ranges, ie: “Range”)
• Save to the platform

Step 2: Create Parent Dashboard (Flash 1)

• Create combobox and graph (combobox we will use the select our passing value, the value will be placed in “Blad1!AA2)
• Paste the “Document link” of your child dashboard in a cel (this you can retrieve from the platform)
• Paste the Ranges name of your connection of your child dashboard in a cel
• Use the formula to create the URL =<link>&”&sKind=Flash&IsS”&<range_name>&”=”&<variable_value>
• Use URL-component and link it with the url link (blue)

Step 3: Check it out

• Open parent dashboard
• Click on URL (now we want to pass the value “Massilly” trough to our child dashboard
• Open child dashboard (our chart is filtered by the value we pushed trough)

See document Dashboard filtered by BEx-variable, filled via URL

Step 1: Create Webi-report

• Create filter: “Production entity”, as an optional prompt, only one value to enter.
• Save to Platform and fetch the document li

Step 2: Create Dashboard

• Paste document link in spreadsheethttp://DUN-TST-BOXI04.armony.net:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=ARew.LkSbaFDpWaepr48XRY
• To force prompt pop up screen: =<link>&”&sRefresh=Y”
• To fill prompt of “production entity” (filter created on WebI level):

     =<link>&”&sRefresh=Y&IsM”&<promptdescription>&”=”&<variable_value>

• You can replace <variable_value> by no_value if you want to leave the selection open (optional prompt)

     =<link>&”&sRefresh=Y&IsM”&<promptdescription>&”=no_value-

Step 1: Create Webi-report

• Create filter: “Production entity”, as an optional prompt, only one value to enter.
• Save to Platform and fetch the document link

Step 2: Create Webi-report

• Create table with production entity in it
• Select column

See Document: Hyperlink on image within webi report

To get this working you should check first how your bex-variable is defined.  Because when you have your Bex-variable as “selection option” your values will not be passed.

The passing of the value is nothin special.

Note that you have the assign the key as well!

good doc on this toppic :

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2013/03/11/how-to-use-opendocument-with-bex-variables

(Victor Gabriel Saiz Castillo)

Variables in OLAP Anlaysis are BEx variables, to “call” them you have to use the technical name of the variable! In example we use: QUXOIQRT

Important NOTE: the same method (link) can be used also for passing values from Dashboard to advanced analysis, just note that the input variable will look like in chapter 2.

• Add hyperlink >> Browse for advanced analysis report >> insert it >> no popup of the variables appear like in chapter 3 >> so we have to change the link via formula >> so click “ok” and go to the formula bar, edit it. And add the extra parameter below, like you see in the link below.
• &lsMQUXOIQRT=
• =”+[L01 Invoicequarter]+”

=”<ahref=\”../../opendoc/openDocument.jsp?iDocID=AXj.NgMoYXhImmeGywITRjI&sIDType=CUID&sType=amw&lsMQUXOIQRT=”+[L01 Invoice
quarter]+” \” title=\”\” target=\”_blank\”
nav=\”doc\”>”+[L01 Invoice quarter]+”</a>

View of the formula bar.  The hyperlink you see above, is the result of your link.  You see, we are passing the second quarter through.

URL setup

• documentDownload?iDocID=<iDocID value>&sKind=Flash

Dashboard setup

• component swf-loader (source url / app domain New)
• Note that the Panel component doesn’t download dashboard

See document >> BI 4.1 – How to Import a dashboard in another dashboard

url http:///<server>:<port>/sap/bc/gui/sap/its/webgui?~transaction=*CJ03%20*PROJ-PSPID=300002903;DYNP_OKCODE=/00
SERVER ED1               ecc-dev.belgrid.net

Port (T-CODE : SICF)    8000

http://ecc-dev.belgrid.net:8000/sap/bc/gui/sap/its/webgui?~transaction=*CJ03%20*PROJ-PSPID=300002903;DYNP_OKCODE=/00
>>> test
It is important that the integrated ITS service default_host->sap->bc->gui->sap->its->WEBGUI within your ECC’s NetWeaver instance is active before you can call a WebGUI transaction. The server is your ECC one that you can find in the SAP Logon. You can also find the right port in transaction SICF. The transaction itself must also be enabled for WebGUI access in SE93. The above example URL is calling transaction code CJ03 and filling the screen field PROJ-PSPID with the WBS number 300002903 and bypassing the selection screen by clicking on the Execute button. This is a static example but in real life, the number should be replaced by the column name in the Web Intelligence report.
Transaction ?

In ECC execute the requested T-Code:  for example ME23N

Passing values

Go to the parameter you want to fill in and press F1

Gui data >> Status >> MECHOB PROJ-PSPID=300002903;DYNP_OKCODE=MECHOB

http://ecc-dev.belgrid.net/:8000/sap/bc/gui/sap/its/webgui?~transaction=*ME23N%20*MEPO_SELECT-EBELN=48013468;DYNP_OKCODE=MECHOB

If the Design studio application is located on the BI Launchpad.  You can access the design studio via the opendocument lingo…check out tutorial:

SCN:

Design Studio 1.1: Pass URL parameters between applications (sap official)

/https://blogs.sap.com/2015/02/25/passing-parameters-as-part-of-url-in-sap-bo-design-studio-15/

A range in Design studio has format: 2011 – 2013

A range in Explorer has format: 2011;2012;2012;2013

When we push our values as answer from Design Studio prompt, we will recieve those 2011-2013 format

Check out the code to go from one format to the other

Nothing special here, use what you already learned above.

script in design studio= APPLICATION.openNewWindow();

add opendocument-rul from webi, add parameters, it as simple as that.

Note, do not forget to create the prompt in your webi and use that name in your parameter!

    1. Actions in design studio

• APPLICATION.openNewWindow(“http://ISOSAP115.belgrid.net:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AfZDGoYxjP5FuG1B4o86lu4&lsSYear=var_end“);

• var url =“http://ISOSAP115.belgrid.net:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AfZDGoYxjP5FuG1B4o86lu4&&sRefresh=Y&lsSCompany=”+var_end;

    APPLICATION.openNewWindow(url);
var_end can be a variable you filled in via startup or you can set it as the result of a filter

example:

var_end=DS_1.getVariableValueExt(“VAR_YEAR”);

     2. Actions in webi

Creation of prompt

Nice doc on this toppic by Deepu Sasidharan

Design Studio 1.4 RRI and Open Document

create variable “signature”.

add for example =www.google.com

this can be handy if it is based on an IF statement, where you in once case jump to report A and in the other case to report B.

use formula below in your report

=”<a href=\””+([Signature])+”\” title=\”\” target=\”_blank\” nav=\”web\”>Click Here</a>”

OpenDocument Functionality for Lumira Documents in SAP Lumira, server for BI Platform

Enhancement of Lumira document to support Full, Part and Prompts/Variables options via OpenDocument URL for SAP Lumira, server for BI Platform

1. Step 1 create WebI report as target/child report.
   • create prompt (name/textbox of my prompt I type: Year)
   • save your WebI report into your Launchpad
   • go to properties of your WebI document and copy the opendocument URL
2. Step 2 create SAC story as source/parent report.
   • create story
   • in Story add chart, link it with your datasource, design it.
   • When ready go to your chart structure-> add chart components -> hyperlink
   • OR go to your graph in the story itself, open the menu and go to hyperlink
3. Step 3 develop your Hyperlink
   • Link to= external URL
   • External URL = paste your opendocumentlink here and add &sRefresh=Y&lsSYear=<<add your Dimension from your datasource>>
   • Label= “Jump to”
   • Open in new tab

Ready to play >> in chart, select your value/dimension, HyperlinkJumpTo jumps up , click on it and your WebI Report will open with your selected value