SQLServerCentral.com Articles tagged Cube

MDX Guide for SQL Folks: Part III - Advanced Analysis

Thu, 14 Feb 2013 07:00:00 UT

Learn everything about MDX drawing only on your T-SQL knowledge in this series. Frank Banin continues talking about Calculated Members, Named Sets, and more in part III.

MDX Guide for SQL Folks: Part II - Hierarchies and Functions

Tue, 18 Dec 2012 07:00:00 UT

Learn everything about MDX by drawing only on your SQL knowledge.

MDX Guide for SQL Folks: Part I - Navigating The Cube

Thu, 01 Nov 2012 06:00:00 UT

Learn all you need to know about MDX, by drawing only on your current SQL knowledge.

Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause

Wed, 22 Aug 2012 06:00:00 UT

In this article I will be expanding on my discussion of the GROUP BY clause by exploring the ROLLUP, CUBE and GROUPING SETS operators. These additional GROUP BY operators make it is easy to have SQL Server create subtotals, grand totals, a superset of subtotals, as well as multiple aggregate groupings in a single SELECT statement.

Managing Data Dictionaries in DW and DSS Database Applications

Tue, 20 Dec 2011 07:00:00 UT

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.

Process Dimensions in an Analysis Service database

Wed, 11 Mar 2009 06:00:00 UT

Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.