Mozhet eto to chto ti ischesh?

Esli chto ne ponyatno spashivai.

WITH
member [CalendarYear].[Ratio %] as
'([CalendarYear].[All CalendarYeare].[2003], [ProductGroup].CURRENTMEMBER, [Measures].CURRENTMEMBER) * 100.0 /
([CalendarYear].[All CalendarYeare].[2003], [ProductGroup].[TotalMember], [Measures].CURRENTMEMBER)', SOLVE_ORDER=1

member [CalendarYear].[Running Total] as
'SUM(HEAD([TotalSet],RANK([ProductGroup].CURRENTMEMBER,[TotalSet])),
([CalendarYear].[All CalendarYeare].[2003],[Measures].CURRENTMEMBER))'

member [CalendarYear].[Running Total Ratio %] as
'SUM(HEAD([TotalSet],RANK([ProductGroup].CURRENTMEMBER,[TotalSet])),
(([CalendarYear].[All CalendarYeare].[2003],[ProductGroup].CURRENTMEMBER,[Measures].CURRENTMEMBER) * 100.0 /
([CalendarYear].[All CalendarYeare].[2003],[ProductGroup].[TotalMember],[Measures].CURRENTMEMBER)))', SOLVE_ORDER=1

SET [RowSet0] AS '{[ProductGroup].[All ProductGroupn].[(1) Hardware].children}'
SET [TotalSet] AS '[RowSet0]'
member [ProductGroup].[TotalMember] AS '[ProductGroup].[All ProductGroup].[(1) Hardware]'

SELECT
{[CalendarYear].[All CalendarYeare].[2003],
[CalendarYear].[Ratio %],
[CalendarYear].[Running Total],
[CalendarYear].[Running Total Ratio %]} ON COLUMNS,

CROSSJOIN({[RowSet2]},{[Measures].[SalesAmount], [Measures].[ProfitAmount]})

ON ROWS
FROM Sales

:-) Opirayas na "glubokie znaniya MDX" napisat svoi. :-) Ili budget ne pozvolyaet? :-)

To chto ya privel v svoem primere eto ne rukopisnii MDX a sgenererirovanni moim klientom. Ya prosto ego iz loga vidernul.