SSRS 2008 Report on Cube - Issue using Parallel Period

  • Issue with Parallel Period

    Hi,

    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.

  • syedathariqbal (3/9/2011)


    Issue with Parallel Period

    Hi,

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply