with member [Measures].ParQSA as
(parallelPeriod ([Order Date].[Calendar].[Calendar Quarter], 1), [Measures].[Sales Amount - Internet Sales Facts])
member [Measures].MinSA as
Min([Order Date].[Calendar].CurrentMember.Children, [Measures].[Sales Amount - Internet Sales Facts])
member [Measures].MaxSA as
Max([Order Date].[Calendar].CurrentMember.Children, [Measures].[Sales Amount - Internet Sales Facts])
member [Measures].PercSA as
[Measures].MinSA / [Measures].MaxSA
member [Measures].AggrSA as
Aggregate(YTD([Order Date].[Calendar].CurrentMember), [Measures].[Sales Amount - Internet Sales Facts])
member [Measures].PercToCur as
([Measures].AggrSA / ([Order Date].[Calendar].CurrentMember.Parent.Parent, [Measures].[Sales Amount - Internet Sales Facts]))

select
non empty ([Order Date].[Calendar].[Month],{[Measures].[Sales Amount - Internet Sales Facts],
                                            [Measures].AggrSA,
											[Measures].PercToCur,
                                            [Measures].ParQSA,
											[Measures].MaxSA,
											[Measures].MinSA,
											[Measures].PercSA}) on columns,
([Customer].[Gender].[Gender]) on rows
from [Adventure Works DW]



with
member [Measures].MinSA as
Min([Order Date].[Calendar].CurrentMember.Children, [Measures].[Sales Amount - Internet Sales Facts])
member [Measures].MaxSA as
Max([Order Date].[Calendar].CurrentMember.Children, [Measures].[Sales Amount - Internet Sales Facts])

select
([Order Date].[Calendar].[Calendar Year],{[Measures].[Sales Amount - Internet Sales Facts]) on columns,
([Product].[Product].[Product]) on rows
from [Adventure Works DW]










Подставить каждому месяцу значение в предыдущий квартал (по столбцам). По строкам – пол покупателя. В значения сумма проданного товара.
with member Measures.PrevQ as
(parallelPeriod ([Dim Order Date].[Year - Quarter - Month - Date].[Quarter], 1), [Measures].[Sales Amount])
select ([Dim Order Date].[Year - Quarter - Month - Date].[Month].Members,
{[Measures].[Sales Amount], Measures.PrevQ}) on columns
, [Dim Customer].[Gender].[Gender] on rows
from [Adventure Works DW2012]



Подставить каждому месяцу значение в предыдущий квартал (по столбцам). По строкам – пол покупателя. В значения сумма проданного товара.
А также по стобцам добавить информацию о сумме с начала года, до текущей даты, Максимум за указанный месяц, минимум за указанный месяц и разницу между максимумом и минимумом.
with member Measures.PrevQ as
(parallelPeriod ([Dim Order Date].[Year - Quarter - Month - Date].[Quarter], 1), [Measures].[Sales Amount])
member Measures.YSum as Aggregate(YTD( [Dim Order Date].[Year - Quarter - Month - Date].CurrentMember ), [Measures].[Sales Amount])
member Measures.Range as
MAX( [Dim Order Date].[Year - Quarter - Month - Date].CurrentMember.Children, [Measures].[Sales Amount] ) -
MIN ([Dim Order Date].[Year - Quarter - Month - Date].CurrentMember.Children, [Measures].[Sales Amount] )
select ([Dim Order Date].[Year - Quarter - Month - Date].[Month].Members,
{[Measures].[Sales Amount], Measures.PrevQ, Measures.YSum, Measures.Range}) on columns
, [Dim Customer].[Gender].[Gender] on rows
from [Adventure Works DW2012]



with member [Measures].ParQSA as
(parallelPeriod ([Order Date].[Calendar].[Calendar Quarter], 1), [Measures].[Sales Amount - Internet Sales Facts])
member [Measures].MinSA as
Min([Order Date].[Calendar].CurrentMember.Children, [Measures].[Sales Amount - Internet Sales Facts])
member [Measures].MaxSA as
Max([Order Date].[Calendar].CurrentMember.Children, [Measures].[Sales Amount - Internet Sales Facts])
member [Measures].PercSA as
[Measures].MinSA / [Measures].MaxSA
member [Measures].AggrSA as
Aggregate(YTD([Order Date].[Calendar].CurrentMember), [Measures].[Sales Amount - Internet Sales Facts])

select
non empty ([Order Date].[Calendar].[Month],{[Measures].[Sales Amount - Internet Sales Facts],
                                            [Measures].AggrSA,
                                            [Measures].ParQSA,
											[Measures].MaxSA,
											[Measures].MinSA,
											[Measures].PercSA}) on columns,
([Customer].[Gender].[Gender]) on rows
from [Adventure Works DW]