Learning SSAS-Part IV: Deploying and Processing a cube Hello and welcome to the fourth part of this series dedicated to learning SQL Server Analysis Services. In the previous articles you learnt the basics of Analysis Services. I talked about data sources, data source views, diagrams, calculated columns etc. before actually building an OLAP cube based on a star schema using...
Tag: SQL Server Analysis Services
Learning SSAS: Part III- Building Cubes
Learning SSAS: Part III- Building Cubes Hello and welcome to the third part of this series dedicated to learning SQL Server Analysis Services. In the first article I talked about the basics of dimensional modeling and business intelligence. Also, the reader was acquainted with the jargon associated with data warehousing. In the second article the reader learnt few things about...
Learning SSAS-Part II: Data sources, Data source views
Learning SSAS-Part II: Data Sources, Data Source Views Welcome to the second part of the Learning SQL Server Analysis Services series. In the first article of the series you learnt the basics of business intelligence and data warehousing. You also understood about various terms like cube, dimension and facts. Now it is time to use this understanding and apply it...
Learning SQL Server Analysis Services: Part 1- Introduction
Learning SQL Server Analysis Services: Part 1- Introduction I recently decided to write about SQL Server Analysis Services and it didn’t take me long to realize that it will be a lot better to write a series of articles rather than making a mess of it in an all-in-one article. So, I am going to begin the series with an...