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

Content with tags Analysis Services (SSAS), T-SQL Rss

   Items 1 to 4 of 4   

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's 
By Theo Ekelmans 2013/03/28 | Source: | Category: automatic
Rating: |  Discuss |   Briefcase | 1,525 reads

Analytic Enhancements in SQL Server 2012 - Part II

The introduction of the new analytic functions in the RTM version of SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE, with the improved over clause, greatly facilitate the analysis on ordered data sets, such as time-series data. Read on to learn more.  Read more...
By Additional Articles 2012/04/25 | Source: Database Journal | Category: sql server 2012
Rating:  Rate this |   Briefcase | 3,073 reads

Improving Cube Performance with Precalculated Aggregations

A step by step example of how to add pre-calculated closing balances through T-SQL and semi-additive measures from Johan Åhlén.  Read more...
By Johan Åhlén 2009/11/04 | Source: | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 5,983 reads

New MDX Book Published

Fast Track to MDX gives readers all the necessary background information needed to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop MDX skills to the point where a reader can solve real business problems. A CD containing examples from within the book, and a time-limited version of ProClarity, is included  Read more...
By Additional Articles 2003/05/01 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,292 reads
   Items 1 to 4 of 4   
advanced querying (1)    
automatic (1)    
backup (1)    
closing balances (1)    
data warehousing (1)    
database (1)    
inventory problem (1)    
lag (1)    
lead (1)    
miscellaneous (1)    
programming (1)    
semi-additive measures (1)    
sql server 2012 (1)