Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Analysis Services (SSAS) Rss

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

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: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 3,135 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,592 reads

What's in a name?

By Koen Verbeeck 2013/07/19 | Category: integration services (ssis)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,646 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 | 1,585 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 | 3,219 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,975 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 | 8,177 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,691 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's  Read more...
By Theo Ekelmans 2015/05/13 | Source: SQLServerCentral.com | Category: automatic
Rating: |  Discuss |   Briefcase | 2,593 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 | 3,029 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,739 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,647 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,514 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,488 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,201 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 | 2,242 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 | 20,470 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 | 14,879 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,990 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,988 reads
<< Newer    Items 21 to 40 of 247    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)    
tabular model (6)    
video (6)    
powershell (5)    
security (5)    
sql server 2008 (5)    
sql server 7 (5)    
backup and 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 database (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 server 2016 (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)