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.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
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.