blogs.conchango.com

I have recently been working on a project implementation that incorporated SQL Server Analysis Services (SSAS) and there was a requirement to be able to create partitions on-the-fly from our ETL process running on SQL Server Integration Services (SSIS). I looked into using XML for Analysis (XMLA) to do this but after some trial and error decided ...

On my current project I am implementing SQL Server Analysis Services (SSAS) and recently I was having a problem doing a full process of my cube. I've got many many measure groups in the cube each containing twelve partitions and the cube process was hanging due to lack of resource issues on the Analysis Server. Those issues needed sorting ...

Project REAL is a Microsoft led initiative to build an end-to-end demonstrable BI solution on SQL Server 2005 BI tools (i.e. SSIS, SSAS, SSRS). A paper has been released documenting the experiences gained whilst building the ETL portion of this project using SSIS. Its 61 printed pages of text and screenshots which is hard going in anyone's book ...