Hello,
I'm creating a very simple report against a summary table using InfoAssist, but I need that the report asks for the three parameters used by the report: department, year, and week. These fields don't exist in the summary table. For this reason, I joined the dimension tables: Product (for the department) and Fiscal Calendar (for the year and week) in the master file of the summary table. I ran the report, and it took more than one minute to show the parameters form with the valid values for each parameter: Department (26 values), Year (13 values), and Week (53 values). Why does it take long time to show the parameters form? It would have sense if the report was building the valid values of each parameter using the summary table, but I realized that the department list of the parameter form is showing values of departments without any data in the summary table. Therefore, the parameter list is being built using the dimension tables. The users consider unacceptable that the parameter form takes more than one minute to appear when they could get the data from the source in seconds. May you help me with it?

This is the code of the InfoAssist report:

TABLE FILE SUMCLASS
SUM SUMCLASS.SUMCLASS.SALES
BY SUMCLASS.SUMCLASS.CLASS
ACROSS SUMCLASS.CALENDAR.FYEAR
ACROSS SUMCLASS.CALENDAR.FWEEK
WHERE SUMCLASS.CLASSES.DEPT EQ '&DEPT.(FIND SUMCLASS.CLASSES.DEPT IN SUMCLASS).Dept:.';
WHERE SUMCLASS.CALENDAR.FYEAR EQ '&FYEAR.(FIND SUMCLASS.CALENDAR.FYEAR IN SUMCLASS).Fyear:.';
WHERE SUMCLASS.CALENDAR.FWEEK EQ '&FWEEK.(FIND SUMCLASS.CALENDAR.FWEEK IN SUMCLASS).Fweek:.';
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
ENDSTYLE
END

And this is the master file defined for the sumamry table:

FILENAME=SUMCLASS, SUFFIX=SQLODBC ,
REMARKS='Sales Summary by Class', $
SEGMENT=SUMCLASS, SEGTYPE=S0, $
FIELDNAME=CLASS, ALIAS=class, USAGE=I4, ACTUAL=I4,
MISSING=ON,
TITLE='Class Num', DESCRIPTION='Class Num - The product class.', $
FIELDNAME=STORE, ALIAS=store, USAGE=I5, ACTUAL=I5,
MISSING=ON,
TITLE='Store Num', DESCRIPTION='Store Num - The DG store number.', $
FIELDNAME=DATE, ALIAS=date, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Trans Date', DESCRIPTION='Trans Date - The date of the sales transaction.', $
...
FIELDNAME=UNITS, ALIAS=units, USAGE=I11, ACTUAL=I4,
MISSING=ON,
TITLE='Sales Units', DESCRIPTION='Sales Units - The units sold. Return units have been subtracted.', $
FIELDNAME=SALES, ALIAS=sales, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Net Sales', DESCRIPTION='Net Sales - Total sales (units * price). Non-Merch sales at Net. Return retail subtracted.', $
FIELDNAME=COST, ALIAS=cost, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Cost', DESCRIPTION='Cost - The total cost for the line (unit cost * Sales Units)', $
...
SEGMENT=CLASSES, SEGTYPE=KU, CRFILE=CLASSES, CRKEY=CLASS, PARENT=SUMCLASS, CRJOINTYPE=INNER, $
FIELDNAME=CLASS, FIELDTYPE=I, ALIAS=class, USAGE=I4, ACTUAL=I4,
MISSING=ON,
TITLE='Class Num', DESCRIPTION='Class Num - The product class.', $
...
FIELDNAME=DEPT, ALIAS=dept, USAGE=I4, ACTUAL=I4,
MISSING=ON,
TITLE='Dept Num', DESCRIPTION='Dept Num - The product department number.',$
...
SEGMENT=STORES, SEGTYPE=KU, CRFILE=STORES, CRKEY=STORE, PARENT=SUMCLASS, CRJOINTYPE=INNER, $
FIELDNAME=STORE, FIELDTYPE=I, ALIAS=store, USAGE=I5, ACTUAL=I5,
MISSING=ON,
TITLE='Store Num', DESCRIPTION='Store Num - The Store Number.', $
...
SEGMENT=CALENDAR, SEGTYPE=S0, PARENT=SUMCLASS, CRJOINTYPE=INNER, $
FIELDNAME=DATE, FIELDTYPE=I, ALIAS=date, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Actual Date', DESCRIPTION='Actual Date - The actual date.', $
...
FIELDNAME=FWEEK, ALIAS=fweek, USAGE=I2, ACTUAL=I4,
MISSING=ON,
TITLE='Fsc Week Num', DESCRIPTION='Fsc Week Num - The fiscal week number.', $
...
FIELDNAME=FYEAR, ALIAS=fyear, USAGE=I4, ACTUAL=I4,
MISSING=ON,
TITLE='Fsc Year Num', DESCRIPTION='Fsc Year Num - The fiscal year number.', $

Any help would be welcome.

Thanks!