Post reply

SSRS 2008 Report on Cube: Issue using Parallel Period

  • March 9, 2011 at 4:34 am

    #234951

    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.

  • March 9, 2011 at 5:46 am

    #1296429

    Please don't cross post. It just wastes people's time and fragments replies

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1075440-1633-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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