CNT.DST in combination with WITHIN throws this error: (FOC1...

[Peter Vazny]

CNT.DST in combination with WITHIN throws this error:

(FOC1867) OPERATOR MUST BE AT THE LOWEST LEVEL OF AGGREGATION

 

The only thing I can come up with when searching for that error is in the documentation:

 

 

The following error occurs if you use a multi-verb request, SUM DST.fieldname BY field PRINT fld BY fld (a verb object operator used with the SUM command must be at the lowest level of aggregation):

(FOC1867) DST OPERATOR MUST BE AT THE LOWEST LEVEL OF AGGREGATION

The DST. operator may not be used as part of a HEADING or a FOOTING.

 

 

Which does not make much sense. First of all the error I am getting is missing the operator, second, I am not using it in heading nor footing and lastly I am not using a multi verb request.

Here is a sample code based on the Retail Samples demo database:

TABLE FILE retail_samples/wf_retail_tiny

SUM CNT.DST.WF_RETAIL_TINY.WF_RETAIL_PRODUCT.BRAND WITHIN WF_RETAIL_TINY.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY

BY WF_RETAIL_TINY.WF_RETAIL_PRODUCT.PRODUCT_CATEGORY

BY WF_RETAIL_TINY.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG

ON TABLE PCHOLD FORMAT HTML

ON TABLE NOTOTAL

 

-RUN

[Martin Yergeau]

It runs perfectly under 8204 but not under 8207v28

Result with 8204:

 

image.png392614 8.86 KB

 

You probably should open a case

[Peter Vazny]

Thank you for checking my sanity, that is what I needed.

[SATHEESH B]

There was a change in usages of WITHIN after 8204. the count should be calculated by the immediate By field.

Below order count is by subcategory

Category Sub Category > count.

when you use WITHIN it should count by Category it was working in lower version but it was bug. Count should be calculated by immediate by field. it was fixed in 8207 .

We had to change the reports because it was not supported in new releases.

[Debra Waybright]

See Chucks reply in this Focal Point posting for more clarification: http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7847060296r=5797060296#5797060296