Getting Web I report from Dashboard Designer

[Former Member]

Requirement : Opening of Web I Report from Dashboard.

Steps to achieve

1)

  Copy the Document Link .

It will look like as below format http://<server>:<port>//BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=<documentID>

2)Open Dashboard dsigner and drag a URL button 1 to the CanVas and filll the URL Property with the copied document link to the URL Button and give Window Option of  Open In Property to "New Window".

3) Export to the BI 4.0 Portal and open it from the BI Launchpad. Once you Click the URL Button in the dashboard it will Opendoc BI Launchpad which will have User ID and Password options.It will allow only Enterprise Authentications only.Then u can see Web I report.

Problems: i)How to overcome again giving the User Id and Password option ii)How to passSAP authentication automatically.

4)Flash Variables will help to achieve this and change the Syntax as below.

http://<server>:<port>//BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=<documentID>&t...

5)Go to Document Manager and Add Flash Variables.Then Add a series in the Flash variable as For Eg:CEToken and Map Range to Spread Cell Eg :B1.

Add the Copied  Document Link in another Cell For Eg : D1 Then Combine  these 2 cells with below function as per above format.Add C1 with &CEToken=

Finally A1 as =D1&C1&B1.(Format http://<server><port>http://<server>:<port>//BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=<documentID>&t...)

6)This time link the URL Property of URL button to A1.Then export the Dashboard to BI 4.0 Portal and open it in BI launchpad.This time it ll not ask any credentials.It will open the Report automatically once u click the button with out asking the credentials.

References

Flash variables,Web Intelligence 4.0 SP4 ,Dashbaord Designer 4.0 SP4.