A New Internet Library: Add Your Website/Blog or Suggest A Website/Blog to our Free Web Directory http://anil.myfunda.net.

Its very simple, free and SEO Friendly.
Submit Now....

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];



Source Click Here.

0 comments