In the Adventure Works database I would like to return information about the set of Managers at Level 04 (one level of the Parent-Child hierarchy) plus the sum of the sales for that Manager and her reports.
Along with the manager's name, I need to display the manager's email address too.
with member [Measures].[Email] as '[Employee].[Employees].currentmember.properties("email address")'
SELECT
{[Measures].[Email] ,[Reseller Sales Amount]} on 0 ,
NON EMPTY filter(([Employee].[Employees].[Employee Level 04].MEMBERS),[Reseller Sales Amount]>0) ON 1
FROM [Adventure Works];
No comments:
Post a Comment