Sparks from the Anvil - All Comments

re: SSIS: Deploying OLAP cubes using C# script tasks and AMO

netsmurph — Sun, 13 Nov 2011 23:21:22 GMT

This is really useful, I have found the Deployment wizard frustrating since you need to manually go into the UAT script to make the required changes, which in itself introduces a possibility of user error (were not perfect are we!).

I was hoping to use your script but the one issue that i need to address is that my UAT and PRD environments are on separate domains (not my design), so have different Windows groups for each. Therefore I need to retain the roles when deploying cube database.

I will have a dig and see if/how easily this can be achieved, perhaps adding it as a boolean variable into your package (retainRoles (Y/N).

Errors in the high-level relat - Windows 8 Guide | Server 2008 | Sql Servers | Tutorial

Thu, 16 Jun 2011 03:18:48 GMT

Pingback from Errors in the high-level relat - Windows 8 Guide | Server 2008 | Sql Servers | Tutorial

Handling Fact data that spans a time period - Windows 8 Guide | Server 2008 | Sql Servers | Tutorial

Fri, 10 Jun 2011 09:58:28 GMT

Pingback from Handling Fact data that spans a time period - Windows 8 Guide | Server 2008 | Sql Servers | Tutorial

Building a Dynamic OLAP Environment at #SQLbits8

Sparks from the Anvil — Mon, 11 Apr 2011 15:54:10 GMT

On Saturday I attended the SQLBits conference in sunny Brighton. Great conference, well organized with

re: SSAS: Kerberos kills ‘large’ MDX queries on Windows Server 2008

samikane — Tue, 22 Mar 2011 20:18:30 GMT

Here are this and some other articles on Analysis Services and Kerberos:

<a href="ssas-wiki.com/.../Articles

ssas-wiki.com/.../Articles

re: SSAS: Working with date and time measures to calculate average elapse time

samikane — Tue, 22 Mar 2011 16:07:57 GMT

Here are this and some other articles on SSAS Date Dimension

<a href="ssas-wiki.com/.../Articles

ssas-wiki.com/.../Articles

SSAS 2008 Deployment: The connection either timed out or was lost

Rob Kerr's Microsoft Business Intelligence Blog — Mon, 28 Feb 2011 16:33:53 GMT

SSAS 2008 Deployment: The connection either timed out or was lost

Rob Kerr's Microsoft Business Intelligence Blog — Mon, 28 Feb 2011 16:33:53 GMT

SSAS 2008 Deployment: The connection either timed out or was lost

Rob Kerr's Microsoft Business Intelligence Blog — Mon, 28 Feb 2011 16:33:52 GMT

SSAS 2008 Deployment: The connection either timed out or was lost

re: SSAS Stored Procedures - connecting to the transactional data source

samikane — Wed, 23 Feb 2011 19:43:57 GMT

Here are some other articles on SSAS Stored Procedures: ssas-wiki.com/.../Articles