Calculated Members - How to compare values of selected month of Year A with values of same Month of Year B

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Calculated Members - How to compare values of...

Calculated Members - How to compare values of selected month of Year A with values of same Month of Year B

Rate Topic

Display Mode

Topic Options

Author

Message

iBar

Posted Monday, July 30, 2012 4:40 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 18, 2013 11:16 AM
Points: 572, Visits: 746

HI,

Month Over Month Comparison by Year.

For example, I want to compare aggregated internet sales of "January 2012" with "January 2011".

I want to choose month e.g. january and it must compare like this

date.currentmember, parallelperiod(date.year, 1, date.month)

I want comparison like this or vice versa.

          2005 | 2006 | 2007 | ...
January    ... |  ... |  ... | ...
February   ... |  ... |  ... | ...
March      ... |  ... |  ... | ...
...

I want to add this as a calculated member in the cube.

Thanks.

Post #1337605

iBar

Posted Thursday, August 02, 2012 3:37 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 18, 2013 11:16 AM
Points: 572, Visits: 746

http://stackoverflow.com/questions/5312493/in-ssas-cannot-make-the-parallelperiod-function-work-when-crossing-months-and-y

As mentioned in this link and in the following query, its working in the desired way. How to put this in Cube as calculated member?

SELECT
[Date].[Month of Year].CHILDREN ON ROWS,
( [Date].[Calendar Year].CHILDREN, { [Measures].[Sales Amount] } ) ON COLUMNS
FROM [Adventure Works]

Any help please?

Thanks.

Post #1339034

« Prev Topic | Next Topic »

Permissions