I'm in the process of upgrading to 7.7.03 Anyone having any problems with FML code? I have opened a case with IBI.
This is reading BW data - I have a fex that does not seem to process the FML code and returns 0 records.
When you run this – You get records TABLE FILE BWP_V_HIER_IS001 SUM ACT BUD ACT_YTD BUD_YTD BY CHILD_ID END Change it to this…which is the way the report runs and you get 0 records
TABLE FILE BWP_V_HIER_IS001
SUM
ACT
BUD
ACT_YTD
BUD_YTD
FOR CHILD_ID
'VLO SALAWAGS' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO SALAWAGS' ADD ALL AS 'Salaries and Wages' LABEL R2 OVER 'VLO OVTIME' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO OVTIME' ADD ALL AS 'Overtime' LABEL R4 OVER 'VLO EMPLPAYBEN' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO EMPLPAYBEN' ADD ALL AS 'Employee Payroll Benefits' LABEL R6 OVER 'VLO INCENCOMP' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO INCENCOMP' ADD ALL AS 'Incentive Compensation' LABEL R8 OVER 'VLO LOANEMPL' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO LOANEMPL' ADD ALL AS 'Loaned Employees' LABEL R10 OVER 'VLO SEVPAY' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO SEVPAY' ADD ALL AS 'Severance Pay' LABEL R12 OVER 'VLO OTHBENE' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO OTHBENE' ADD ALL AS 'Other Benefits' LABEL R14 OVER 'VLO CAPOHEAD' GET CHILDREN ALL AS CAPTION LABEL R1 NOPRINT OVER 'VLO CAPOHEAD' ADD ALL AS 'Capitalized Overhead' LABEL R16
END
-EXIT
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
This message has been edited. Last edited by: Prarie,
September 28, 2011, 12:03 PM
Prarie
Not sure why that posts all on one line...
September 28, 2011, 12:30 PM
njsden
Assuming that BWP_V_HIER_IS001 is a synonym to a database table/view and not a FOCUS file, would enabling traces to capture the underlying SQL statement shed some light into what it's doing?
FOC2506 - INTERFACE-MANAGED NATIVE JOIN SELECTED FOR THE FOLLOWING REASON:
FOC2517 - FST. OR LST. WHERE SORT FIELDS DO NOT COVER KEY
FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
FOC2592 - RDBMS-MANAGED JOIN HAS BEEN DISABLED
SELECT
T1."CHILD_ID",
T1."CHILD_ALIAS",
T1."PARENT_ID"
FROM
WEBFOCUS.V_HIER_IS001 T1;
FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
FOC2599 - NON-SQL SEGMENT IN HIERARCHY (OTHER INTERFACE PRESENT)
SELECT
T1."CHILD_ID"
FROM
WEBFOCUS.V_HIER_IS001 T1
WHERE
(T1."CHILD_ID" IN('VLO 0000416950', 'VLO ADVOLTAX', 'VLO ADVT',
'VLO AMORTEXP', 'VLO AMORTOPEX', 'VLO BADDEBTLOS', 'VLO
CANCELPROJ', 'VLO CAPOHEAD', 'VLO CASHEXP', 'VLO CATTOT', 'VLO
CHARITCONT', 'VLO CHEMICLE', 'VLO CHEM_CAT', 'VLO CHGODRS',
'VLO COMS', 'VLO COMSYSEXP', 'VLO CRTCRDFEES', 'VLO DEPEXP',
'VLO DEPGL_AST', 'VLO DEPOPEX', 'VLO DUESSUBS', 'VLO ELECSAL',
'VLO ELECT', 'VLO EMPLACT', 'VLO EMPLPAYBEN', 'VLO EMPLPROC',
'VLO ENGYPUR', 'VLO ENGYSALE', 'VLO ENGYTOT', 'VLO EPMPLREL',
'VLO FINESTAX', 'VLO FUEL3PYT', 'VLO FUELSAL', 'VLO FXDBDCAT',
'VLO INCENCOMP', 'VLO INJECTCAT', 'VLO INSURANCE', 'VLO
LOANEMPL', 'VLO MAINTNCE', 'VLO MTNCE', 'VLO MTNCEAFE', 'VLO
NITROGEN', 'VLO NONCASHEXP', 'VLO OPERSUPP', 'VLO OPEX001',
'VLO OTHBENE', 'VLO OTHEMPLREL', 'VLO OTHEREXP', 'VLO
OTHFXDEXP', 'VLO OTHOUTSVCS', 'VLO OTHTAXES', 'VLO OUTSERV',
'VLO OVTIME', 'VLO OXYGEN', 'VLO PERMLIC', 'VLO PMETALCAT',
'VLO PROFFEES', 'VLO REGULTAX', 'VLO RENTLEASES', 'VLO ROYAL',
'VLO SALAWAGS', 'VLO SALWAGBENE', 'VLO SEVPAY', 'VLO STEAM',
'VLO STEAMSAL', 'VLO SUPPOP', 'VLO TOTFXDEXP', 'VLO TOTVAREXP',
'VLO TRAVEL', 'VLO UTIL', 'VLO VEHICLE', 'VLO WASTEDISP', 'VLO
WATER'))
ORDER BY
T1."CHILD_ID";
September 28, 2011, 06:51 PM
njsden
Oh well, that's not too bad except for the fact that WebFOCUS is doing all of the heavy lifting instead of reying on the database for some of the stuff, but I'm not sure FML requests can easily be translated to SQL.
Anyway, can you run the SQL query directly against your database to see what results you get?