Browse by Tags

SQL Server Analysis Services slicing and dicing

Published 27 January 8 6:8 AM | SSQA.net

I was going through Books Online in learning the concepts of slicing of data within Analysis Services for the new project that is upcoming, all these years I have basic knowledge of SSAS and with latest available features in SQL Server 2005 Analysis Services...

Filed under: sql server, performance, data mining, 2005, Analysis Services, slicing

SQL Server 2005 Best Practices Analyzer January 2008 update

Published 25 January 8 4:8 AM | SSQA.net

Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings...

Filed under: sql server, microsoft, download, best practices, 2008, ctp, analyzer, 2005, Analysis Services, extent, rtm

"Provider cannot be found" error when trying to run a MDX query?

Published 5 November 7 2:39 AM | SSQA.net

One of the Business user asked for the resolution for the error they are getting when running a MDX query against the Analysis Services database within their data mart. The error is "Provider Cannot be found", before going further on this error...

Filed under: sql server, mdx, databases, 2005, Analysis Services, adomd.net, feature pack, driver