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 225    Older >>
 

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,957 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,912 reads

Get a Descriptive Name for SQL Server Analysis Services Profiler Event Class and Event Subclass

A customer provides an SQL Server Analysis Services trace file to analyze. You save this file into a trace table and execute T-SQL code to analyze the results. Rather than getting descriptive values for the EventClass and EventSubclass data, you get numerical values. How do you resolve these numerical values to meaningful descriptive names? Check out this tip to learn more.  Read more...
By Additional Articles 2012/05/17 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 1,579 reads

Guide to MCITP: SQL Server 2008 BI Developer

A guide to the SQL Server 2008 Business Intelligence exams.  Read more...
Rating: |  Discuss |   Briefcase | 11,916 reads

Analytic Enhancements in SQL Server 2012 - Part II

The introduction of the new analytic functions in the RTM version of SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE, with the improved over clause, greatly facilitate the analysis on ordered data sets, such as time-series data. Read on to learn more.  Read more...
By Additional Articles 2012/04/25 | Source: Database Journal | Category: sql server 2012
Rating:  Rate this |   Briefcase | 2,998 reads

SSAS - Best Practices and Performance Optimization

There are several aspects that can take a toll on performance for your Analysis Services cubes. Some problems could be related to the source systems, some could be because of poor design of your cube and MDX queries and some could be related to network issues.  Read more...
By Additional Articles 2012/02/24 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 3,055 reads

Enabling Drillthrough in Analysis Services

Data analysis from a cube starts with aggregated and summarized data, followed by drill-down and drill-through of the data for a deeper and intelligent analysis. Drill down is inherently supported when you browse the data of the cube, but drill through has to be defined as per the requirements of analysis. In this tip we will see how to enable drill through on a cube.  Read more...
By Additional Articles 2011/10/11 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,433 reads

Optimize a SQL Server Analysis Services Measure Group Partition for Performance

In this tip you will learn how to design aggregations for a partition and optimize it for performance. Solution  Read more...
By Additional Articles 2011/08/26 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,718 reads

SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Processing Task

The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system. However, there are numerous scenarios where its role involves interaction with components that provide business intelligence-related features incorporated into the product.  Read more...
By Additional Articles 2011/08/15 | Source: Database Journal | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,736 reads

Using the Built-In Time Dimension and Time Intelligence in SQL Server Analysis

Getting the time dimension configured correctly is a necessary first step in order to take advantage of the Time Intelligence features in SSAS.  Read more...
By 2011/08/04 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 1,748 reads

SQL Server 2008 R2 Analysis Services Operations Guide

This white paper describes how operations engineers can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2.  Read more...
By Additional Articles 2011/06/16 | Source: SQLCAT | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 3,183 reads

REAL PRACTICES: Performance Scaling Microsoft SQL Server 2008 Analysis Services at Microsoft adCenter

This white paper explains how Microsoft® adCenter implemented a Microsoft SQL Server® 2008 Analysis Services Scalable Shared Database on EMC® Symmetrix VMAX™ storage. Leveraging TimeFinder® clones and Enterprise Flash Drives with the read-only feature of SQL Server 2008 Analysis Services allowed adCenter to dramatically scale out OLAP while maintaining SLAs and decreasing system outages.   Read more...
By Additional Articles 2011/06/08 | Source: SQLCAT | Category: best and worst practices
Rating: (not yet rated)  Rate this |   Briefcase | 2,112 reads

How to remove parent as a child from a SSAS parent child dimension

In a parent child dimension, when an attribute's usage type is set as Parent and browsed from a client tool, many designers as well as users may get confused based on the displayed results. For example, when you browse a parent attribute in a parent child dimension like Employee and say the parent attribute is Employees, you can browse data members from the parent node until the deepest available level of the child node. By default you will find each parent member having a child member with the same name even though this member might not exist in the data. From a user experience point of view this is not a desirable way of browsing a parent child hierarchy because it may get confusing. In this tip we will look at an example of this issue and how to solve this problem.   Read more...
By Additional Articles 2011/05/06 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,470 reads

Backup and Restore of an Analysis Services Database

One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user and system databases. In this article we will take a look at the steps which a database administrator needs to follow to backup and restore an analysis services database.   Read more...
Rating:  Rate this |   Briefcase | 2,827 reads

How to reduce MDX code redundancy in SQL Server Analysis Services (SSAS)

To query an Analysis Services cube, MDX is used as the query language. In most business settings, one would find a set of queries that are common across a number of user query requirements. To cater to this, even with a modest size IT team, there is a good chance that the same queries are developed redundantly either within a SSAS MDX script or repetitively in an ad-hoc manner in client applications. In this tip we would look at how to reuse queries without redeveloping them over and over.   Read more...
By Additional Articles 2011/03/01 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 3,203 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,229 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,886 reads

A faster way to prepare dimensional databases

When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?  Read more...
By Adam Aspin 2010/12/17 (first published: 2010/02/24) | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 15,628 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,137 reads

Creating Custom Calendars in SQL Server Analysis Services

Businesses often have custom financial calendars - adapting these for use in SSAS can often be challenging - this article shows you how to do it.  Read more...
By Andrew Muyobo 2010/09/28 | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 4,958 reads
<< Newer    Items 21 to 40 of 225    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)    
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)    
dimension (1)    
dimensional modelling (1)    
firewall (1)    
iif (1)    
import (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)    
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)    
semi-additive measures (1)    
software development (1)    
sql server (1)    
sql trace (1)    
sqlio (1)    
strategies (1)    
user groups (1)    
user-defined hierarchies (1)    
visio (1)    
visual basic 6 (1)