Hi Guys,

I have 2-level dimension say dimX. In my MDX, I am doing a cross join of
{[dimX].[Level 01].children}(28 members) with another dimension. So, in
my resultset 28 members gets repeated for say 5 times. I need to get
some kind of serial number for each the 28 members along with the name.
I need a measure that can use to identify a [dimX] member. Any help is
appreciated.



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

Again, I am looking for some kind of index for the 28 members so I can
report based of that index in Reporting Services.



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

Check out the Rank() function. You can use the Rank of the current member
of DimX within the set of 28 members.


"batman batman" <rvenkatasami (AT) hotmail (DOT) com> wrote