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

Content with tags Blogs, Analysis Services (SSAS) Rss

   Items 1 to 18 of 18   
 

SSAS Joining Facts at Different Granularities

In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example,...  Read more...
By MikeDavis 2013/07/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,065 reads

Analysis Services Webinar Recording and Q&A

I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013.  If...  Read more...
By Devin Knight 2013/04/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,007 reads

Backups in SQL Server Analysis Services

Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics. Using the GUI:...  Read more...
By 2012/07/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,575 reads

What happens when a SSAS Tabular model exceeds memory?

If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database...  Read more...
By 2012/05/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,917 reads

Being careful in SSAS to not make a cube/dimension unprocessed

A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes...  Read more...
By 2012/05/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,879 reads

MDX Performance - burdens of IIF

I used to think naively that IIF is an innocent little function that can only do good and help me...  Read more...
By aedna-843346 2011/02/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,204 reads

SSAS Dimension Attribute Discretization Methods

Discretization (one of my favorite tech words to say J) is a really great feature of Analysis Services that is...  Read more...
By 2011/01/31 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,882 reads

Creating Analysis Services Partitions Using BIDS

As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one...  Read more...
By Brian K. McDonald 2010/11/02 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,128 reads

Using SSAS MDX Calculation Color Expressions

Analysis Services calculations are great for storing formulas that your users need to see on a regular basis.  They also...  Read more...
By 2010/03/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,304 reads

Development Lifecycle Deployment SSAS, SSRS, SSIS

Many companies have a very rigid development lifecycle for all products or solutions they develop.  Deploying to each of these...  Read more...
By Devin Knight 2010/02/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,501 reads

Performing SSAS Database Backup

In this post, we will look the steps to backup a SQL Server Analysis Server Database. After logging to the Analysis Services, in...  Read more...
By Bru Medishetty 2010/02/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,320 reads

Analysis Services Performance Optimization Tips

Over the last few weeks I have focused most of my blog energy into writing a couple articles.  So I...  Read more...
By Devin Knight 2010/01/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,267 reads

MDX Utility Belt of Calculations Part 4

This is part four in the series of blog posts that will help in building a library of calculations you...  Read more...
By 2009/12/14 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,822 reads

MDX Utility Belt of Calculations Part 3

This is part three in a series of blog posts that will help you build an arsenal of MDX calculations...  Read more...
By Devin Knight 2009/12/09 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,131 reads

MDX Utility Belt of Calculations Part 2

This post is a part of a series of blog posts I am writing to give you a Batman-like Utility...  Read more...
By Devin Knight 2009/12/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,343 reads

MDX Utility Belt of Calculations Part 1

Developing MDX calculations is one of the most confusing and time consuming pieces of building an Analysis Services cube.  That...  Read more...
By 2009/12/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,101 reads

Analysis Services Memory Limits

I attended a presentation recently from Steven Wright of SQL Sentry on Analysis Services (SSAS) memory management and it was...  Read more...
By Steve Jones 2009/09/01 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,813 reads

Key column of a dimension in SSAS

When defining the attribute, we always specify the surrogate key as the key column for any attribute. I was just thinking if we could make use of the natural key instead of the surrogate key. i.e., in case of a product attribute, the surrogate key say...  Read more...
By Akalya 2009/04/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,129 reads
   Items 1 to 18 of 18   
 
Tags
mdx (2)    
backup / restore (1)    
backups (1)    
dimension (1)    
iif (1)    
integration services (ssis) (1)    
reporting services (ssrs) (1)    
sql server 2008 (1)