Thanks Des. You've pointed me to a possible solution.

Okay, in that case, I've modified the table script provided previously, so all the data appears on the same date. But there are two distinct groups to work with

Thanks for the tip with formatting query etc.
The only thing I have to go on is the Value/NextValue and whether it's InSequence or not, which I've already derived...

Date may come in useful but you can have several groups within the same date unfortunately.

Thanks for the reply. Looking at it, it's the only logical explanation that the datepart(ww... is returning the incorrect number.

I have checked the regional settings on the windows server and...

Yes, the "new" data is viewable in BIDS, in SSAS and when you create a new connection to the SSAS database via Excel. It is only some older reports that...

I've figured it out. A nested StrToMember (with the right syntax) worked:

WITH DYNAMIC SET [Test] AS

StrToSet

(

"

ParallelPeriod

(

[Finance Date].[Year-Week].[Week],

7,

StrToMember('[Finance Date].[Year-Week].[" + Cstr(datepart("yyyy",now())) + " Week " + Cstr(datepart("ww",now())) + "]')

)

"

)

SELECT {[Test]} ON...

Nevermind, I've figured it out.

Yes. We are running SQL2008R2 SP2 Enterprise Edition. We had applied SP2 on Thursday 22nd. Performance ground to a halt on Monday 26th. We rebuilt all statistics on this key...

Hi Grant, thanks for the reply. I have just double checked and it is not a filtered index.

NameUpdatedRowsRows SampledStepsDensityAverage key lengthString IndexFilter ExpressionUnfiltered Rows

_dta_stat_244664415_1_2_15_7_3_8Aug 29 2013 5:02PM4699995811024NO NULL46999958

Loundy (5/24/2013)

---

its unlikely to shrink while there is an active connection, try disabling the account that's connecting and try again. Ensure you are aware of the impact of doing...

Loundy (5/24/2013)

I've had this before when a process is using the DB I was trying to shrink. run an SP_who2\SP_whoisactive to find out what it is.

However, do you actually...

Jeff Moden (11/6/2012)

---

Be real careful using the single user mode. If YOU lose, drop, or close your connection, on of the Web Services will grab the single connection almost...

Thanks for the suggestion but that's not possible, as Server is hosted at a remote site.