syedathariqbal (3/9/2011)
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.
Your first parameter ParallelPeriod
([DATE].[Year Month].[Year Month], 1, [DATE].[Year Month].&[201101]))
should be something like "Month" depending on the way you have your hierarchies set up.