I have to get data from this cube

select { [RunningTotal] }
on Columns, NON EMPTY { [CO INFO].&[10].children } on Rows from
[consumer]

so i get
RunningTotal CompanyID DeptID EmpID
500 Intel IT Dan


But I really want
RunningTotal CompanyID DeptID EmpID
500 10 5 20113

Any way?

A member / level always has intrinsic properties like KEY, NAME and ID. By
including them in your query you should be able to display the key:

select { [RunningTotal] } on Columns,

NON EMPTY { [CO INFO].&[10].children } dimension properties [CO
Info].[<levelname>].[ID] on Rows

from
[consumer]


"Cindy Lee" <cindylee (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:eLZRtdXsEHA.3412 (AT) TK2MSFTNGP14 (DOT) phx.gbl...