Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Wednesday, March 9, 2011 4:34 AM



Group: General Forum Members
Last Login: Wednesday, November 9, 2016 10:50 PM
Points: 144, Visits: 603
Issue with Parallel Period


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'.

([DATE].[Year Month].[Year Month], 1, [DATE].[Year Month].&[201101])

Not sure how to implement this . Kindly advise.
Post #1075438
Posted Wednesday, March 9, 2011 5:46 AM



Group: General Forum Members
Last Login: Today @ 5:18 AM
Points: 45,619, Visits: 44,147
Please don't cross post. It just wastes people's time and fragments replies

No replies to this thread please. Direct replies to

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

Post #1075466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse