cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Opendocument single logon.

Go to solution
Former Member

on ‎07-16-2013 3:33 PM

0 Kudos

Good day everyone!!!

I need your help to solve a problem we have, the situation es the following:

We have a dashboard that needs to be  consulted by many persons in BI Launchpad, however that dashboard must be consulted by persons without access to BO so we need to find a way to grant access without enter the BI Launchpad trough Opendocument.

I read something about a script to be configured in the BO server but it didnt work, maybe we need a more recent script or something like that.

We are using SAP BO 4.0 SP 04 on a Windows 2008 Server R2

Any help will be apreciated

Thanks

Have a nice day

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

former_member194862
Active Contributor
‎07-19-2013 6:15 PM
0 Kudos

Hi Elio,

Steps to achieve the desired functionality are as below.

1)create a dashboard any any web service say qaaws or live office or query browser or any xyz connection which connects to BO.In the data manager in dashboard add a flash variable connection that is for CELogon token.

2)Export the dashboard to swf say MyFlash.swf

3)Export the dashboard to html and view it in notepad I mean view the source file copy the content of the source file.

It will look like below.

<HTML>

<HEAD>

<TITLE>Dashboard.swf</TITLE>

</HEAD>

<BODY>

<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"

codebase="http://fpdownload.adobe.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0"

WIDTH="800" HEIGHT="600" id="myMovieName">

<PARAM NAME=FlashVars VALUE="CELogonToken=">

<PARAM NAME="movie" VALUE="Dashboard.swf">

<PARAM NAME="quality" VALUE="high">

<PARAM NAME="bgcolor" VALUE="#FFFFFF">

<PARAM NAME="play" VALUE="true">

<PARAM NAME="loop" VALUE="true">

<PARAM NAME=bgcolor VALUE="#FFFFFF">

<EMBED src="Dashboard.swf" quality=high bgcolor=#FFFFFF WIDTH="800" HEIGHT="600"

NAME="myMovieName" ALIGN="" TYPE="application/x-shockwave-flash"

play="true" loop="true"

FlashVars="CELogonToken="

PLUGINSPAGE="http://www.adobe.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash">

</EMBED>

</OBJECT>

</BODY>

</HTML>

------------------------------------------------------------------------------------------------------------------------------------

4)Just check this MyDashboard.jsp which I have created file carefully.You will notice that the dashboard(html) is embedded in the jsp.

<%@ page import="com.crystaldecisions.sdk.exception.SDKException" %>
<%@ page import="com.crystaldecisions.sdk.framework.CrystalEnterprise" %>
<%@ page import="com.crystaldecisions.sdk.framework.IEnterpriseSession" %>
<%@ page import="com.crystaldecisions.sdk.framework.ISessionMgr" %>
<%@ page import="com.crystaldecisions.sdk.occa.infostore.IInfoStore" %>
<%@ page import="com.crystaldecisions.sdk.occa.security.ILogonTokenMgr"%>


<%! String defaultToken =null; %>
<%

try
{
  String systemName = "amitkXI";
   String userName = "administrator";
   String password = "Secure09";
   String authType = "secEnterprise";

  IEnterpriseSession enterpriseSession=null;
          ISessionMgr enterpriseSessionMgr = CrystalEnterprise.getSessionMgr();
          enterpriseSession = enterpriseSessionMgr.logon(userName, password, systemName, authType);
  ILogonTokenMgr logonTokenMgr = enterpriseSession.getLogonTokenMgr();
 
 
  defaultToken = logonTokenMgr.getDefaultToken();
  
}
catch(Exception e)
{
  out.println(e);
}

%>
<HTML>
<HEAD>
<TITLE>Dashboard.swf</TITLE>
</HEAD>
<BODY>
<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://fpdownload.adobe.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0"
WIDTH="800" HEIGHT="600" id="myMovieName">
<PARAM NAME=FlashVars VALUE="CELogonToken=<%=defaultToken%>">
<PARAM NAME="movie" VALUE="Dashboard.swf">
<PARAM NAME="quality" VALUE="high">
<PARAM NAME="bgcolor" VALUE="#FFFFFF">
<PARAM NAME="play" VALUE="true">
<PARAM NAME="loop" VALUE="true">
<PARAM NAME=bgcolor VALUE="#FFFFFF">
<EMBED src="Dashboard.swf" quality=high bgcolor=#FFFFFF WIDTH="800" HEIGHT="600"
NAME="myMovieName" ALIGN="" TYPE="application/x-shockwave-flash"
play="true" loop="true"
FlashVars="CELogonToken="
PLUGINSPAGE="http://www.adobe.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash">
</EMBED>
</OBJECT>
</BODY>
</HTML>

------------------------------------------------------------------------------------------------------------------------------------

5)All you need to do is just paste your html source into this file in this case the bold area is the html code for the dashboard once we view its source.I mean delete the code above in bold and then paste your html.Make sure in your html code inside the jsp you have "CELogonToken"=<=defaultToken%>">

that is you must have this line as well <PARAM NAME=FlashVars VALUE="CELogonToken=<%=defaultToken%>">

6)Now we need to put the system name,user name and password by harcoding it into the jsp code.

7)Now save this file as MyDashboard.jsp

8)Now we need to deploy this MyDashboard.jsp file and the flsh file i.e MyFlash.swf inside tomcat.

9)Either you can create a directory structure for web application or just paste these two files inside AdminTools that is inside webapps folder

10)Now to view the dashboard access it using this url http://server:port/AdminTools/MyDashboard.jsp

Or if you do not want to save these two files inside the Admin tools folder then you can create a directory structure inside your tomcat

Let me know whether it works

Regards,

Amit

Show replies
Show replies
Former Member
‎07-19-2013 7:20 PM
0 Kudos

Seriously??? 

You want me to hard-code the admin user ID and password into the JSP code?

Does this mean BI uses the admin ID to execute the report?  What happens to the user-role based security checks when the report calls a BEX query?  Is the admin user passed to BW?

I can’t say I like this solution.  I need a solution that passes the actual user ID to BI.

former_member194862
Active Contributor
‎07-21-2013 10:42 PM
0 Kudos

you do not necessariliy have to use administrator credentials,but should be a BO user who has access to the dashboard and its connections

Answers (3)

Answers (3)

Former Member
‎07-18-2013 10:50 AM
0 Kudos

Hi Elio

For Bypassing the user authentication you need to pass on CELOGON Token. Please go through the following links.

http://davidlai101.com/blog/2010/11/18/xcelisius-dashboards-outside-of-infoview-with-the-help-of-cel...

http://infosolblog.com/tag/celogontoken/

http://ryangoodman.net/blog/index.php/2008/01/21/xcelsius-single-sign-on-with-celogontoken/

Thanks

Sarma P

Show replies
Show replies
Former Member
‎07-18-2013 1:43 AM
0 Kudos

Elio,

       You cannot have a user access the dashboard directly without him having access in the BO system. If the user has the authorization within BO system, they can access the dashboards from the document link that you can find in the BI Launchpad. Just right click on the dashboard and you'll be able to get the document link that you can provide to your user.

Show replies
Show replies
Former Member
‎07-17-2013 12:17 PM
0 Kudos

Hi Elio

Please see

http://davidlai101.com/blog/2010/11/18/xcelisius-dashboards-outside-of-infoview-with-the-help-of-cel...

Thanks

Sandeep

Show replies
Show replies
Ask a Question