I want to just list the values for a specific level or measure but not sum
it. Is there a MDX query that I can list, i.e. - the commission amount for
all employees or particular employees?

Sam, is the "commission amount" in the measure group or is it an attribute
of the dimension?

If it's in the measure group (i.e,. out of the fact table) then it should,
by definition, be semi-additive, so unless you're selecting the lowest level
of the dimension hierarchy, it should sum right? If for example, you're
looking at the sales region - employee hierarchy, then sales region
commissions are actually the sum of the commissions for all employees in the
region. And without time, the commisision for an employee is the sum of all
commissions for that employee over all time.

If it's an atribute of the dimension, then its just:

select {[Employee].[Employee Name], [Employee].[Commission Amount] } ON
COLUMNS,
{} ON ROWS
FROM [MyCube]

"SAM" <SAM (AT) discussions (DOT) microsoft.com> wrote