Focal Point
Authentication: Passing credentials

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6427067595

December 22, 2010, 11:28 AM
Microfich
Authentication: Passing credentials
Scenario: Self Service app
Graph drills down to EXL2K report 1.
EXL2K report 1, column 1, drills to EXL2K report 2

Issue: EXL2K report 1 is now out-of-session, so it gets prompted for id/pw to execute drill to report 2.
I don't want users to have to re-authenticate.

Incomplete solution 1: Modify cgivars.wfs to pass IBIC_user and IBIC_pass, making them available as variables to the
drill.
Problem: PW shows in tool tip text when hovering over link. Need to encrypt the pw or remove tool tip text.
Note, we're 7.6.2 so the 'ALT' parameter for tool tip text is unavailable.

Other solutions: Tried 'CopySessionVarToWFVar' with no luck.
Tried 'CopyHTTPCookieToWFVar', which passes the string encrypted, so I cannot parse out the PW portion.
Is this variable still useable somehow?

Any insight would be appreciated.


WebFOCUS 8105
Windows;
DB2, UDB, SQL Server, Oracle
FOCUS-WebFOCUS since 1981
December 23, 2010, 08:36 AM
<JG>
Only real option in 76 to hide the mouseover is to use a template macro to set the screentip

very simple for a single worksheet

Sub Workbook_Open()
For Each r In ActiveSheet.UsedRange
If r.Hyperlinks.Count > 0 Then
r.Hyperlinks(1).ScreenTip = "Whaterver text you want to see"
End If
Next
End Sub

If you have multiple sheets then you need an outer loop to go through all the sheets
December 24, 2010, 08:33 AM
Microfich
Yes, templates w/work fine and thanks for the idea but I am trying to avoid templates for this application.


WebFOCUS 8105
Windows;
DB2, UDB, SQL Server, Oracle
FOCUS-WebFOCUS since 1981