Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Calculated Members - How to compare values of selected month of Year A with values of same Month of Year B Expand / Collapse
Author
Message
Posted Monday, July 30, 2012 4:40 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 6:22 AM
Points: 574, Visits: 800
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
Posted Thursday, August 2, 2012 3:37 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 6:22 AM
Points: 574, Visits: 800
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 »

Add to briefcase

Permissions Expand / Collapse