InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 03:26:35 GMT20http://www.sqlservercentral.com/Forums/Topic1075440-1633-1.aspx[quote][b]syedathariqbal (3/9/2011)[/b][hr]Issue with Parallel PeriodHi,I have a SSRS report, based on Cube, where a table shows information for Employees. The report has a table.Col1 - YearMonth, Col2 - Emp_ID, Col3 - Organisation Unit, and few more columns.All I need to do is get to know which Organisation Unit they belong to in previous month and add this information as an additional column.I want something like below and using With Member create a extra field in the Dataset for the table and create a extra column 'PrevMonthOrganistaion'.[EMPLOYEE].[ORG UNIT],ParallelPeriod ([DATE].[Year Month].[Year Month], 1, [DATE].[Year Month].&[201101]))Not sure how to implement this . Kindly advise.[/quote]Your first parameter ParallelPeriod [b]([DATE].[Year Month].[Year Month][i][u][/u][/i][/b], 1, [DATE].[Year Month].&[201101]))should be something like "Month" depending on the way you have your hierarchies set up.Wed, 09 Mar 2011 08:19:16 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1075440-1633-1.aspxIssue with Parallel PeriodHi,I have a SSRS report, based on Cube, where a table shows information for Employees. The report has a table.Col1 - YearMonth, Col2 - Emp_ID, Col3 - Organisation Unit, and few more columns.All I need to do is get to know which Organisation Unit they belong to in previous month and add this information as an additional column.I want something like below and using With Member create a extra field in the Dataset for the table and create a extra column 'PrevMonthOrganistaion'.[EMPLOYEE].[ORG UNIT],ParallelPeriod ([DATE].[Year Month].[Year Month], 1, [DATE].[Year Month].&[201101]))Not sure how to implement this . Kindly advise.Wed, 09 Mar 2011 04:36:27 GMTsyedathariqbal