Welcome to EMC Consulting Blogs

Browse by Tags

• .NET
• @@Identity
• Analysis Services
• Analysis Services 2005
• AS
• AS2005
• ASP.NET V2
• ChartFX
• Currency Conversion
• Currency Locale
• Dashboard
• Databind
• Databinding
• Dimensional Modeling
• Dimensional Modelling
• Distinct Count
• DML with output
• Foreign Currencies
• Locale ID
• MDX
• MDX Stored Procedures
• Measure Expressions
• OPEN XML
• OPENXML
• recursive
• SCOPE_IDENTITY
• Semi Additive Measures
• Semi-Additive Measures
• sp_xml_preparedocument
• SQL
• SQL CLR
• SQL Server 2005 - Relational
• SQL-CLR
• SSAS
• TSQL
• UDM
• Unknown Member
• XML
• 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

• SQL Server Standard - Recursive Hierarchies to XML

  I wrote an article for the September 2006 issue of SQL Server Standard magazine: The version that was finally published was a very cut down version with minimal code snippets. This was for obvious reasons; they had to fit the content onto small columns Read More... Posted 20 September 2006 15:21 by christian.wade | 2 Comments Filed under: SQL Server 2005 - Relational, SQL-CLR, SQL Server 2005, Yukon, SQL Server, .NET, XML, SQL CLR, SQL, TSQL, recursive

• Currency Conversion in Analysis Services

  This article was originally written for Analysis Services 2005, but everything still applies today even for Analysis Services 2012 in Multidimensional mode. First thing to do: figure out what type of currency conversion you need. There are 3 types. MANY-TO-MANY Read More... Posted 24 August 2006 16:23 by christian.wade | 11 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

• 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 | 4 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: AS, Yukon, SQL Server, Analysis Services, SSAS, Analysis Services 2005, MDX, AS2005, SQL Server 2005 Attachment(s): Current-Relative Date.zip

• Nice use of DML with output: update a collection in 1 db round trip

  I’ve seen a few Conchango developers in the past use sp_xml_preparedocument and OPENXML to commit a serialized collection object to the database. We can do this in SQL Server 2000 and it avoids a round trip to the database for each collection member. Read More... Posted 05 May 2006 13:25 by christian.wade | 1 Comments Filed under: SQL Server 2005, Yukon, SQL Server, OPENXML, OPEN XML, sp_xml_preparedocument, .NET, XML, DML with output, @@Identity, SCOPE_IDENTITY

• 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