I have quite a few queries similar to the following:

SELECT
{[Gender].Members} ON Rows,
{[Customers].Members} on Columns
FROM [Sales]
where [Measures].[Unit sales]

when I run this query I get one additional All Gender row and one
additional column for the All Customer. I do not want this All
dimensions to be reported please suggest how I can modify this query
to eliminate this All dimensions.

Thanks
Simon

Another approach

SELEC
{[Gender].[Gender].Members} ON Rows
{ Descendants([Customers].[All Customers] , 1, self_and_after ) } on Column
FROM [Sales
where [Measures].[Unit sales

By incremeting 1 to 2 you can also eliminate Countries from the query and so on
If you only wanted the customer themselves (the [Name] level) then you can use

SELEC
{[Gender].[Gender].Members} ON Rows
{ [Customers].[Name].members } on Column
FROM [Sales
where [Measures].[Unit sales

HTH
Bria
www.geocities.com/brianaltmann/olap.htm