Cognos reportnet and Web application login simultaneously

Describe the whole process:

1. Establish a homogeneous table with the Cognos Accessmanager Authentication service in the database so that the data in its table is the same as the authentication information in Accessmanager.

CREATE TABLE "MANAGER". " Userslist "
("user_id" VARCHAR2 not NULL ENABLE,
"USERNAME" VARCHAR2 (255) not NULL ENABLE,
"User_pass" VARCHAR2 (30),
"User_class" VARCHAR2 (16)
) ；

CREATE TABLE "MANAGER". " Users_class "
("Classno" VARCHAR2 not NULL ENABLE,
"CLASSNAME" VARCHAR2 (250),
"ORG_ID" VARCHAR2 (16),
"Id_desc" VARCHAR2 (250)
)；

2. Using the "administrator" user of Cognos ReportNet, make a blank report on the Cognos portal, where only the HTML control is added to write:

<script language= "JavaScript" >
function init ()
{
Location.href= "http://192.168.20.242:8081/xjfw1/frame/kpiReportFrame.jsp";
}
</script>

When you are finished, save it in HTML format.

Description: The URL refers to the page that automatically jumps after logging into the Cognos system. Briefly explain why you should do this:

If the Web Application System landing page is: http://192.168.0.11/abc/login.jsp, we can get two parameters from the page, username and password, then we pass the Check isomorphism table, if the information matching can be logged into the next step with Cognos interactive operation, Otherwise, the error page is returned.

The operation with Cognos means:

We have just created a report that takes out the address of the report: for example, http://192.168.0.8/crn/reporturl/

We set up a string in the JSP page, string url=http://192.168.0.8/crn/reporturl/&camusername= "+username+" "&campassword=" + Password+ "

The role is to directly upload the information from the login.jsp page to the landing Cognos, directly open the report, let it automatically return to a Web application page, so that Web applications and Cognos are both landing at the same time, in the Web application can directly invoke Cognos report, to solve the problem of Cognos landing.