Not returning (All) row

#1

How do i write the mdx query so I don't get the 'All' row?

select {[RunningTotalSubs]} on Columns, {[Gender].members} on Rows from
[Consumer]

I get
Gender | Total

Quote:

10
M | 5

F | 5

And when it's returned it's not labeled as All.

I just want M and F, no totals.

#2

In analysis manager you can disable the all level,

Click on your Dimension in AS, click on the advanced properties page Select
All Level as No.
"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote

Quote:

How do i write the mdx query so I don't get the 'All' row?

select {[RunningTotalSubs]} on Columns, {[Gender].members} on Rows from
[Consumer]

I get
Gender | Total
| 10
M | 5
F | 5

And when it's returned it's not labeled as All.

I just want M and F, no totals.

#3

Well that is one solution, but then if you do want to see in some other
report the sum of M and F then All level is the one to use.

Therefore the best way would be to change MDX:
select {[RunningTotalSubs]} on Columns, {[Gender].[All Gender].children} on
Rows from
[Consumer]

HTH,
Andrej

"AshVsAOD" <.> wrote

Quote:

In analysis manager you can disable the all level,

Click on your Dimension in AS, click on the advanced properties page
Select
All Level as No.
"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote in message
news:%23enSRhfaEHA.2892 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
How do i write the mdx query so I don't get the 'All' row?

select {[RunningTotalSubs]} on Columns, {[Gender].members} on Rows
from
[Consumer]

I get
Gender | Total
| 10
M | 5
F | 5

And when it's returned it's not labeled as All.

I just want M and F, no totals.

#4

Good point.
"Andrej Hudoklin" <andrej.hudoklin (AT) add (DOT) si> wrote

Quote:

Well that is one solution, but then if you do want to see in some other
report the sum of M and F then All level is the one to use.

Therefore the best way would be to change MDX:
select {[RunningTotalSubs]} on Columns, {[Gender].[All Gender].children}
on
Rows from
[Consumer]

HTH,
Andrej

"AshVsAOD" <.> wrote in message
news:enG630faEHA.3804 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
In analysis manager you can disable the all level,

Click on your Dimension in AS, click on the advanced properties page
Select
All Level as No.
"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote in message
news:%23enSRhfaEHA.2892 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
How do i write the mdx query so I don't get the 'All' row?

select {[RunningTotalSubs]} on Columns, {[Gender].members} on Rows
from
[Consumer]

I get
Gender | Total
| 10
M | 5
F | 5

And when it's returned it's not labeled as All.

I just want M and F, no totals.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Not returning (All) row

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Not returning (All) row - 07-14-2004 , 06:14 PM

Re: Not returning (All) row - 07-14-2004 , 06:48 PM

Re: Not returning (All) row - 07-15-2004 , 03:26 AM

Re: Not returning (All) row - 07-15-2004 , 05:30 PM