Database Reference
In-Depth Information
[Sales Reason].[Sales Reason].members
on rows,
[Promotion].[English Promotion
Category].members on columns
from [Adventure Works DW2012]
where
[Measures].[Sales Amount];
select
{[Sales Territory].[Sales Territory
Group].&[Europe],
[Sales Territory].[Sales Territory
Group].&[North America],
[Sales Territory].[Sales Territory
Group].&[Pacific],
[Sales Territory].[Sales Territory
Group].[All]} on rows,
[Promotion].[English Promotion
Category].members on columns
from [Adventure Works DW2012]
where
[Measures].[Sales Amount];
select
[Customer].[Gender].members on rows,
[Ship Date].[Hierarchy].[Calendar Year]
on columns
from [Adventure Works DW2012]
where
[Measures].[Sales Amount];
select [Customer].[Marital
Status].members on rows,
[Due Date].[Hierarchy].[Month] on
columns
from [Adventure Works DW2012]
where
[Measures].[Sales Amount];
Search WWH ::




Custom Search