Browse by Tags

All Tags » SSAS (RSS)
15 March 2012 13:05

SSAS: Utility to check you have the correct data types and sizes in your cube definition

This blog describes a tool I developed which allows you to compare the data types and data sizes found in the cube’s data source view with the data types/sizes of the corresponding dimensional attribute. Why is this important? Well when creating named...
Posted by DrJohn | 1 comment(s)
Filed under: ,
24 February 2012 14:19

SSAS: Utility to export SQL code from your cube's Data Source View (DSV)

When you are working on a cube, particularly in a multi-person team, it is sometimes necessary to review what changes that have been done to the SQL queries in the cube's data source view (DSV). This can be a problem as the SQL editor in the DSV is...
Posted by DrJohn | 1 comment(s)
Filed under: ,
11 April 2011 16:42

Building a Dynamic OLAP Environment at #SQLbits8

On Saturday I attended the SQLBits conference in sunny Brighton. Great conference, well organized with lots of great speakers presenting high quality content. For me the highlight was meeting many of the senior guys from the Redmond SQL Server product...
Posted by DrJohn | with no comments
Filed under: ,
07 February 2011 18:07

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

As part of the continuing series on Building dynamic OLAP data marts on-the-fly , this blog entry will focus on how to automate the deployment of OLAP cubes using SQL Server Integration Services (SSIS) and Analysis Services Management Objects (AMO). OLAP...
Posted by DrJohn | 1 comment(s)
Filed under: , , , ,
06 February 2011 08:32

Building dynamic OLAP data marts on-the-fly

At the forthcoming SQLBits conference , I will be presenting a session on how to dynamically build an OLAP data mart on-the-fly. This blog entry is intended to clarify exactly what I mean by an OLAP data mart, why you may need to build them on-the-fly...
Posted by DrJohn | 3 comment(s)
Filed under: , , ,
18 July 2009 16:28

SSAS: Microsoft release fix for “Kerberos killing MDX” issue

In a previous post I reported how small MDX queries worked fine when client and server were Windows Vista/Windows Server 2008 but large MDX queries died due to the connection been forcibly closed by the transport layer. It turned out that this issue was...
Posted by DrJohn | 1 comment(s)
Filed under: ,
28 March 2009 23:05

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

Kerberos kills MDX queries on Windows Server 2008 / SQL Server 2008 implementations...
Posted by DrJohn | 9 comment(s)
Filed under: ,
17 November 2008 13:53

SSAS writeback error was ‘an accident with a contraceptive and a time machine’

Those of you that heard the hit radio series 'The Hitchhikers Guide to the Galaxy' or read Douglas Adams' book will recognise the title of my blog entry as been the reason quoted by Zaphod when asked to explain why he was Zaphod Beeblebrox...
Posted by DrJohn | 1 comment(s)
Filed under:
23 April 2008 14:17

SSAS Stored Procedures - connecting to the transactional data source

There are often circumstances where an SSAS stored procedure needs to connect to the transactional database to perform a query. This is certainly the case in a near-real-time OLAP solution where the cube sits directly on top of the application database...
Posted by DrJohn | 1 comment(s)
Filed under: ,
22 April 2008 06:13

The FACT is that it is not so DIM after all

I have always looked down upon the Fact and Dim prefixes applied to the tables within the AdventureWorksDW database with derision. "Why," I asked myself, "would anyone feel the need to use such prefixes? Clearly this is BI for dummies."...
Posted by DrJohn | 2 comment(s)
Filed under: