Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Resource Analyzer - Field from SMSESS Segment
Go
New
Search
Notify
Tools
Reply
  
Resource Analyzer - Field from SMSESS Segment
 Login/Join
 
Platinum Member
posted
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.


WebFocus 8.2.04
WebFocus 8.2.04

 
Posts: 130 | Registered: September 18, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
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?
 
Posts: 3020 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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

 
Posts: 130 | Registered: September 18, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Resource Analyzer - Field from SMSESS Segment

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.