Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Cube Rss

   Items 1 to 9 of 9   
 

Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask

There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the other hand, CUBE and ROLLUP remain mysterious despite their usefulness and GROUPING SET is positively arcane, especially if you are too shy to reveal your ignorance of the subject by asking! William Brewer saves you the hassle.  Read more...
By Additional Articles 2015/11/17 | Source: SimpleTalk | Category: cube
Rating: (not yet rated)  Rate this |   Briefcase | 3,815 reads

Data Mining Part 27: Microsoft Data Mining with Cubes

In the chapter 26 we created a cube. Now, we are going to create the Data Mining Model from it.  Read more...
By Daniel Calbimonte 2015/04/27 | Source: SQLServerCentral.com | Category: ssas
Rating: |  Discuss |   Briefcase | 3,422 reads

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

Learn all you need to know about MDX, by drawing only on your current SQL knowledge.   Read more...
By Frank A. Banin 2014/06/13 (first published: 2012/11/01) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 20,402 reads

MDX Guide for SQL Folks: Part III - Advanced Analysis

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.  Read more...
By Frank A. Banin 2013/02/14 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 5,619 reads

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

Learn everything about MDX by drawing only on your SQL knowledge.   Read more...
By Frank A. Banin 2012/12/18 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 7,451 reads

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

Learn all you need to know about MDX, by drawing only on your current SQL knowledge.   Read more...
By Frank A. Banin 2014/06/13 (first published: 2012/11/01) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 20,402 reads

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

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.  Read more...
By Gregory Larsen 2012/08/22 | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,026 reads

Managing Data Dictionaries in DW and DSS Database Applications

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.  Read more...
By Frank A. Banin 2011/12/20 | Source: SQLServerCentral.com | Category: bi
Rating: |  Discuss |   Briefcase | 5,524 reads

Process Dimensions in an Analysis Service database

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.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,657 reads
   Items 1 to 9 of 9   
 
Tags
analysis services (ssas) (4)    
dimensions (4)    
hierarchy (3)    
mdx (3)    
olap (3)    
amo (2)    
rollup (2)    
bi (1)    
c# (1)    
data dictionary (1)    
data mining (1)    
extended properties (1)    
grouping set (1)    
grouping sets (1)    
integration services (ssis) (1)    
model (1)    
powershell (1)    
rdbm (1)    
ssas (1)    
stairway series (1)    
t-sql (1)    
xml (1)    
xmla (1)    
xquery (1)