[CLOSED] Same report in Two different domain different results.
I have report that I am running in my production environment. When I copied this report in different domain with all the .FEX files that this report calls. I am getting different data outputs. Is it because internal names for the files change everytime you copy? Did anybody ever have the same problem? How to get around this problem? Code for the report that is calling other FEX is as fllows:
---------------------------------------------------------------------
-SET &ECHO = ON;
&INDT5='&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;';
&INDT7='&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;';
-INCLUDE app/00_setting.fex
-INCLUDE app/01_billing.fex
-INCLUDE app/02_enrollment.fex
-INCLUDE app/03_fte.fex
-INCLUDE app/04_net_revenue.fex
USE
BILLAGG0 AS BILLAGG0
ENRLAGG0 AS BILLAGG0
FTE_AGG0 AS BILLAGG0
TOTNETREV AS BILLAGG0
END
-RUN
-INCLUDE app/10_total.fex
-INCLUDE app/11_assemble.fex
-*------------------------------------------------
SET EMPTYREPORT=ON
USE CLEAR
USE
WKRVAGG1 AS WKRVAGG6
WKRVAGG2 AS WKRVAGG6
WKRVAGG3 AS WKRVAGG6
WKRVAGG4 AS WKRVAGG6
WKRVAGG6 AS WKRVAGG6
WKRVAGG7 AS WKRVAGG6
WKRVAGG8 AS WKRVAGG6
WKRVAGG9 AS WKRVAGG6
WKRVAGG10 AS WKRVAGG6
ENRLAGGT AS WKRVAGG6
ENRLAGGP AS WKRVAGG6
END
-RUN
-*---------------------------------------------------------------------
-SET &SORT = ' ';
-SET &DISPBURST = IF &BURST EQ 'MAX.DISTRICTID' THEN '<DISTRICTID' ELSE
- IF &BURST EQ 'MAX.DIVISIONID' THEN '<DIVISIONID' ELSE
- IF &BURST EQ 'MAX.SCHOOLID' THEN '<SCHOOLID' ELSE ' ';
-*-RUN
-*-TYPE &SORT
-*-TYPE &BURST
-*-TYPE &DISPBURST
-*-RUN
-*-EXIT
DEFINE FILE WKRVAGG6
CP_DESC/A35 = IF CP EQ 'CP' THEN ' Current Period' ELSE
IF CP EQ 'PP' THEN ' Prior Periods' ELSE
'Unknown Period';
L2/A1 = IF LITM2 EQ ' ' THEN '~' ELSE EDIT(LITM2,'9');
L3/A10 = IF LITM3 EQ ' ' THEN '~' ELSE EDIT(LITM3,'9999999999');
LITMORD/A22 =
IF LITM1 EQ 'Tuition' THEN '01' ELSE
IF LITM1 EQ 'Discounts' THEN '02' ELSE
IF LITM1 EQ 'Registration' THEN '03' ELSE
IF LITM1 EQ 'Other Revenue' THEN '04' ELSE
IF LITM1 EQ 'NET REVENUE' THEN '05' ELSE
IF LITM1 EQ 'FTE' THEN '06' ELSE
IF LITM1 EQ 'License Capacity / %UE' THEN '07' ELSE
IF LITM1 EQ 'Enrollments' THEN '08' ELSE
IF LITM1 EQ 'Net Enrollments' THEN '09' ELSE
IF LITM1 EQ 'New Enrollments' THEN '10' ELSE
IF LITM1 EQ 'Withdraws' THEN '11' ELSE
IF LITM1 EQ 'Enrollments Unsched.' THEN '12' ELSE EDIT(LITM1,'9999999999999999999999');
-* '*';
COLPREFX/A10 = IF COLENT CONTAINS 'Ch' THEN 'Chg PY' ELSE
IF COLENT CONTAINS '%' THEN ' ' ELSE
'Total';
COLLETTR/A1 = IF EDIT(COLENT,'$$$$$$9') NE ' ' THEN 'W' ELSE 'P';
COLNUMBR/A2 = IF EDIT(COLENT,'$$$$$$9') NE ' ' THEN EDIT(COLENT,'$$$$$$9') ELSE
IF EDIT(COLENT,'$$$$9') EQ '0' THEN EDIT(COLENT,'$$$$$9') ELSE
EDIT(COLENT,'$$$$99');
COLPSTFX/A2 = IF COLENT CONTAINS '%' OR 'Ch' THEN '%' ELSE ' ';
COLTITLE/A20 = ' ' || COLPREFX || (' '|COLLETTR || COLNUMBR || (' '|COLPSTFX));
AMTF/P15.2 = IF LITM1 EQ 'License Capacity / %UE' AND COLENT OMITS '%'
THEN (AMOUNT1) ELSE
IF LITM1 EQ 'License Capacity / %UE'
THEN (AMOUNT2/AMOUNT1)*100 ELSE
IF AMOUNT2 EQ 0 THEN (AMOUNT1) ELSE
IF COLENT CONTAINS '%' THEN (AMOUNT1/AMOUNT2)*100 ELSE
(AMOUNT1-AMOUNT2)/AMOUNT2*100 ;
fmt/A8 = IF COLENT CONTAINS '%' OR COLENT CONTAINS 'Ch' THEN 'D10.1%' ELSE 'D13CB';
LITM1D/A25 = IF L2 EQ '~' THEN ' Total ' | EDIT(LITM1,'99999999999999999') ELSE LITM1;
LITM2D/A25 = IF LITM2 EQ 'N/A' THEN ' ' ELSE LITM2;
LITM3D/A1 = IF LITM3 EQ 'Infant' OR 'Infant I' THEN 'A' ELSE
IF LITM3 EQ 'Toddler 1' OR 'Toddler I' THEN 'B' ELSE
IF LITM3 EQ 'Toddler 2' OR 'Toddler II' THEN 'C' ELSE
IF LITM3 EQ 'Preschool' THEN 'D' ELSE
IF LITM3 EQ 'UPK' THEN 'E' ELSE
IF LITM3 EQ 'Kindergarten' THEN 'F' ELSE
IF LITM3 EQ 'School Age' THEN 'G' ELSE
IF LITM3 EQ 'Other' THEN 'H' ELSE
IF LITM3 EQ 'NONE' THEN 'I' ELSE
IF LITM3 EQ 'Null' THEN 'J' ELSE 'K';
FLAG/I1 = IF LITM2 EQ 'N/A' AND LITM3 EQ ' ' THEN 1 ELSE 0;
BLA/A1 = ' ';
COLCONCAT/A11 = COLPREFX | COLLETTR;
END
This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.10 Windows HTML
June 22, 2010, 02:10 PM
RSquared
Arif,
Is the data the same in both domains? Are they pointing to different data, perhaps?
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
June 22, 2010, 05:02 PM
Arif
quote:
Arif,
Is the data the same in both domains?
Data is same in both domains. both domains are in the same environment. Both domains are pointing baseapp datafloder on the same server (same metadata). Is it still going out of domain to call fex eventhough a copy of fex is available in the same domain?
WebFOCUS 7.6.10 Windows HTML
June 23, 2010, 08:52 AM
PBrightwell
Have you checked the internal names in the domain where the .fexes where copied? It is possible that they change name on a copy. This will happen if they already exist in the domain, even if it is in a different folder. I have noticed in 7.6.8 that sometimes WF creates a pop-up and asks if you want to overwrite, rename or cancel and other times it just copies and renames them.
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes