在BW Query Designer 中浏览结果需要输入EP的用户名和密码的。希望SAP会在以后的版本中解决这个SSO机制的问题。
Re-logon required when launching BEx Web App from BEx Tools
You are using BEx Tools (BEx Query Designer, BEx Web Application Designer, BEx Analyzer or BEx Report Designer). Executing a BEx Web Application from one of the tools, you are prompted again to enter user and password information, although you have already logged on to BEx Tools.
The statements made in this note do not only apply to executing BEx Web Applications, but also to executing BEx Broadcaster which is internally using the same technology.
BEx Tools are using an RFC connection to the ABAP backend, while BEx Web Applications are using an HTTP connection to either the J2EE (BEx Web Applications 7.0) or ABAP (BEx Web Applications 3.x) backend.
To identify an already logged on user, the Web servers are using cookies that are saved and returned by the Web browser. Furthermore, a Web browser by design only sends cookies to the server that has set a specific cookie. This is done out of security considerations.
This is why a direct transfer of logon information between BEx Tools and BEx Web Applications is not possible.
To realize the scenario that a user doesn't need to re-logon with the Web browser, you need to purchase a third party SSO software that uses for example the Windows authentication. The configuration of SSO on the J2EE and/or ABAP server is not sufficient.
As a workaround you can leave the Web browser instance open after logging on once. By doing so, you won't be prompted for re-logon when you launch a BEx Web Application from BEx Tools for the second time.