Can anyone tell me that in the following query what is the purpose of
Store.[].


WITH MEMBER STORE.[] AS 'NULL' MEMBER GENDER.TOTAL AS
'SUM(HEAD(AXIS(1),AXIS(1).COUNT-1))',SOLVE_ORDER=1 SELECT
{[MEASURES].[UNIT SALES]} ON COLUMNS,
{CROSSJOIN({GENDER.M,GENDER.F},{USA.CHILDREN}),{(G ENDER.TOTAL,STORE.[])}}
ON ROWS FROM SALES



This query gives the total of the columns at the bottom.

Regards,

Harris

Store.[] is needed to provide something to crossjoin
with. The gender total is crossjoined with a 'dummy' null
just as M,F with USA.children.

I guess it needs to be balanced.

HTH Lutz