I have what I think is a simple request, but cannot find any clear
references on how to meet it.

My users frequently want to pull their sales data with the Geographic
Customer dimension on rows and the time dimension on columns. They
would like to number each of the rows.

My thought was to create a calculated member that I could nest inside
the time dimension (columns) next to the Quantity measure. I am
researching the use of the RANK function, but I can't seem to get
anywhere. Has anyone out there had any luck with this sort of request?

-Maureen Adams

Does this sample Foodmart MDX query help?

'Rank(StrToSet("Axis(1)").Item(0).Item(0).Dimensio n.CurrentMember,
StrToSet("Axis(1)"))'

select Non Empty CrossJoin([Time].[1997].Children,
{[Measures].[RowRank], [Measures].[Unit Sales]}) on columns,
[Customers].[All Customers].[USA].[OR].Children on rows
from Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

I think this will help, but excuse my ignorance..I can't just use this
as a calculated member, can I? How do I set it up within the cube?

Maureen Adams

*** Sent via Developersdex http://www.developersdex.com ***

You should be able to define a [RowRank] calculated member on the
[Measures] dimension, using the Cube Editor, with the MDX below
(assuming [RowRank] is used as in query):

StrToSet("Axis(1)"))

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***