Focal Point
[CLOSED] Resource Analyzer - Field from SMSESS Segment

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

October 04, 2019, 03:13 PM
JulieA
[CLOSED] Resource Analyzer - Field from SMSESS Segment
FocalPoint Community,

I have a case started, but I thought I'd see if any of my FocalPoint colleagues have any ideas about this particular challenge.

We have a Resource Analyzer report that worked well in 81. We're now on 8.2.04, and it seems as if one column is not producing the expected results.

The column can be found in the SMSESS Segment. The field name is SMCONNADDR.

Here is the snippet of code
 USERNAME/A577 = IF (SMCONNADDR CONTAINS '**.**') OR SMCONNADDR  EQ ' ' OR SMCONNADDR IS MISSING THEN 'INTERNAL' ELSE 'EXTERNAL';


The **.** refers to the beginning of an IP address.

When we brought the report to 82, this column no longer worked properly. All we get is internal users. We know we have external users due to another analytics source we utilize to complement our Resource Analyzer report.

Is there a setting somewhere we need to set/turn on in order to have external users write to the report?

I'd post the entire code here; however, when I printed it in Notepad, the code was more than seven pages and I'd have to do a lot of sanitizing prior to posting it. The snippet I provided above is used in two sections to draw data from RMLDATA and RMLDB. That's all we do other than display the results of the field as Internal/External and then display the actual SMCONNADDR field.

I saw the field length changed in Resource Analyzer, so I tested changing my length to the field length listed in the manual. It still did not produce anything in terms of an external user.

Does anyone have an idea? As stated earlier, I filed a case. I thought I'd throw my question out there, just in case someone knows something I don't know.

This message has been edited. Last edited by: FP Mod Chuck,


WebFocus 8.2.04
WebFocus 8.2.04

October 06, 2019, 02:35 PM
Doug
Have you tried to use the FQP (Fully Qualified Path: TABLE/Segment names) as a field name may now, in 8204, be used in multiple segments?
October 07, 2019, 10:52 AM
JulieA
No, I have not tried that yet.

We're wondering if it has to do more with the security model we're using for our external users. It's too complicated to explain here. I will try your suggestion and follow up on my case.

Thank you.


WebFocus 8.2.04
WebFocus 8.2.04