Message from MarkTab
After years of graduate education and even more years of professional experience (with SAS and Microsoft), I still find data mining an awesome and challenging topic. I use this blog to share my best tips and achievements learned sometimes through great struggle. Today, I provide data mining advice to leading companies and industries in the United States and around the world. I share my journey and insights at leading conferences like SAS Global Forum, Microsoft TechEd, and Predictive Analytics World.
As I continue learning, my hope is to inspire you to not just learn more but also apply mathematics through technology. Data mining is a powerful tool for leaders of leaders of leaders. If you like this blog, click the "About" page to find out how to go deeper. -- Mark Tabladillo ("MarkTab")- by
Tag Archives: MDX
Architecture of Query Execution — Calculating MDX Expressions
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 29 This chapter starts with a claim which should make everyone happy: “Optimization of MDX calculations was one of the most important goals of Analysis Services 2008.” (page 527) This focus on MDX performance … Continue reading
Extending MDX with Stored Procedures
Microsoft SQL Server 2008 Analysis Services Unleashed Book Review Chapter 14 This chapter shows how to extend the native commands within Analysis Services using either managed code assemblies or COM assemblies. I will assume knowledge of assembly creation with either COM or .NET … Continue reading
Posted in Analysis Services
Tagged assembly, COM, DMX, MDX, regular expressions, VS2010
Leave a comment
Cube-Based MDX Calculations
Microsoft SQL Server 2008 Analysis Services Unleashed Book Review Chapter 12 For this chapter I will summarize the key points: Use MDX scripts to create permanent calculated members, named sets, and assignments (page 191) Session-scope calculated members, named sets, and … Continue reading
Advanced MDX (for Analysis Services)
Microsoft SQL Server 2008 Analysis Services Unleashed Book Review Chapter 11 The chapter title is only “Advanced MDX” but this chapter focuses on MDX for Analysis Services. Other vendors have implemented MDX. This entire book part (III) shows how MDX works … Continue reading
MDX Concepts
Microsoft SQL Server 2008 Analysis Services Unleashed Book Review Chapter 10 We are now entering Part III of the book, using MDX to analyze data. MDX was a Microsoft invention, thus making me conclude that Microsoft wants to be a laguage inventor. This post may … Continue reading
English