'ALL' member when using MDX query

When I try to generate a matrix report using mdx against an AS2000 cube
I am unable to retrieve the "all" level from my "Providers" dimension.
Does anyone know how I can get the all level included in my report?
Basically the 'Providers' dimension has two member plus the all level.
Member 1 - BAC
Member 2 - Fleet
Member 3 - All Providers
Here is my query below.
SELECT { [Measures].[Responses], [Measures].[Responders],
[Measures].[Trans Amount] } ON COLUMNS,
{CROSSJOIN([Providers].[Provider].Members, [Product].Members)} on ROWS,
{ [Response Date].[Month].Members} ON PAGES
FROM [Programmatic_Balance_Build]
Thanks in advance,
JCSee if this would help:
http://prologika.com/CS/blogs/blog/archive/2005/12/20/720.aspx
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
<john.r.carter@.bankofamerica.com> wrote in message
news:1135915701.929683.110800@.g14g2000cwa.googlegroups.com...
> When I try to generate a matrix report using mdx against an AS2000 cube
> I am unable to retrieve the "all" level from my "Providers" dimension.
> Does anyone know how I can get the all level included in my report?
> Basically the 'Providers' dimension has two member plus the all level.
> Member 1 - BAC
> Member 2 - Fleet
> Member 3 - All Providers
> Here is my query below.
> SELECT { [Measures].[Responses], [Measures].[Responders],
> [Measures].[Trans Amount] } ON COLUMNS,
> {CROSSJOIN([Providers].[Provider].Members, [Product].Members)} on ROWS,
> { [Response Date].[Month].Members} ON PAGES
> FROM [Programmatic_Balance_Build]
> Thanks in advance,
> JC
>