Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Graph Parameters using a hold file
Go
New
Search
Notify
Tools
Reply
  
Graph Parameters using a hold file
 Login/Join
 
Member
posted
I am having trouble passing parameters using the advanced graph assistant. I am using a fex that creates a hold file. That hold file is then used to create a graph. I want the drop down options for each of my graph parameters to be populated by the data that is in the hold file. When i create the parameters and select the file for it to look in, it gives me the option to use the hold file. When i try to add the graph to a HTML page i get the following error "Error Parsing MASTER File HOLD00 ((FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD00 (205))." for each parameter that i add. When i login to a dashboard the drop downs have no choices in them. Please let me know how i can get my parameters to be populated from my hold file.

Thanks in Advance
Kevin


7611 - Win 7
all output
 
Posts: 14 | Location: Indianapolis, IN | Registered: December 07, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
can you post your code?

try to add an -SET &ECHO=ALL; in the beginning of the code.
put a -RUN after the hold section.
and a ? HOLD HOLD00

See what you get then




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Member
posted Hide Post
I have posted the code below. There is a large section of it that sets the user's access and a large section that designates the periods. Everything works until i try to make one of the fields a parameter. I have added the set &ECHO=ALL and added a run to the end of the second hold file. Please let me know if you have any additional suggestions. This did not resolve my problem.

Thanks


-* File cust_billto_volume_billtototalvolume_s1_graph.fex
-DEFAULTH &LOCATION_ID='DEFAULT'
-DEFAULTH &LOCATION_NAME='DEFAULT'

-SET &TODAYS_DATE=&YYMD;

-SET &ECHO=ALL

-SET &TODAYS_DOW=DOWK(&TODAYS_DATE, 'A4');

-SET &TODAYS_ADJ=IF (&TODAYS_DOW EQ 'MON') THEN -1 ELSE
- IF (&TODAYS_DOW EQ 'TUE') THEN -2 ELSE
- IF (&TODAYS_DOW EQ 'WED') THEN -3 ELSE
- IF (&TODAYS_DOW EQ 'THU') THEN -4 ELSE
- IF (&TODAYS_DOW EQ 'FRI') THEN -5 ELSE
- IF (&TODAYS_DOW EQ 'SAT') THEN -6 ELSE
- IF (&TODAYS_DOW EQ 'SUN') THEN -7 ELSE 0;
-SET &THRU_DATE=AYMD(&TODAYS_DATE, &TODAYS_ADJ, 'I8');
-SET &FROM_DATE=AYMD(&THRU_DATE, -6, 'I8');

-SET &HTD_PERIOD_BEG=AYMD(&THRU_DATE, -181, 'I8');
-SET &HTD_PERIOD_END=&THRU_DATE;

-SET &FILTER_FROM_DATE=EDIT(&HTD_PERIOD_BEG,'9999/99/99');
-SET &FILTER_THRU_DATE=EDIT(&HTD_PERIOD_END,'9999/99/99');

-SET &UC_USER_ID=IF (&IBIMR_user NE ' ') THEN &IBIMR_user ELSE 'NOUSERID';
-SET &UC_USER_ID=UPCASE(&UC_USER_ID.LENGTH, &UC_USER_ID, &UC_USER_ID);

-RUN

-SET &FILTER_LOCATION_ID=IF (&LOCATION_NAME EQ 'DEFAULT') THEN 'FOC_NONE' ELSE
- IF (&LOCATION_NAME EQ 'All Locations') THEN 'FOC_NONE' ELSE &LOCATION_ID;

