blogs.conchango.com

I've been wrestling with MDX in PerformancePoint today and was attempting to do something that I thought would be pretty simple. Work out what is the current quarter. No amount of googling turned anything up either. It took me a while to figure out so I thought I'd post it up here in case I need it again or if anyone else ever needs it. ...

I suspect that many of you have already come across this in your day to day MDX'ing but just in case: The standard YTD function only works with the Year level of Time hierarchies when the Attribute Type is set in the Basic Properties section to type Years. If you have a Fiscal Hierarchy in your Time dimension and have the Type set to ...

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 the cost was a little high and, to be honest, it would have been a sledgehammer to ...

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 3 types.MANY-TO-MANY.  This is where the facts are stored in multiple ...

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 Enjoy!  

 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 the business of the Multi-Dimensional Parcel Service (MDPS). They ship parcels ...

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 traditionally sells its products through sales people visiting customer ...

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 hierarchies (!).  So if a dimension has 5 attributes and 2 user hierarchies, ...

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 two.  This allows OLAP reports to dynamically refresh the numbers when a new period ...

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        ...