blogs.conchango.com

Browse by Tags

• .NET
• Analysis Services
• Analysis Services 2005
• AS2005
• ASP.NET V2
• ChartFX
• Currency Conversion
• Currency Locale
• Dashboard
• Databind
• Databinding
• Dimensional Modeling
• Dimensional Modelling
• Distinct Count
• Foreign Currencies
• Locale ID
• MDX
• MDX Stored Procedures
• Measure Expressions
• Semi Additive Measures
• Semi-Additive Measures
• SQL Server
• SQL Server 2005
• SSAS
• UDM
• Unknown Member
• Yukon

• 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 | 3 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, SSAS, Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server 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