Hi Guys,
I have been having the following error and can't figured out what the cause is.

"
(FOC11207) ERROR IN THE QUERY:
(FOC11306) REQUESTS CAUSING PARTIAL AGGREGATION ARE NOT ALLOWED
"

The sample code is as below. The code works fine if ACROSS fielld MNTH is changed to a BY field. It also works if "Page
Please, can you help.

-SET &NO_OF_MONTHS = -6;
-SET &TODAY_DT = EDIT(&DMYY,'99999999');
-SET &CURRENT_DT=&DATEYY | &DATEM;
-SET &INITIAL_DT=AYM(&CURRENT_DT, &NO_OF_MONTHS,'I6YYM');
-SET &FIRST_DT=EDIT(&INITIAL_DT,'$$$$99') | EDIT(&INITIAL_DT,'9999');

TABLE FILE VOL_REPT
SUM
ATC/D19.2-C AS ''
BY COUNTRY
BY NEW_PRODUCTS AS 'NEW
BY TYPE1
ACROSS MNTH AS ''
ON COUNTRY SUBTOTAL AS 'TOTAL'
HEADING
"VOLUME REPORT"
FOOTING
"Report Filtered by:<+0>ATC"
"Report Produced in:<+0>Euros"
"PageWHERE ( CONVT_TO_CRRNCY EQ 'EUROS' ) AND ( MNTH GE '&FIRST_DT' );

In addition to the above, is it possible to have records for a particular country printed on the next page if it can not be contained in one page? for example:
US = 10 records
CA = 5 records
UK = 7 records

Assuming a page can only contain 20 records, I want to be able to print records for US and CA on one page and then all 7 UK records be printed on the next page instead of printing 5 UK records in page 1 and then the remaining 2 records in the next page.

Thank you.

This message has been edited. Last edited by: Kerry,

Emeke,

I have not been able to reproduce your error using CAR or GGSALES. What is the format of VOL_REPT?

The error text is:
(FOC11306) REQUESTS CAUSING PARTIAL AGGREGATION ARE NOT ALLOWED
Partial Aggregation is caused by presence of "IN GROUPS OF", multiple
erb/key sets as well as active non-Parent/Child hierarchies that do not have
ssociated sort keys or filter tests resulting in unique member selection.

Re: countries on separate pages, use: ON COUNTRY NOSPLIT. If you want to have US and Canada on the same page, create a DEFINE field representing US+CA and use it as a BY field before COUNTRY

e.g. something like:

DEFINE FILE VOL_REPT
CTRY2/I1 = IF COUNTRY EQ 'US' OR 'CA' THEN 1 ELSE 2;
END

TABLE FILE VOL_REPT
...
BY CTRY2 NOPRINT NOSPLIT
BY COUNTRY
BY.....
END

Thank you for your response. VOL_REPT is a FOCUS masterfile built from MS Analysis services Cube.

Thank you.

I do not know if this is a post error or if you code actually looks like this but the AS 'New is missing a closing quote '.