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), Blogs 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,123 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,057 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,626 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,999 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,939 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,247 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,891 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,138 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,317 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,508 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,324 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,269 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,839 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,136 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,350 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,104 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,830 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,144 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)