I have a gender dimension with two member: male and female.
The result of mdx:
SELECT {[Measures].[SalesAmount]} on
Columns,{[gender].[male],[gender].[female],[gender].[all]} ON
ROWS,{[Area].Members} ON Pages FROM [Sales]

will display male and female on the caption of rows, but the "all" does'nt
display.

I want to display the "all" caption.
How can I do that?

This Foodmart Sales query seems to work - how does it compare to your
situation?

Columns,{[Gender].[M],[Gender].[F],[Gender].[all Gender]} ON
ROWS
FROM [Sales]

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thank,
When I use the MDX below in MDX sample Application, it will return:
Store Sales
---------------------------
M 258011.92
F 280226.21
All Gender 565238.13


But in the Sql 2000 Reporting Service, the All Gender will not be displayed,
like
Store Sales
---------------------------
M 258011.92
F 280226.21
565238.13

Can I specifically assign the properties to force it to display "All
Gender"




"Deepak Puri" <deepak_puri (AT) progressive (DOT) com>
???????:#ZREfVTlEHA.2892 (AT) tk2msftngp13 (DOT) phx.gbl...

You are absolutely correct. This is discussed in the following white paper.
http://msdn.microsoft.com/library/de...lapasandrs.asp
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"ad" <ad (AT) wfes (DOT) tcc.edu.tw> wrote

Thank Sir,
I have read this paper.
The paper is some difficult for me,I can't find any answer for my problem.





"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:eag3RVWlEHA.2224 (AT) tk2msftngp13 (DOT) phx.gbl...

I think that the relevant excerpt from the paper is:

http://msdn.microsoft.com/library/de.../en-us/dnsql2k
/html/olapasandrs.asp
Another behavior of the flattening algorithm is that the "[(ALL)]" level
is not included in the dataset. This has a couple of implications. The
first is that if you want to include data from the "All" member of a
dimension, you'll need to create a calculated member to represent this
member. This can be accomplished in a couple of different ways. The
first method would be to create a calculated member on the Measures
dimension and for the definition of the calculated member refer to the
current member's name or unique name. There are several examples of this
method represented in later sections of this whitepaper.

Note The "All" level of a dimension is not included in the field set
that is returned to Reporting Services.
...

So here's a modified version of the Foodmart Sales query:

'[Gender].CurrentMember.Name'
SELECT {[Measures].[GenderName], [Measures].[Store Sales]} on Columns,
{[Gender].[M],[Gender].[F],[Gender].[all Gender]} on Rows
FROM [Sales]

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thank!
You answer is excllent.
It's help me a lot!

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com>
???????:us6Gz1blEHA.1356 (AT) TK2MSFTNGP09 (DOT) phx.gbl...