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

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,575 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,357 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,917 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,879 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,562 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,896 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,984 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,024 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,397 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,685 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,719 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,732 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,180 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,087 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,443 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,821 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,191 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,204 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,882 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,616 reads
<< Newer    Items 21 to 40 of 227    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)