开发者

MDX Year on Year Sales by Months

开发者 https://www.devze.com 2022-12-22 03:16 出处:网络
I\'m stuck on a MDX query, I\'m trying to retrieve the following results: [Time].[2009][Time].[2开发者_开发问答010]

I'm stuck on a MDX query, I'm trying to retrieve the following results:

                          [Time].[2009]       [Time].[2开发者_开发问答010]
[Time].[Months].Members   [Measures].[Sales]  [Measures].[Sales]

So I would like to compare the sales which were in 2009 against 2010 by month.

In terms of a chart I would have two series one for 2009 and 2010, the y axis would be the sales value and the x axis would be the month.

My query looks like this:

SELECT {[Time].[2009], [Time].[2010]} ON COLUMNS,
[Time].[Months].Members ON ROWS
FROM [SalesProductIndicator] WHERE [Measures].[Sales]

It gives me this error:

Mondrian Error:Dimension '[Time]' appears in more than one independent axis.

Thanks in advance


SELECT {[Time].[2009], [Time].[2010]} ON 0, [Time].[Months].Members ON 1 FROM [Your Cube Name] WHERE [Measures].[Sales]

I based that on this query (below) that I've tested on the Adventure Works sample cube from Miscrosoft:

SELECT {[Ship Date].[Fiscal Year].&[2002], [Ship Date].[Fiscal Year].&[2003]} ON 0,
[Ship Date].[Month of Year].Members ON 1
FROM [Adventure Works] WHERE [Measures].[Sales Amount]

UPDATE:

Based on your query I'm not sure why it is working without specifiying a hierarchy on your cube query (like [Time].[2010] instead of [Time].[Hierarchy Name].[2010]) but could you try this:

SELECT EXISTS([Time].Members, {[Time].[2009], [Time].[2010]}) ON COLUMNS, 
[Time].[Months].Members ON ROWS 
FROM [SalesProductIndicator] WHERE [Measures].[Sales] 

Thanks

0

精彩评论

暂无评论...
验证码 换一张
取 消