RDA Corp - Business Intelligence and SQL Server

« November 2006 | Main | February 2007 »

January 17, 2007

SSAS: Creating a Scheduled Backup for an Analysis Services Database

A standard maintenance plan only pertains to the main SQL Server database engine. It does not include an option to backup an Analysis Services database. To do this, right click the AS database in Management Studio and select “Back up”. The backup dialog will appear.

Enter the proper settings (make sure you select Allow Overwrite as this is unselected by default). Once the settings have been entered, click on the Script button at the top of the dialog. This will create an XMLA file in the query window.

Next, create a new SQL Agent job. Add a new step and set this step to be an Analysis Services Command. Copy and paste the generated XMLA within the command text box. Save the job accordingly.

Share:  

Posted by Steve Mann at 4:45 PM | Comments (0)

January 15, 2007

SQL 2005 - Virtual Labs

SQL 2005 Virtual Labs that include Reporting Services, Report Builder, and Report Viewer controls.
http://msdn.microsoft.com/virtuallabs/sql/default.aspx

Share:  

Posted by Steve Mann at 9:47 AM | Comments (0)

Analysis Services Error in Calculation Tab

by Ray Barley


I recently built a cube using SQL Server 2005 Analysis Services and ran in to a problem. The Calculation tab in the project displays this text: Unexpected error occurred: 'Error in the application.' so I can't define any calculations.

I found the solution on the SQL Server Analysis Services forum on MSDN:
http://forums.microsoft.com/msdn/ShowPost.aspx?postid=1095184isthread=falseamp;siteid=1PageID=0

There are 2 DLLs msmdlocal.dll and msmgdsrv.dll in these folders:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
C:\Program Files\Common Files\System\Ole DB

The ones in the PrivateAssemblies folder are older versions so you copy the ones from the OLE DB folder to the PrivateAssemblies folder and the problem goes away.

In my case I know that I installed a SQL Server 2000 instance recently along with Office 2007 and this is the first time that I used Analysis Services since then so I think one of those might be the culprit.

Share:  

Posted by Steve Mann at 9:42 AM | Comments (0)

SSIS Naming Conventions / Best Practices from Jamie Thomson

Here's some useful links to SSIS naming conventions / best practices from the SSIS guru Jamie Thomson ...

http://blogs.conchango.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx

http://blogs.conchango.com/jamiethomson/archive/2006/11/08/SSIS_3A00_-Package-Naming-Conventions.aspx

Share:  

Posted by Steve Mann at 9:41 AM | Comments (0)

Removing SSRS from Sharepoint's Claws

After installing Reporting Services on the same machine as SharePoint, you must remove the Report Server paths from SharePoint's settings.

Here is the path to that area within Sharepoint:

SP Central Admin
Virtual Server Configuration
Configure virtual server settings
Virtual Server Management
Define managed paths

Share:  

Posted by Steve Mann at 9:38 AM | Comments (0)