Calling a Webi Report from Dashboards without login Prompt

[Former Member]

Hi All,

I am using Bo4.1 SP1 and calling a Webi report from a Dashboard using opendoc. I am able to call the Webi report and it works fine, but I get the login prompt when I call the Webi report from Dashboard.

I looked up the web and found that we can use the serSes or token parameters to avoid the login prompt. But the examples made used of the SDK. Can someone guide me on how I can achieve this without using the SDK as our application does not have any SDK usage and I am not aware how I could use the authentication parameters in the opendoc ?

Any help is appreciated. Thanks

[vinay_mhaske]

Hi Dipti,

What URL you use to login to BI Launch Pad? Are you using exact same server name and port number in open document url? What server name and port you are using for live data connections in the Dashboard?

I have SAP BI 4.1 and Dashboard Design 4.1 environment. Did following two quick tests which may help you to narrow down the issue:

• Test 01: (Webi report does not prompt for password)

Used following link in Xcelsius Dashboard to open Webi Report. Opened Xcelsius Dashboard from BI Launch Pad, clicked on Webi open document link and found that Webi Report opens without any issue. Webi Report does not prompt for password.

http://172.31.172.35:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=AS4PGKt7sDVKlpYZy7gIn4c&sIDType=CUID

• Test 02: (Webi report does not prompt for password)

Passed CELogonToken from Dashboard to Webi Report using CELogonToken parameter:

Steps:

     1. Added Flash Variable connection to the dashboard

     2. Added Flash Variable and named it as CELogonToken

     3. Mapped above flash variable with excel cell. (Say B2)

     4. Concatenated value of cell B2 to the open document url to the Webi report.

http://172.31.172.35:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=AS4PGKt7sDVKlpYZy7gIn4c&sIDType=CUID&CELogonToken=<Append value of cell B2>

     5. Mapped above URL with URL Button Component and exported the dashboard to BOE Server.

1. 6. Opened Dashboard from BI Launchpad, clicked on URL Button Component and found that Webi Report opens without any issue and it does not prompt for password.

Hope this helps!

Cheers!

-Vinay

[Former Member]

Hi Vinay,

I rried the Test 01 and I still get the login prompt.

How did you get the CELogenToekn value and add it to a cell in excel. Can you guide me to the steps sp that i could try that and see if that works for me.

Appreciate your help.

[vinay_mhaske]

Hi Dipti,

Refer Test 02 in last post for getting value of CELogonToken in excel cell.

Regards,

Vinay Mhaske

[Former Member]

But how do I get the CELogon Token to be used in Excel ?

[former_member197846]

Hi Dipti,

Please refer to the below documents for CELogonToken.

I hope this helps.

Regards,

Abhijit