On an OLAP report, the dimension selection drop downs only show "ALL" they do not display values to select. It was working just fine, and then stopped. Anyone have an idea why???

here is the fex:

-OLAP ON
APP HOLD ETGA

DEFINE FILE HOLD_POS_TESTING
mailed_sum_STD/I9=Mailed;
mailedts_sum_STD/D12.2=MailedTS;
RPT_DT_STD/YYMD=HDATE(HOLD_POS_TESTING.SEG01.Date, 'YYMD');
TOTAL_DURATION_STD/I9=Duration;

END

TABLE FILE HOLD_POS_TESTING
SUM
TOTAL_DURATION_STD
mailed_sum_STD
COMPUTE AVG_DUR_STD/D12.2 = ( TOTAL_DURATION_STD / mailed_sum_STD ) / 60;
BY MEDRESP
HEADING
""
FOOTING
""
WHERE ( RPT_DT_STD FROM '&Begin_Date' TO '&End_Date' ) AND ( Type NE 'Clerk' );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLD_POS_TEST_STD FORMAT FOCUS INDEX 'MEDRESP'
ON TABLE SET HTMLCSS ON
ON TABLE SET OLAPPANE CONTROL
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END
JOIN
HOLD_POS_TESTING.SEG01.MEDRESP IN HOLD_POS_TESTING TO MULTIPLE
HOLD_POS_TEST_STD.SEG01.MEDRESP IN HOLD_POS_TEST_STD AS J0
END

DEFINE FILE HOLD_POS_TESTING
mailed_sum/I9=Mailed;
mailedts_sum/D12.2=MailedTS;
RPT_DT/YYMD=HDATE(HOLD_POS_TESTING.SEG01.Date, 'YYMD');
TOTAL_DURATION/I9=Duration;

END

OLAP DIMENSIONS
-* DIMENSIONS FILE HOLD_POS_TESTING
Full_Name: Full_Name;
Media: Media;
Response: Response;
AVG_DUR_STD: AVG_DUR_STD;
END
TABLE FILE HOLD_POS_TESTING
-*BY Full_Name AS 'REP,NAME'
SUM
COMPUTE AVG_DUR/D12.2 = ( Duration / mailed_sum ) / 60;
AS 'AVERAGE,DURATION,IN MINUTES'
BY Full_Name
BY Media
BY Response
BY AVG_DUR_STD AS 'STANDARD,AVERAGE ,DURATION ,IN MINUTES'
HEADING
"POS REPORTING - Average Duration per Rep vs Standard Duration for '&Begin_Date' TO '&End_Date'"
FOOTING
""
WHERE RPT_DT FROM '&Begin_Date' TO '&End_Date';
WHERE Type NE 'Clerk';
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE AVG_DUR AS 'COLUMN TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET OLAPPANE TOP
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
FONT='ARIAL',
SIZE=8,
BACKCOLOR=( RGB(220 220 220) 'WHITE' ),
$
TYPE=TITLE,
FONT='ARIAL',
SIZE=9,
COLOR='WHITE',
BACKCOLOR=RGB(75 118 139),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
FONT='ARIAL',
BACKCOLOR=RGB(200 216 224),
STYLE=BOLD,
$
TYPE=FOOTING,
FONT='ARIAL',
SIZE=8,
BACKCOLOR=RGB(200 216 224),
STYLE=BOLD,
$
TYPE=SUBHEAD,
FONT='ARIAL',
SIZE=8,
BACKCOLOR=RGB(147 172 219),
STYLE=BOLD,
$
TYPE=SUBFOOT,
FONT='ARIAL',
SIZE=8,
BACKCOLOR=RGB(147 172 219),
STYLE=BOLD,
$
TYPE=SUBTOTAL,
FONT='ARIAL',
SIZE=8,
BACKCOLOR=RGB(231 238 241),
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
COLUMN=ROWTOTAL(5),
BACKCOLOR=RGB(220 220 220),
$
TYPE=GRANDTOTAL,
FONT='ARIAL',
SIZE=8,
COLOR='WHITE',
BACKCOLOR=RGB(41 66 78),
STYLE=BOLD,
$
ENDSTYLE
END

This message has been edited. Last edited by: Kerry,

Hi John,

Is there any change in your environment?

The following online documents may be of interest:
http://techsupport.information...om/sps/41512543.html
http://techsupport.information...om/sps/30542523.html
http://techsupport.information...om/sps/30322570.html

Cheers,

Kerry