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: dimension
Quick Guide to BIDS Helper 1.4.3.0 for SSAS
BIDS Helper is an amazing free add-in for Business Intelligence Development Studio (BIDS). You can obtain the add-in from the Codeplex website. The purpose of this posting is to provide a quick guide to version 1.4.3.0 Analysis Services (SSAS) functions. … Continue reading
Posted in Microsoft Business Intelligence
Tagged aggregation, aggregation design, calculation, cube, dimension, measure, perspective, roles
Leave a comment
Securing Dimension Data
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 36 The book’s diagrams on pages 733 and 734 illustrate what dimension and cell security do: Dimension security removes details and removes amounts from aggregations Cell security removes details, but does … Continue reading
Aggregation Design and Usage-Based Optimization
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 23 This chapter discusses managing and optimizing the aggregations. Again, the “cube” in SSAS is comprised of partitions within which are aggregations. The chapter starts with another discussion of dimensions. A relational reporting-style … Continue reading
Using SQL Server Integration Services to Load Data
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 22 This chapter discusses leveraging SQL Server Integration Services to load data into a cube. If you have Analysis Services you also have Integration Services, no additional licensing required. However, you may have … Continue reading
Posted in Analysis Services, Integration Services
Tagged dimension, optimization, partition, SSIS
Leave a comment
Dimension and Partition Processing
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 21 As this chapter claims at the outset, SSAS only stores information in two locations: dimension files and partition files. Chapter 20 had discussed the static description of these files, and this … Continue reading
Dimension-based MDX Calculations
Microsoft SQL Server 2008 Analysis Services Unleashed Book Review Chapter 13 In the previous chapter, the book outlines a highest pass wins rule for determining the order of cube calculations. This chapter introduces dimension-based calculations, which will override a cube calculation. … Continue reading
Measures and Multidimensional Analysis
Microsoft SQL Server 2008 Analysis Services Unleashed Book Review Chapter 7 This chapter, from some viewpoints, covers the heart of what people want from Analysis Services: measures. As the chapter mentions, the measure is the simplest dimension with only one attribute, Measure. … Continue reading
English