Welcome to EMC Consulting Blogs Sign in | Join | Help

Welcome to EMC Consulting Blogs

Christian Wade's Blog

Analysis Services 2005 (RSS)

Analysis Services 2005

Databind ChartFX to OLAP Datasource

I’ve just gone through an informal and limited evaluation process for a charting tool for a BI dashboard. It included some of the RS extension products, ProClarity and ChartFX. Of course I would have been keen to use ProClarity, but in this case Read More...

Posted 08 November 2006 17:51 by christian.wade | 1 Comments

Filed under: Analysis Services 2005, ASP.NET V2, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, .NET, ChartFX, Dashboard, Databind, Databinding

Currency Conversion in Analysis Services 2005

I recently investigated currency conversion in SSAS for a customer. I found that there is not much on the web in the way of examples. Here is an attempt to correct that. First thing to do: figure out what type of currency conversion you need. There are Read More...

Posted 24 August 2006 16:23 by christian.wade | 5 Comments

Filed under: Analysis Services 2005, MDX, Foreign Currencies, AS2005, SQL Server 2005, Currency Conversion, AS, Yukon, Measure Expressions, SQL Server, Analysis Services, SSAS, Locale ID, Currency Locale

Analysis Services Stored Procedure Project

Jon Axon, Chris Webb , Mosha Pasumansky , Greg Galloway, Darren Gosbell (and I although not as much as these guys!) have released some very interesting and useful MDX sprocs. Check out http://www.codeplex.com/Wiki/View.aspx?ProjectName=ASStoredProcedures Read More...

Posted 14 August 2006 14:52 by christian.wade | 0 Comments

Filed under: Analysis Services 2005, MDX, AS2005, AS, SQL Server, Analysis Services, SSAS, MDX Stored Procedures

Measure expressions: how performant are they?

Oh, and before the anoraks out there mail me saying “did you know that ‘performant’ is not recognized as an adjective by the major dictionaries?”, yes I do know – but I like the word, so I’m using it! We are modeling Read More...

Posted 25 July 2006 17:36 by christian.wade | 2 Comments

Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, Measure Expressions, SQL Server, Analysis Services, SSAS

Fact modelling and M2M dimensions in AS2005

It is generally considered data warehousing best practice to split your facts into different tables if the granularity/dimensionality is different. This is a very common question in data warehouse design. Consider the following data model. The company Read More...

Posted 25 July 2006 14:32 by christian.wade | 0 Comments

Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, Dimensional Modelling, Dimensional Modeling

AS 2005 Optimization Experiences

I’m approaching the end of an enjoyable data warehousing project and we have collected some size/volume statistics around our Analysis Services 2005 cube. We have: * 48 Dimensions. This includes role-playing dimensions. * 751 Attributes and user Read More...

Posted 12 July 2006 17:28 by christian.wade | 2 Comments

Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, Dimensional Modelling, Dimensional Modeling

MDX Script: Current/Relative Period

There are differing approaches out there on how best to get a current period member in MDX. It is often a requirement to show, for example, [Current Month] and [Current Month - 1] members side by side and then perform comparison calculations between the Read More...

Posted 23 June 2006 12:14 by christian.wade | 0 Comments

Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS

Attachment(s): Current-Relative Date.zip

MDX Sprocs and Scripting: An Interesting Example

A colleague of mine once asked me to do a “Number of Days since Last Incident” calculated measure (sounds like fun!). Basically, he had a measure called Incidents and wanted a running count of days since the last incident. E.g. Date Incidents Read More...

Posted 30 April 2006 11:15 by christian.wade | 0 Comments

Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, MDX Stored Procedures, .NET

Attachment(s): Recursive MDX Sprocs.zip

MDX Sprocs: Usage

I am naturally interested in MDX stored procs so I tried them out. I have often wondered how they compare to SQL CLR. I hereby commit myself to (trying to) do a few blog posts in this space! Here are some findings regarding when to use them. It is well Read More...

Posted 30 April 2006 11:05 by christian.wade | 4 Comments

Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, MDX Stored Procedures, .NET

UDM, New Dimension Types and Analysis Services 2005

One of the key goals of Analysis Services 2005 is to “bring together the best of both relational and OLAP reporting into a single Unified Dimensional Model”. This is a very ambitious goal and most would agree that it would be difficult to Read More...

Posted 07 April 2005 16:21 by christian.wade | 4 Comments

Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, Dimensional Modelling, Dimensional Modeling, UDM

Semi-Additive Measures in Analysis Services 2005

The new aggregation functions provided out-of-the-box with Analysis Services 2005 are fairly well publicised, but I feel they still warrant a blog post. Analysis Services 2000 only had Sum, Count, Min, Max and DistinctCount. Analysis Services 2005 also Read More...

Posted 07 April 2005 16:06 by christian.wade | 3 Comments

Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, UDM, Semi Additive Measures, Semi-Additive Measures

Distinct Count in Analysis Services 2005

A problem with the DistinctCount aggregate function for measures in Analysis Services 2000 is that it will not aggregate at leaf level if filtering only on a subset of the members in a level (or attribute). A customer or ours is all too familiar with Read More...

Posted 03 April 2005 13:16 by christian.wade | 2 Comments

Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, UDM, Distinct Count

Unknown Member and Analysis Services 2005

I once wrote an add-on for the SQL Server Accelerator for Business Intelligence to provide unknown-member functionality. I was therefore naturally interested when I heard that it comes out-of-the-box with Analysis Services 2005. The idea with the unknown Read More...

Posted 01 April 2005 17:59 by christian.wade | 8 Comments

Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, Dimensional Modelling, Dimensional Modeling, UDM, Unknown Member

This Blog

Syndication

News

We're looking for great BI guys and .Net developers. Fancy working on some of the best projects in the UK and beyond? If so contact me by my contact page and I'll put in a good word for the right candidate!