As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.
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)).
END
-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)).)
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.