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.
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?
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.
|Powered by Social Strata|