Hello,

I keep running into errors when I try to chain Parameters together that use a send value and a display value. Can someone tell me what I'm doing wrong here?

In the example below, why does the last line with PCD work when I run without WITHIN. But it doesn't run when I include it?

 

-DEFAULT &aregion = '_FOC_NULL';

 TABLE FILE ibisamp/ggsales
 SUM UNITS
  BY REGION
  BY ST
  BY CITY
  BY DATE
  ACROSS PCD
  WHERE
	AND	( REGION EQ &aregion.(OR(FIND REGION IN GGSALES|FORMAT=A11)).Region.QUOTEDSTRING )
	AND ( PCD EQ &PCD.(OR(FIND PCD, PRODUCT IN GGSALES|WITHIN=aregion)).)
 END

 

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

I found this thread.

Looks like someone else had the same problem as I did.

http://forums.informationbuild...1057331/m/6747093886

Need to remove the AND after the WHERE and the QUOTEDSTRING. The following code worked for me in 8.2.06.

-DEFAULT &aregion = '_FOC_NULL';
-DEFAULT &PCD     = '_FOC_NULL';
 TABLE FILE ibisamp/ggsales
 SUM UNITS
  BY REGION
  BY ST
  BY CITY
  BY DATE
  ACROSS PCD
  WHERE	REGION EQ &aregion.(OR(FIND REGION IN GGSALES|FORMAT=A11)).Region. 
    AND PCD EQ &PCD.(OR(FIND PCD, PRODUCT IN GGSALES|WITHIN=aregion)). 
 END

I think there was an issue with having both chaining and code,value like you have with PCD,PRODUCT. I was told the issue was fixed in 8.2.05.

Thanks a lot dbeagan.

I appreciate your input.

I'm still on 8204 and even with the revised code, I'm getting an error. I guess I'll have to wait for upgrade before I can really start using designer functionality.

Missed by .01 of a version haha.

Thanks again. I'm closing this for now.