Showing posts with label fairly. Show all posts
Showing posts with label fairly. Show all posts

Wednesday, March 28, 2012

Migrating cubes from SQL Server Analysis Services 2000 to MS SSAS 2005

Hello

I am fairly new to SQL Server and wanted to know the best way of converting a .CAB cube created in SSAS 2000 to SSAS 2005 and then associate it with a database.

Rgds

Ankur

Backups done in AS2000 cannot be restored in AS2005. Your best course of actions is to restore the .cab backup on AS2000 system, and then migrate it to AS2005 system.

Friday, March 9, 2012

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException

Getting an error "Microsoft.ReportingServices.Report
Processing.ReportProcessingException" when trying to run a report with
a fairly large amount of data. Encountering this error quite often.
I changed the memory limit in the RSReportServer Configuration file to
120, but I am still getting this error.It could as well be a timeout issue.
Try changing the SQLCommandTimeoutSeconds to a higher
value.
>--Original Message--
>Getting an error "Microsoft.ReportingServices.Report
>Processing.ReportProcessingException" when trying to run
a report with
>a fairly large amount of data. Encountering this error
quite often.
>I changed the memory limit in the RSReportServer
Configuration file to
>120, but I am still getting this error.
>.
>