I had a quick look through (ie not comprehensive) but it doesn't look like the ProcessingKeyErrorLimit value is set anywhere for the partition, so this would probably leave it at...

If you're inclined (and you have access to the VB6 dev environment) you could open the src folder in the install directory, open the project and then step through the...

Hey James,

No solution on offer but what you *could* try is have a trace start up before your cube processing run (by the proj server).  The trace log in AS2K5...

Hey Simon,

Are you looking to 'see the records' or more see the total value for all records that fall in that date range?  If it's the latter, I think you...

If you try this without crossjoining the measure and also mod your calculated member, it should work.  Maybe something like....

with

  member [Date].[sum1] as

'sum(LastPeriods(3,[Date].[Year].&[2006].&[200611]),[Measures].CURRENTMEMBER)'

select {LastPeriods(3,[Date].[Year].&[2006].&[200611]), [Date].sum1} on...

Assuming you mean Reporting Services 2000?  You can do it programmaticaly but you should also be able to go in through report manager (usually <A href="http:///reports">http://<installed_server>/reports ).  Select the report...

Hey big fella, how's things?

Although not in the UK but in virtual-land, have you looked through/taken any of the free (you can of course send me a check for the...

Were these DTS packages or SSIS packages?  If they were DTS packages and SQL2000 isn't installed, then why would you point the Upgrade Advisor to the local (SQL) server rather...

Sounds like you may be on track to getting it sorted.  Just for fun, take a look at this re: memory management.

Not sure if you've looked at it but...

I don't want to sound like a pain but here's a few thoughts I had on this last night...

Is your test report truly indicative of the reports you're looking to...

Am also curious about this issue.  When you say the report is 'large' just how many rows are you trying to retrieve?  What amount of formatting/logic is contained in the...

Hi user4301,

As I undertsand it, Excel 07 will be able to handle >65k rows, and more than 256 cols while we're talking about it, but it doesn't have anything to...

A possible (ie untested )approach could be to try and get a hierarchy in to your cube that has unary operators.  Using the...

If you're cube is currently in AS2000 then:

 - to take it to AS2005, use the Import Cube project type in the BI Dev Studio

 - to take it to another AS2000...

You should check out the paper from T.K. Anand on Drill Through in 2K5.  It gives a reasonable description of the differences in architecture between 2000 and 2005. 

Cheers,