I installed a copy of SQL server 2008 Express. I can see SQL Agent from the Server Configuration Manager, but I can't start it - get error. Any fix? Cheers
As I understand the "unknown member" means that the dimension key is not found in the fact table. In my case, the dimension table IS the fact table. Does anyone know why is the unknown member represented in my dimension?
I am using Microsoft Dynamics GP Analysis Services on SQL Server 2005. I am using Microsoft Office Excel Add-in for SQL Server Analysis Services for fetch data. The problem I am facing is that besides real data it is also showing Unknown as an additional member in almost every ...