取维度的成员属性问题
WITH
MEMBER [Measures].[Store Type] AS '[Store].CURRENTMEMBER.PROPERTIES
("Store Type")'
SELECT
{ [Measures].[Store Type] , [Measures].[Employee Salary] } ON COLUMNS,
{ [Employees].[All Employees].[Sheri Nowmer].[Derrick Whelply].[Beverly
Baker].[Shauna Wyro].[Bunny McCown].CHILDREN } ON ROWS
FROM [HR]
Store Type Employee Salary
---------------------------------------------------------------------
Wanda Hollar #ERR 39.94
Nancy Miler #ERR 70.20
我是新手,我想得到每个员工所属的STORE TYPE, 怎么得到是 #ERR, 请高手告知, 谢谢