Leap Year issue with MDX date navigation


A few days ago (exactly one day after 29th of February when testing data from last night’s load) I experienced a strange issue which I couldn’t explain at first but then found out that it is related to the leap year and to the fact that even though this year has a 29th in FebContinue reading “Leap Year issue with MDX date navigation”

Default Member inconsistency


Issue Example is based on Adventure Works – SQL 2012 The user would like to browse the cube mainly for data related to the Accessories products so the default member of that attribute is set to: [Product].[Category].&[4] You have to make that modification in Adventure Works in order to test this behaviour! But as theContinue reading “Default Member inconsistency”