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

Content with tag Analysis Services (SSAS) Rss

<< Newer    Items 21 to 40 of 244    Older >>
 

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

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: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,835 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: analysis services (ssas)
Rating:  Rate this |   Briefcase | 2,657 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,656 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

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,384 reads

Data Mining SQLIO Results

Learn how to use Analysis Services Data Mining to identify the influence of RAID level and IO Pattern on Latency.  Read more...
By Paul Brewer 2013/03/26 | Source: SQLServerCentral.com | Category: sqlio
Rating: |  Discuss |   Briefcase | 2,938 reads

SQL Server Analysis Services-Lead, Lag, OpeningPeriod, ClosingPeriod Time Related Functions

Working with SSAS time related accounting functions can be tricky. SQL Server 2012 now offers Lag and Lead functions. Are these functions available in SSAS? What other related functions are available?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,398 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,337 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: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,176 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,060 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,116 reads

Create SQL Server Analysis Services Partitions using AMO

When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.   Read more...
By Additional Articles 2012/11/19 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 1,985 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,690 reads

DAX Query Basics

In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.   Read more...
By Gary Strange 2013/12/12 (first published: 2012/09/25) | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 13,868 reads

Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.  Read more...
By Additional Articles 2012/09/14 | Source: Microsoft MSDN | Category: business intelligence
Rating: (not yet rated)  Rate this |   Briefcase | 2,596 reads

Summarizing Imported Data

This article shows a few simple techniques to summarize table data using T-SQL.  Read more...
By paddythegeek 2012/07/27 | Source: SQLServerCentral.com | Category: import
Rating: |  Discuss |   Briefcase | 1,980 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

Using ASCMD to run command line scripts for SQL Server Analysis Services

Sometimes it would be helpful to run scripts from a command line for Analysis Services. This would be useful for things like creating backups, processing data or running other tasks. Is there a command line tool like sqlcmd for multidimensional databases and Data Mining?  Read more...
By Additional Articles 2012/06/18 | Source: MSSQLTips.com | Category: ascmd
Rating: (not yet rated)  Rate this |   Briefcase | 2,413 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
<< Newer    Items 21 to 40 of 244    Older >>
 
Tags
data warehousing (62)    
mdx (20)    
blogs (18)    
reporting services (ssrs) (13)    
dimensions (10)    
sql server 2005 (10)    
integration services (ssis) (9)    
olap server (9)    
amo (7)    
data mining (7)    
design and theory (7)    
video (6)    
powershell (5)    
security (5)    
sql server 2008 (5)    
sql server 7 (5)    
tabular model (5)    
backup / restore (4)    
business intelligence (4)    
cube (4)    
news (4)    
olap (4)    
t-sql (4)    
chart (3)    
dax (3)    
excel (3)    
hierarchies (3)    
hierarchy (3)    
miscellaneous (3)    
performance tuning (3)    
programming (3)    
administration (2)    
attributes (2)    
bi (2)    
cubes (2)    
data modeling (2)    
holap (2)    
lag (2)    
lead (2)    
partitioning (2)    
partitions (2)    
proclarity (2)    
qlikview (2)    
rolap (2)    
sql server 2008 r2 (2)    
sql server 2012 (2)    
time dimension (2)    
active directory (1)    
ado (1)    
advanced querying (1)    
ascmd (1)    
automatic (1)    
backup (1)    
backups (1)    
best and worst practices (1)    
cach (1)    
certifications (1)    
change data capture (cdc) (1)    
closing balances (1)    
closingperiod (1)    
clustering (1)    
consolidation (1)    
custom calendars (1)    
data integrity (1)    
database (1)    
database mail (1)    
date manipulation (1)    
denormalization (1)    
detach (1)    
dimension (1)    
dimension attribute (1)    
dimensional modelling (1)    
dns (1)    
double hop (1)    
firewall (1)    
iif (1)    
iis (1)    
import (1)    
informatica (1)    
integration (1)    
inventory problem (1)    
kerberos (1)    
level_number() (1)    
linked server (1)    
matrix (1)    
measures (1)    
memory (1)    
microsoft (1)    
migration (1)    
molap (1)    
ms bi project documentation (1)    
ms bi tools and utilities (1)    
neural network (1)    
openingperiod (1)    
operational analytics (1)    
optimization (1)    
partition (1)    
policy based management (pbm) (1)    
powerpivot (1)    
profiler (1)    
querying (1)    
rdbm (1)    
report builder (1)    
reports (1)    
sample chapters (1)    
semi-additive measures (1)    
software development (1)    
sql server (1)    
sql trace (1)    
sqlio (1)    
strategies (1)    
synchronization (1)    
tabular (1)    
user groups (1)    
user-defined hierarchies (1)    
visio (1)    
visual basic 6 (1)