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

Content with tag SSAS Rss

   Items 1 to 15 of 15   
 

Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS

The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.  Read more...
By Additional Articles 2014/04/17 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 1,222 reads

SQL Server Analysis Services ProcessAdd for a Partition

Is there a way to process only the new data for a partition in SQL Server Analysis Services? Yes, this is accomplished in SQL Server Analysis Services with the ProcessAdd option for partitions. Daniel Calbimonte demonstrates how it works.  Read more...
By Additional Articles 2014/03/27 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 1,719 reads

SSAS: Tabular vs Multi Dimensional

By Stewart Campbell 2014/01/27 | Category: ssas
Rating: (not yet rated) |  Discuss |   Briefcase | 1,299 reads

DAX Query - Part 2

A more detailed look at the DAX language and some of its more frequently used functions  Read more...
By Gary Strange 2013/12/13 (first published: 2013/05/02) | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 7,288 reads

The SSAS Tabular Model

Phil Factor examines SQL Server 2012's SSAS Tabular model.  Read more...
By Phil Factor 2013/10/14 | Source: SQLServerCentral.com | Category: ssas
Rating: (not yet rated) |  Discuss |   Briefcase | 209 reads

SQL Server Analysis Services (SSAS) 2012 Top and Bottom Functions

Scott Murray has used the Top and Bottom T-SQL functions in SQL Server and wonders, do the same functions exist in the SQL Server Analysis Services (SSAS) or MDX? If so, how do they work? Can you provide some examples? Check out this tip to learn more.  Read more...
By Additional Articles 2013/09/17 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 2,084 reads

SQL Server 2012 Analysis Services Partitioning Performance Demonstration

How much of an improvement in processing time can a simple SQL Server Analysis Services (SSAS) partitioning structure provide? Can you provide any examples? Does this processing time improvement only apply to the fact tables? Check out this tip to learn more.  Read more...
By Additional Articles 2013/08/19 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 3,079 reads

Using Microsoft Excel to Retrieve SSAS Tabular Data

Although it is well-known how to create a tabular database in PowerPivot, it is less obvious that there are several useful options for retrieving SSAS tabular data into Excel. This provides an easy way of manipulating, visualizing and analyzing the data without needing to know the details of SSAS and the tabular model.  Read more...
By Additional Articles 2013/08/05 | Source: SimpleTalk | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 2,447 reads

What's in a name?

By Koen Verbeeck 2013/07/19 | Category: integration services (ssis)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,477 reads

Getting Started with the SSAS Tabular Model

SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to provide a rapid and powerful way of providing self-service BI to client applications such as Microsoft Excel and Microsoft Power View. You’ve deployed SSAS in tabular mode, and deployed Adventureworks into it. What next? Rob Sheldon explains all.  Read more...
By Additional Articles 2013/06/17 | Source: SimpleTalk | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 2,772 reads

How to Synchronize Two SSAS Servers

Unfortunately SQL Server Analysis Services (SSAS) does not support differential backups and creating full backups for the servers might take too much time. In this tip we are going to show how to synchronize two SSAS servers in order to have a failover server in case something goes wrong with one of the servers.  Read more...
By Additional Articles 2013/05/14 | Source: MSSQLTips.com | Category: ssas
Rating:  Rate this |   Briefcase | 2,571 reads

DAX Query - Part 2

A more detailed look at the DAX language and some of its more frequently used functions  Read more...
By Gary Strange 2013/12/13 (first published: 2013/05/02) | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 7,288 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's  Read more...
By Theo Ekelmans 2013/03/28 | Source: SQLServerCentral.com | Category: automatic
Rating: |  Discuss |   Briefcase | 1,188 reads

Copy SQL Server Analysis Services Dimensions

How can you copy dimensions from one SQL Server Analysis Services (SSAS) Project to another? Are there any options to do so? This tip outlines three approaches for SQL Server BI Professionals who need to copy dimensions from one SSAS project to another.  Read more...
By Additional Articles 2012/12/31 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 2,077 reads

QlikView for Beginners - An Introduction to QlikView

A brief introduction to getting started with QlikView.  Read more...
By Mark O'Donovan 2012/12/17 | Source: SQLServerCentral.com | Category: qlikview
Rating: |  Discuss |   Briefcase | 3,076 reads
   Items 1 to 15 of 15   
 
Tags
tabular model (3)    
reporting services (ssrs) (2)    
automatic (1)    
backup (1)    
bi (1)    
database (1)    
dax (1)    
excel (1)    
integration services (ssis) (1)    
partitioning (1)    
partitions (1)    
qlikview (1)    
synchronization (1)    
t-sql (1)