Do you ever get this error: Warning 5 Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: '', Column: '', Value: '12:00:00 AM'. The attribute is 'Date'. It turns out that this error occurs because: Null values in the fact table relationship are converted to '12:00 A.M.' So I … Continue reading Enabling the Unknown Member on a Dimension in SSAS.
It turns out that all the tips for Windows 7 and 8 rely on assumptions that are not valid in Windows Server 2012. See here for some good Win 8 tips: Removing Windows.old from Windows 8 For Windows Server 2012, I eventually figured out this kludge to get rid of the 16GB Windows.old folder: Take … Continue reading Removing Windows.old folder in Windows 2012 R2
I love that no one told me the new BI Server for SharePoint was up. Grrr..... And, lo and behold, despite the requisition stating clearly that it needed Windows 2012 on it, I still got Windows 2008. Aahhh! I fixed that with an in-place upgrade to Windows 2012 R2. Hopefully, that won't bugger it … Continue reading New BI SharePoint Server Showed Up