Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag OLAP Rss

   Items 1 to 17 of 17   
 

Create First SSRS Report with SQL Server Analysis Services OLAP Cube

Mubin M. Shaikh outlines how to create SSRS Report on SSAS OLAP Cube. If you don't have much prior knowledge of SSRS, just follow the steps and to have your first report ready on OLAP Cube.  Read more...
Rating:  Rate this |   Briefcase | 10,827 reads

Columnstore Index Changes in SQL Server 2014

SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL Server 2014?  Read more...
By Edward Pollack 2014/07/24 | Source: SQLServerCentral.com | Category: columnstore indexes
Rating: |  Discuss |   Briefcase | 4,063 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 | 18,680 reads

Day 327: From Prototype to Production

In November of 2012, I embarked on a Quixotic attempt at building a BI prototype in 7 days. I dubbed the experiment ‘OLAP Sprint’...  Read more...
By Simon Doubt 2013/10/10 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 2,532 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,335 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,059 reads

Day 7 of The OLAP Sprint

The final day of Simon's journey to improve his OLAP knowledge and build a prototype cube.  Read more...
By Simon E Doubt 2012/11/16 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 975 reads

Day 6 of The OLAP Sprint

Day 6 brings security enhancements.  Read more...
By Simon E Doubt 2012/11/15 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 816 reads

Day 5 of The OLAP Sprint

Day 5, the first real day of the Summit. Amir Netz' session and a little cube work.  Read more...
By Simon E Doubt 2012/11/14 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 955 reads

Day 4 of The OLAP Sprint

Day 4 is the halfway point. Another pre-con, this one from Peter Myers that looks at Power View and Matrix reports.  Read more...
By Simon E Doubt 2012/11/13 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 1,088 reads

Day 3 of The OLAP Sprint

Day 3 was a pre-con on Business Intelligence.  Read more...
By Simon E Doubt 2012/11/12 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 1,538 reads

Day 2 of the OLAP Sprint

Day 2 brings some initial work and a weather forecast.  Read more...
By Simon E Doubt 2012/11/09 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 1,541 reads

Day 1 of The OLAP Sprint

Day 1 of Simon's journey to build an OLAP solution in a week.   Read more...
By Simon E Doubt 2012/11/08 | Source: SQLServerCentral.com | Category: olap
Rating: |  Discuss |   Briefcase | 3,101 reads

The OLAP Sprint

The OLAP Challenge at the PASS Summit. Read about the plan and preparations.  Read more...
By Simon E Doubt 2012/11/07 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 881 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 | 18,680 reads

Parameter Support Objects, Pt II: Support OLAP Parameter Defaults with Datasets

Join BI Architect Bill Pearson as he continues his examination of parameterization within Analysis Services reports. In this article, we provide a solution for supporting parameter defaults that represent the last periods of data entry within our cube.  Read more...
By Additional Articles 2008/02/14 | Source: Database Journal | Category: olap
Rating: (not yet rated)  Rate this |   Briefcase | 1,352 reads

A Reporting System Architecture

This article describes one method of implementing a reporting system in SQL Server 2005  Read more...
Rating: |  Discuss |   Briefcase | 12,751 reads
   Items 1 to 17 of 17   
 
Tags
analysis services (ssas) (4)    
cube (3)    
dimensions (3)    
hierarchy (3)    
mdx (3)    
career (2)    
reporting services (ssrs) (2)    
columnstore indexes (1)    
data warehouse (1)    
database mirroring (1)    
extract, transform, load (etl) (1)    
indexing (1)    
integration services (ssis) (1)    
oltp (1)    
rdbm (1)    
report (1)    
snapshot (1)    
sql server 2005 (1)    
sql server 2014 (1)