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

SSRS 2008 Report on Cube - Issue using Parallel Period Expand / Collapse
Author
Message
Posted Wednesday, March 9, 2011 4:36 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 7, 2014 7:17 AM
Points: 108, Visits: 448
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.
Post #1075440
Posted Wednesday, March 9, 2011 8:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:41 AM
Points: 2,818, Visits: 2,552
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.
Post #1075592
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse