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     [SOLVED] Need to Filter Auto-Prompt Multi-select Parameter
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Need to Filter Auto-Prompt Multi-select Parameter
 Login/Join
 
Platinum Member
posted
Hello,

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

 

This message has been edited. Last edited by: Brandon Andrathy,


WebFOCUS 8204
 
Posts: 143 | Registered: July 10, 2018Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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)).)

 


WebFOCUS 8204
 
Posts: 143 | Registered: July 10, 2018Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.


WebFOCUS 8204
 
Posts: 143 | Registered: July 10, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Need to Filter Auto-Prompt Multi-select Parameter

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