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)).) ENDThis message has been edited. Last edited by: Brandon Andrathy,
I found this thread.
Looks like someone else had the same problem as I did.
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.
|Powered by Social Strata|