Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Peter Vazny

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...