-SET &PERIOD_01_BEG=&HTD_PERIOD_BEG;
-SET &PERIOD_01_END=AYMD(&PERIOD_01_BEG, 6, 'I8');
-SET &PERIOD_02_BEG=AYMD(&PERIOD_01_END, 1, 'I8');
-SET &PERIOD_02_END=AYMD(&PERIOD_01_END, 7, 'I8');
-SET &PERIOD_03_BEG=AYMD(&PERIOD_02_END, 1, 'I8');
-SET &PERIOD_03_END=AYMD(&PERIOD_02_END, 7, 'I8');
-SET &PERIOD_04_BEG=AYMD(&PERIOD_03_END, 1, 'I8');
-SET &PERIOD_04_END=AYMD(&PERIOD_03_END, 7, 'I8');
-SET &PERIOD_05_BEG=AYMD(&PERIOD_04_END, 1, 'I8');
-SET &PERIOD_05_END=AYMD(&PERIOD_04_END, 7, 'I8');
-SET &PERIOD_06_BEG=AYMD(&PERIOD_05_END, 1, 'I8');
-SET &PERIOD_06_END=AYMD(&PERIOD_05_END, 7, 'I8');
-SET &PERIOD_07_BEG=AYMD(&PERIOD_06_END, 1, 'I8');
-SET &PERIOD_07_END=AYMD(&PERIOD_06_END, 7, 'I8');
-SET &PERIOD_08_BEG=AYMD(&PERIOD_07_END, 1, 'I8');
-SET &PERIOD_08_END=AYMD(&PERIOD_07_END, 7, 'I8');
-SET &PERIOD_09_BEG=AYMD(&PERIOD_08_END, 1, 'I8');
-SET &PERIOD_09_END=AYMD(&PERIOD_08_END, 7, 'I8');
-SET &PERIOD_10_BEG=AYMD(&PERIOD_09_END, 1, 'I8');
-SET &PERIOD_10_END=AYMD(&PERIOD_09_END, 7, 'I8');
-SET &PERIOD_11_BEG=AYMD(&PERIOD_10_END, 1, 'I8');
-SET &PERIOD_11_END=AYMD(&PERIOD_10_END, 7, 'I8');
-SET &PERIOD_12_BEG=AYMD(&PERIOD_11_END, 1, 'I8');
-SET &PERIOD_12_END=AYMD(&PERIOD_11_END, 7, 'I8');
-SET &PERIOD_13_BEG=AYMD(&PERIOD_12_END, 1, 'I8');
-SET &PERIOD_13_END=AYMD(&PERIOD_12_END, 7, 'I8');
-SET &PERIOD_14_BEG=AYMD(&PERIOD_13_END, 1, 'I8');
-SET &PERIOD_14_END=AYMD(&PERIOD_13_END, 7, 'I8');
-SET &PERIOD_15_BEG=AYMD(&PERIOD_14_END, 1, 'I8');
-SET &PERIOD_15_END=AYMD(&PERIOD_14_END, 7, 'I8');
-SET &PERIOD_16_BEG=AYMD(&PERIOD_15_END, 1, 'I8');
-SET &PERIOD_16_END=AYMD(&PERIOD_15_END, 7, 'I8');
-SET &PERIOD_17_BEG=AYMD(&PERIOD_16_END, 1, 'I8');
-SET &PERIOD_17_END=AYMD(&PERIOD_16_END, 7, 'I8');
-SET &PERIOD_18_BEG=AYMD(&PERIOD_17_END, 1, 'I8');
-SET &PERIOD_18_END=AYMD(&PERIOD_17_END, 7, 'I8');
-SET &PERIOD_19_BEG=AYMD(&PERIOD_18_END, 1, 'I8');
-SET &PERIOD_19_END=AYMD(&PERIOD_18_END, 7, 'I8');
-SET &PERIOD_20_BEG=AYMD(&PERIOD_19_END, 1, 'I8');
-SET &PERIOD_20_END=AYMD(&PERIOD_19_END, 7, 'I8');
-SET &PERIOD_21_BEG=AYMD(&PERIOD_20_END, 1, 'I8');
-SET &PERIOD_21_END=AYMD(&PERIOD_20_END, 7, 'I8');
-SET &PERIOD_22_BEG=AYMD(&PERIOD_21_END, 1, 'I8');
-SET &PERIOD_22_END=AYMD(&PERIOD_21_END, 7, 'I8');
-SET &PERIOD_23_BEG=AYMD(&PERIOD_22_END, 1, 'I8');
-SET &PERIOD_23_END=AYMD(&PERIOD_22_END, 7, 'I8');
-SET &PERIOD_24_BEG=AYMD(&PERIOD_23_END, 1, 'I8');
-SET &PERIOD_24_END=AYMD(&PERIOD_23_END, 7, 'I8');
-SET &PERIOD_25_BEG=AYMD(&PERIOD_24_END, 1, 'I8');
-SET &PERIOD_25_END=AYMD(&PERIOD_24_END, 7, 'I8');
-SET &PERIOD_26_BEG=AYMD(&PERIOD_25_END, 1, 'I8');
-SET &PERIOD_26_END=AYMD(&PERIOD_25_END, 7, 'I8');

SET ALL = ON
SET ASNAMES = ON
SET HOLDLIST = PRINTONLY

DEFINE FILE WORKGROUPUSERADDRESSXREF
UC_USERNAME/A20=UPCASE(20, VC_USERNAME, UC_USERNAME);
END
TABLEF FILE WORKGROUPUSERADDRESSXREF
BY 'WORKGROUPUSERADDRESSXREF.WORKGROUPUSERADDRESSXREF.INT_ADDRESSID'
WHERE UC_USERNAME EQ '&UC_USER_ID';
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLD_ADDRESSID FORMAT ALPHA
END

DEFINE FILE CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME
MODE/A20=
IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 4 OR 5 OR 15 THEN 'CONSOL'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 12 THEN 'CROSSDOCK'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 13 OR 29 OR 30 OR 43 OR 44 THEN 'FUEL'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 9 OR 10 OR 21 OR 50 OR 51 OR 52 OR 53 OR 54 OR 55 OR 56 OR 59 OR 61 OR 62 OR 64 OR 65 OR 66 OR 67 OR 68 OR 69 OR 70 OR 72 OR 73 OR 74 OR 75 OR 76 OR 77 OR 78 OR 79 OR 80 OR 81 OR 82 OR 83 OR 84 OR 85 OR 86 OR 87 OR 88 OR 89 OR 90 OR 91 OR 92 OR 93 OR 94 OR 96 OR 98 OR 205 OR 209 OR 210 OR 230 OR 232 OR 233 OR 234 OR 235 OR 237 OR 244 OR 247 OR 250 OR 254 OR 255 OR 256 OR 263 OR 264 OR 265 OR 266 OR 267 OR 268 OR 269 OR 270 OR 271 OR 283 OR 284 OR 285 OR 308 OR 336 OR 341 OR 344 OR 348 OR 349 OR 350 OR 351 OR 352 OR 363 OR 364 OR 365 OR 366 OR 368 OR 369 THEN 'BROKERAGE'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 100 OR 102 OR 103 OR 104 OR 105 OR 106 OR 107 OR 108 OR 109 OR 110 OR 111 OR 112 OR 113 OR 114 OR 115 OR 116 OR 117 OR 118 OR 119 OR 120 OR 121 OR 122 OR 123 OR 124 OR 125 OR 126 OR 127 OR 128 OR 129 OR 130 OR 131 OR 132 OR 133 OR 134 OR 135 OR 136 OR 137 OR 138 OR 139 OR 140 OR 141 OR 200 OR 201 OR 217 OR 236 OR 242 OR 243 OR 248 OR 249 OR 253 OR 274 OR 275 OR 289 OR 292 OR 293 OR 294 OR 297 OR 304 OR 354 OR 367 OR 378 THEN 'INTL_AIR'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 36 OR 142 OR 143 OR 144 OR 145 OR 146 OR 147 OR 148 OR 149 OR 150 OR 151 OR 152 OR 153 OR 154 OR 155 OR 156 OR 157 OR 158 OR 159 OR 160 OR 161 OR 162 OR 163 OR 164 OR 165 OR 166 OR 167 OR 168 OR 169 OR 170 OR 171 OR 172 OR 173 OR 174 OR 175 OR 176 OR 177 OR 178 OR 179 OR 180 OR 181 OR 182 OR 183 OR 184 OR 185 OR 186 OR 187 OR 188 OR 189 OR 190 OR 191 OR 192 OR 193 OR 194 OR 195 OR 196 OR 197 OR 198 OR 199 OR 207 OR 208 OR 211 OR 212 OR 213 OR 214 OR 215 OR 216 OR 238 OR 240 OR 245 OR 252 OR 258 OR 259 OR 272 OR 286 OR 287 OR 288 OR 290 OR 291 OR 296 OR 299 OR 301 OR 302 OR 303 OR 305 OR 306 OR 307 OR 322 OR 323 OR 326 OR 327 OR 329 OR 330 OR 345 OR 346 OR 353 OR 355 OR 357 OR 358 OR 359 OR 360 OR 362 OR 374 OR 375 OR 376 OR 377 THEN 'INTL_OCEAN'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 7 OR 334 OR 335 OR 347 THEN 'LTL'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 46 OR 48 THEN 'MILKRUN'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 2 OR 3 OR 18 OR 19 OR 22 OR 24 OR 27 OR 28 OR 33 OR 35 OR 49 OR 71 OR 95 OR 97 OR 99 OR 202 OR 203 OR 204 OR 206 OR 218 OR 219 OR 220 OR 221 OR 226 OR 227 OR 228 OR 229 OR 246 OR 251 OR 276 OR 277 OR 282 OR 295 OR 298 OR 300 OR 309 OR 310 OR 311 OR 312 OR 313 OR 314 OR 315 OR 316 OR 317 OR 318 OR 324 OR 325 OR 328 OR 342 OR 343 OR 370 OR 371 OR 372 OR 373 THEN 'MISC'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 257 OR 319 OR 320 OR 321 THEN 'PROMEX'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 1 OR 6 OR 8 OR 14 OR 17 OR 20 OR 26 OR 31 OR 34 OR 37 OR 39 OR 45 OR 47 OR 101 OR 222 OR 223 OR 224 OR 225 OR 231 OR 260 OR 261 OR 331 OR 332 OR 333 OR 337 OR 338 OR 339 OR 340 OR 356 OR 361 THEN 'TL'
ELSE IF CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.CHARGESERVICEID EQ 11 OR 32 OR 262 THEN 'WAREHOUSING' ELSE 'MISC';
END
TABLE FILE CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME
SUM
'CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.TOTALWEIGHT'
AS 'TOTALWEIGHT'
BY 'CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.PICKUPSTARTDATETIME'
AS 'PICKEDUPDATE'
BY 'CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.MODE'
BY 'CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.Ship_From.ship_from_NAME'
BY 'CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.Ship_To.ship_to_NAME'
BY 'CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.BILL_TO.NAME'
WHERE CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.BILLTOID IN FILE HOLD_ADDRESSID;
WHERE CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.BILLTOID EQ '&FILTER_LOCATION_ID';
WHERE CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.PICKUPSTARTDATETIME GE DT(&FILTER_FROM_DATE 00:00:00);
WHERE CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.PICKUPSTARTDATETIME LE DT(&FILTER_THRU_DATE 23:59:59);
WHERE CUST_BILLTO_VOLUME_BILLTOTOTALVOLUME.TSW_SHIPMENT.ACTIVEFLAG EQ 1;
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLD00
END
DEFINE FILE HOLD00
CHR_PICKEDUPDATE/A20=HCNVRT(PICKEDUPDATE, '(HYYMDI)', 20, CHR_PICKEDUPDATE);
SEL_PICKEDUPDATE/A08YYMD=EDIT(CHR_PICKEDUPDATE,'9999$99$99');
PERIOD/YYMD=
IF (SEL_PICKEDUPDATE GE '&PERIOD_01_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_01_END') THEN '&PERIOD_01_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_02_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_02_END') THEN '&PERIOD_02_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_03_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_03_END') THEN '&PERIOD_03_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_04_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_04_END') THEN '&PERIOD_04_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_05_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_05_END') THEN '&PERIOD_05_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_06_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_06_END') THEN '&PERIOD_06_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_07_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_07_END') THEN '&PERIOD_07_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_08_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_08_END') THEN '&PERIOD_08_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_09_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_09_END') THEN '&PERIOD_09_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_10_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_10_END') THEN '&PERIOD_10_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_11_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_11_END') THEN '&PERIOD_11_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_12_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_12_END') THEN '&PERIOD_12_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_13_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_13_END') THEN '&PERIOD_13_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_14_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_14_END') THEN '&PERIOD_14_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_15_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_15_END') THEN '&PERIOD_15_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_16_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_16_END') THEN '&PERIOD_16_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_17_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_17_END') THEN '&PERIOD_17_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_18_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_18_END') THEN '&PERIOD_18_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_19_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_19_END') THEN '&PERIOD_19_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_20_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_20_END') THEN '&PERIOD_20_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_21_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_21_END') THEN '&PERIOD_21_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_22_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_22_END') THEN '&PERIOD_22_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_23_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_23_END') THEN '&PERIOD_23_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_24_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_24_END') THEN '&PERIOD_24_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_25_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_25_END') THEN '&PERIOD_25_END' ELSE
IF (SEL_PICKEDUPDATE GE '&PERIOD_26_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_26_END') THEN '&PERIOD_26_END' ELSE 0;
END

TABLE FILE HOLD00
SUM
'HOLD00.HOLD00.TOTALWEIGHT'
BY 'HOLD00.HOLD00.PERIOD'
BY 'HOLD00.HOLD00.MODE'
BY 'HOLD00.HOLD00.NAME'
BY 'HOLD00.HOLD00.ship_to_NAME'
BY 'HOLD00.HOLD00.ship_from_NAME'
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLD01
-RUN
END

GRAPH FILE HOLD01
-* Created by Advanced Graph Assistant
SUM HOLD01.HOLD01.TOTALWEIGHT
BY HOLD01.HOLD01.NAME
ACROSS HOLD01.HOLD01.PERIOD
WHERE HOLD01.HOLD01.MODE EQ &MODE.(OR(FIND HOLD01.HOLD01.MODE IN HOLD01)).Mode:.;
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 548
ON GRAPH SET VAXIS 320
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setFillColor(getSeries(0),new Color(0,0,128));
setFillColor(getSeries(1),new Color(128,0,0));
setFillColor(getSeries(2),new Color(0,128,0));
setFillColor(getSeries(3),new Color(255,131,0));
setFillColor(getSeries(4),new Color(64,0,64));
setFillColor(getSeries(5),new Color(12,249,255));
setFillColor(getSeries(6),new Color(170,255,5));
setTextString(getTitle(),"Weekly Volume by Mode");
setDisplay(getTitle(),true);
setDisplay(getO1Label(),true);
setTextString(getO1Title(),"Period Ending");
setDisplay(getO1Title(),true);
setFillColor(getFrame(),new Color(192,192,192));
setFillColor(getChartBackground(),new Color(128,128,128));
setTextRotation(getO1Label(),3);
setAutoSkip(getO1Label(),2);
setSkipCount(getO1Label(),1);
setFillColor(getFrameSide(),new Color(192,192,192));
setFillColor(getFrameBottom(),new Color(192,192,192));
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=DATA, ACROSSCOLUMN=N1, FOCEXEC=dashinclude_launch_billto_volume(MODE=HOLD01.HOLD01.MODE), $
ENDSTYLE
END


