Browse by Tags

All Tags » SSAS (RSS)
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 | with no comments
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:
03 December 2007 22:09

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

This post describes how to create a date / time measure in Analysis Services in order to calculate average elapse time. ...
Posted by DrJohn | 2 comment(s)
Filed under: