Login authorisation in BW via the Bex Analyzer

Question: Hi,

When we logon to our BW system using the sapgui a password expiration check is (correctly) performed. However when we logon using the SAP Bex Analyzer there is NO check on the password expiration.
Is the FM SUSR_LOGIN_CHECK_RFC to be used to check the expiration date or is this the wrong way to proceed ?

olle

PS : this message was already posted last week in the BASIS group

Answer:
Are you using a Web front end to access the Bex??

Answer:
Are you using a Web front end to access the Bex??
Yes.

Answer:
This was done by a Consultant for us to make sure that passwords were forced to be changed by users on initial logon. Also works when you force change the users password in SU01


The following changes need to be made to setup the web based logon screen to allow users to change their passwords via BEx.

1. Navigate to and right click and activate the service

SICF --> default_host --> sap --> public --> bsp --> sap --> system
SICF --> default_host --> sap --> bc --> bsp --> sap

2. Edit the BEx service by double clicking on

SICF --> default_host --> sap --> bw --> BEx

3. In the "Error Pages" tab enter change mode (pencil icon) and change the radio button to "Redirect to URL". Specify the URL below

/sap/public/bsp/sap/system/login.htm?sap-url=<%=PATHTRANS%>&bspchangepasswordvisible=X&bsplanguagevisibe=X&bspclient=315&bspdontshowhttpswarning=X

Note: That must be all on one line and no spaces.

4. Re-activate the BEx service by right clicking and activating

SICF --> default_host --> sap --> bw --> BEx

Most errors you get can be resolved by simply activating any of the above services that have become deactivated.

Once thats done you can test it with your URL..

You'll get a username and password prompt. If you type in your name and password correctly then you get logged in. If your password has expired (60 days old for example) then you'll get told so, and will be prompted for a new password. Also you can choose to change your password if you want to. Note that the same rules apply for changing passwords here as apply in SAPGUI, such as minimum length, combinations of characters etc.


I hope this is what you require

Jacko

Answer:
Are you using a Web front end to access the Bex??
I'm sure that question was originally "Is anyone using a Web font end to access the Bex"??

Not sure if Olle is accessing Bex via web but thanks for sharing your solution.

Answer:
Sorry for the late reply guys,

Unfortunately we don't use the web logon but logon using :
C:\Program Files\SAP\FrontEnd\Bw\sapbex.xla

many thanks however to AL and Jacko


kind regards

Answer:
Olle,

I think the only way you will get any validation on date is to use the FM you suggested to verify password expiration date. I'm not sure exactly how you will implement this though.

Cheers,

Al.

Answer:
Is there a way to allow users to change their own passwords using web frontend (apart from password expiry, where the password change will be forced).

Regards,
Nishant
Copyright ?2007 - 2008 www.jt77.com