Sign in
|
Join
|
Help
Sparks from the Anvil
Applied business intelligence
This Blog
Home
Contact
About
Syndication
RSS
Atom
Comments RSS
Search
Go
Navigation
Home
Blogs
Forums
Photos
Downloads
Tags
.NET
Aspose.Cells
C#
MDX
MOSS
SSAS
SSIS
T-SQL
VB.NET
Web Service
Recent Posts
MDX + T-SQL: Combining relational and multi-dimensional data into one query result set
Goodbye Vista: Installing Windows Server 2008 on a Dell XPS laptop
Busting for a Wii at SQL Bits
SSAS Stored Procedures - connecting to the transactional data source
The FACT is that it is not so DIM after all
Archives
September 2008 (3)
April 2008 (2)
December 2007 (1)
November 2007 (6)
Browse by Tags
All Tags
»
SSAS
(
RSS
)
C#
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:
SSAS
,
C#
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:
SSAS
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:
SSAS