I need to filter down my results that I pull into a multi-select parameter that's being used in Designer. As of right now, the results that pull back into the multi-select is everything in the database.
In the example below, can someone advise how I can filter out England from the selections in the auto-prompt multi-select below?
TABLE FILE CAR BY COUNTRY WHERE COUNTRY EQ &COUNTRY.(OR(FIND COUNTRY, COUNTRY IN CAR)). ENDThis message has been edited. Last edited by: Brandon Andrathy,
Update, I found this code:
-DEFAULT &TEST = 'Midwest' -DEFAULT &aregion = '_FOC_NULL'; -DEFAULT &ast = '_FOC_NULL'; -DEFAULT &acity = '_FOC_NULL'; TABLE FILE ibisamp/ggsales SUM UNITS BY REGION BY ST BY CITY BY DATE ACROSS PCD WHERE WHERE REGION EQ &TEST.(FIND REGION IN GGSALES|FORMAT=A11).TEST.QUOTEDSTRING) AND ( REGION EQ &aregion.(FIND REGION IN GGSALES|FORMAT=A11, WITHIN=TEST).Region.QUOTEDSTRING ) AND ( ST EQ &ast.(FIND ST IN GGSALES|FORMAT=A02,WITHIN=aregion).State code.QUOTEDSTRING ) AND ( CITY EQ &acity.(FIND CITY IN GGSALES|FORMAT=A20,WITHIN=ast).City.QUOTEDSTRING ); END
The only problem I am having now is I want to pull in the code part of the value than what is displayed in the front-end. When I try to modify the code, I get the error "Internal exception processing IBFSService.runAdHocFex ".
Does anyone know what I need to do to fix my syntas below?
WHERE WHERE AND ACTIVE EQ &ACTIVE.(FIND ACTIVE IN _DST_STAR|FORMAT=I11).Active.QUOTEDSTRING ) AND (_DIMQUALITYMEASUREKEYID EQ &MEASUREFULLNAME.(OR(FIND DIMQUALITYMEASUREKEYID, MEASUREFULLNAME IN _DST_STAR|FORMAT=I11, WITHIN=ACTIVE)).)
never mind. It was all regarding my syntax.
for anyone else running into issues with parameter prompt chaining, here's my solution
-DEFAULT &COUNTRY = 'ENGLAND'; -DEFAULT &MODEL = '_FOC_NULL'; TABLE FILE CAR BY COUNTRY WHERE WHERE COUNTRY EQ &COUNTRY.(OR(FIND COUNTRY, COUNTRY IN CAR)). AND(MODEL EQ &MODEL.(OR(FIND MODEL, MODEL IN CAR|WITHIN=COUNTRY)).) END
You need have "|" between your master file and WITHIN clause.
|Powered by Social Strata|