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

   Items 1 to 20 of 226    Older >>
 

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/04/11 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 2,215 reads

SaaS and Multi-tenancy Models

If you need to architect a multi-tenant Analysis Services project, what are your options? This piece from Sean Woehrle shows four options and explains why he picked a particular one.  Read more...
By Sean Woehrle 2014/03/11 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 3,583 reads

Analysis Services Tabular

By Steven Neumersky 2014/02/05 | Category: querying
Rating: (not yet rated) |  Discuss |   Briefcase | 1,211 reads

Analysis Services Multidimensional

By Steven Neumersky 2014/02/04 | Category: hierarchies
Rating: (not yet rated) |  Discuss |   Briefcase | 1,245 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/04/11 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 2,215 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 | 12,821 reads

SQL Server 2012 Analysis Services XMLA

Cube developers often flippantly use the term XMLA in their discussion of maintaining, scripting, backing up, and restoring cubes and other SSAS objects; what exactly is XMLA and how can it be used? Check out this tip to learn more.  Read more...
By Additional Articles 2013/07/22 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,130 reads

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 | 973 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 | 946 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,871 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,289 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,018 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 | 6,719 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,904 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 2012/11/01 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 12,599 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 | 12,821 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,486 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,975 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,485 reads
   Items 1 to 20 of 226    Older >>
 
Tags
data warehousing (62)    
mdx (20)    
blogs (18)    
dimensions (10)    
reporting services (ssrs) (10)    
sql server 2005 (10)    
olap server (9)    
integration services (ssis) (8)    
amo (7)    
data mining (7)    
design and theory (7)    
video (6)    
powershell (5)    
security (5)    
sql server 2008 (5)    
sql server 7 (5)    
backup / restore (4)    
business intelligence (4)    
cube (4)    
news (4)    
olap (4)    
chart (3)    
hierarchies (3)    
hierarchy (3)    
miscellaneous (3)    
performance tuning (3)    
programming (3)    
t-sql (3)    
administration (2)    
attributes (2)    
cubes (2)    
data modeling (2)    
excel (2)    
holap (2)    
lag (2)    
lead (2)    
proclarity (2)    
rolap (2)    
sql server 2008 r2 (2)    
sql server 2012 (2)    
tabular model (2)    
time dimension (2)    
ado (1)    
advanced querying (1)    
ascmd (1)    
backups (1)    
best and worst practices (1)    
breakdown (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 mail (1)    
date manipulation (1)    
dax (1)    
denormalization (1)    
detach (1)    
details (1)    
dimension (1)    
dimensional modelling (1)    
duplicates (1)    
firewall (1)    
iif (1)    
import (1)    
index (1)    
informatica (1)    
integration (1)    
inventory problem (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)    
optimize (1)    
partition (1)    
partitioning (1)    
partitions (1)    
policy based management (pbm) (1)    
profiler (1)    
qlikview (1)    
querying (1)    
rdbm (1)    
report builder (1)    
reports (1)    
sample chapters (1)    
scans (1)    
seeks (1)    
semi-additive measures (1)    
size (1)    
software development (1)    
sql server (1)    
sql trace (1)    
sqlio (1)    
stats (1)    
strategies (1)    
troubleshoot (1)    
unused (1)    
usage (1)    
user groups (1)    
user-defined hierarchies (1)    
visio (1)    
visual basic 6 (1)