It's a guess but i'd say the datatype of your tblReferralTransferStatus.DateModified is a varchar not a datetime, so RS has provided you with the appropriate data entry control for varchar...

Hi Tiago,

Quick question on when you forced the MaxParallel, why did you set it to one?  You'd need to set it to >=2 to see any parallelism?

Have you also read...

It's been a while but with ASCMD you supply an xmla command file?  If yes, then have you set the degree of paralellism you want to run under?  Same with...

Not sure on #2 (i need to go back and look at the vst again) but I think #1 is covered in the readme -> ensure the help is in...

Forgot to mention Tom Chesters Excel documentor for As2K too, i think it's still available here.

Cheers,

There's definitely a post-creation documentor (I think from Aus, this is the link from a previous post).  If you're stuck with AS2K there used to even be a Word...

Hey Steve, it's off topic but you know the add *below* your editorial, for E2E Training?  I would love to learn a 'mythology' to follow for my AS projects!

have you looked at the following? http://support.microsoft.com/kb/922656

Remember, when using Visual Studio, changing from Debug to Release can mean different 'runtime' settings, so maybe check your project properties, see what...

Either use logging or tracing to review the query that AS is sending to SQL, most likely for the fact processing (but could be a larger dimension, you'd need to...

Your assumption is correct.  In each location that the UserName() function is being used (which returns your Username, hence the [machinename\administrator] reference in the errors), it's trying to string that...

Can you post the contents of the MDX script for the cube?  ie open it in dev studio, go to calculations, change to script mode (from form mode) and the...

I'm not sure on how you'd ensure it gets ordered correctly, maybe you could re-org it in Reporting Services.  But I would try using a combination of the GENERATE function...

I think this is available on OLAP datasources only in Office/Excel 2007.  This page indicates that Excel 2003 supports this functionality only for non OLAP sources.  This page...

Did you follow the link?

That link should take you directly to the SQL Server Analysis Services 2000 Operations Guide (or Ops Guide...

I knew I'd seen *something* *somewhere* --> try the Ops Guide.  This is a link directly to a sample script for changing the data dir -> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx#EPLAG  I would...