Enabling the Unknown Member on a Dimension in SSAS.

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.

BI Data Source – SSAS

Well now.  It turns out that PerformancePoint for SharePoint has quite a few nifty little features (after reading the help topics on the blank PerformancePoint site), but to work with it properly I need to have some data in a SQL Server Analysis Services (SSAS) Cube.  Since we are still in the stone ages and … Continue reading BI Data Source – SSAS