7611 - Win 7
all output
 
Posts: 14 | Location: Indianapolis, IN | Registered: December 07, 2010Reply With QuoteReport This Post
Member
posted Hide Post
I do not understand the part about putting a ?hold hold00. Please explain where to do that.
Thanks


7611 - Win 7
all output
 
Posts: 14 | Location: Indianapolis, IN | Registered: December 07, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
If you instead of creating a graph, just make a table you will get an error too I suppose.
I think the define in the HOLD00 section does not work well.
I would start with putting an - EXIT before the GRAPH part.
Then you will see what is wrong.

the next change that might work is change this


quote:
IF (SEL_PICKEDUPDATE GE '&PERIOD_26_BEG') AND (SEL_PICKEDUPDATE LE '&PERIOD_26_END') THEN '&PERIOD_26_END' ELSE 0;


into

IF (SEL_PICKEDUPDATE GE '&PERIOD_26_BEG.EVAL') AND (SEL_PICKEDUPDATE LE '&PERIOD_26_END,EVAL') THEN '&PERIOD_26_END.EVAL' ELSE 0;


and that for all the &values

BTW

I think there is an other way to achive what you are doing...

Look at the formula DATEMOV and all the options you have there...
there is one that moves to the beginning of the week (BOW) or the end of the week (EOW)




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Member
posted Hide Post
I do not get any error messages when i run this proceedure with no perameters in the graph. It is only when i put the parameter in that i get the error. If i just make a table i do not get an error.


7611 - Win 7
all output
 
Posts: 14 | Location: Indianapolis, IN | Registered: December 07, 2010Reply With QuoteReport This Post
Member
posted Hide Post
Frank,
I have been able to recreate this error using the car file. Take a look at the following code. My goal is to use a hold file to create the graph and then do parameters on the graph. In this case i have excluded all SEDAN bodytypes. I then want to have the bodytype field as a parameter in the graph. Thanks for your help.


-* File cartest_parametersinagraph.fex
TABLE FILE CAR
BY 'CAR.BODY.BODYTYPE'
BY 'CAR.BODY.SEATS'
BY 'CAR.SPECS.WEIGHT'
WHERE CAR.BODY.BODYTYPE NE 'SEDAN';
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLD1 FORMAT FOCUS
END
-RUN


GRAPH FILE HOLD1
SUM HOLD1.SEG01.WEIGHT
BY HOLD1.SEG01.BODYTYPE
WHERE HOLD1.SEG01.BODYTYPE EQ &BODYTYPE.(OR(FIND HOLD1.SEG01.BODYTYPE IN HOLD1)).Bodytype:.;
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setPlace(true);
ENDSTYLE
END


7611 - Win 7
all output
 
Posts: 14 | Location: Indianapolis, IN | Registered: December 07, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Graph Parameters using a hold file

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.