Sacha Tomey's blog

Molding the Microsoft BI Stack

Browse by Tags

All Tags » MDX (RSS)
PEL Business Rule Re-use and Pre-defined What If Scenarios
You’ve built a rule set to satisfy an original set of business requirements for calculating budget, and all is good with the world. Then, a change order is raised and approved that requires, for want of a better description, a set of pre-defined what...
MDX Stored Procedures (Part 2)
What seems like a lifetime ago I posted about MDX Stored Procedures and how we've built a helper class that provides a wrapper to an MDX query. The helper class has been stable for quite sometime now and a few people have been asking me when I'm...
Basket Analysis using Analysis Services 2005
My job is pretty varied these days :o) Today I've been looking at satisfying some basket analysis type requirements where, for example, we need to determine what other products customers have bought in addition to a known product. We could have used...
MDX Stored Procedures (Part 1)
UPDATE: You can find part 2 here , along with a link to download a C# quick start. A long time ago I realised that inevitably, however well specified the requirements or however tight the deadlines are, clients always throw a curve ball. To that avail...
XML Namespaces and the ADOMD XML Reader Result Set
I'm building a generic helper class to flatten an ADOMD data set to a data table for easier consumption by default and third party .NET controls. I can't rely on the Load method of the data table, nor the CellSet object as in some cases not all...