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 41 to 60 of 227    Older >>
 

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,128 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,939 reads

Configuring Proactive Caching in SQL Server

Proactive caching helps DBAs to better control the cube data automatic refresh frequency, offering near real-time data for reports. This article covers the settings for HOLAP and ROLAP, and configuring proactive caching.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,291 reads

SSAS: Explaining the State Transitions Viewer for Sequence Clustering

In SQL Server 2005 and SQL Server 2008, Microsoft has added some fantastic visualizations around data-mining algorithms. These visual aids allow us to see exactly what a particular algorithm is predicting or describing—making a difficult subject easier to understand.  Read more...
By Additional Articles 2010/06/25 | Source: TechNet Blogs | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 1,541 reads

Partitions in Analysis Services

A look at partitioning in Analysis Services from Shahfaisal Muhammed. Learn how it works, what it can do, and how to implement partitions for your cubes.  Read more...
Rating: |  Discuss |   Briefcase | 7,717 reads

Configure Surface Area Configuration for SQL Server 2008 Analysis Services Using Policy Based Management

I have installed a new instance of SQL Server 2008 Analysis Services and I am unable to find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Analysis Services features in SQL Server 2008?   Read more...
Rating:  Rate this |   Briefcase | 2,044 reads

Configure Windows Firewall for SQL Server 2008 Analysis Services in Windows Server 2008 R2

As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 Analysis Services in Windows Firewall for user connectivity.  Read more...
By Additional Articles 2010/04/29 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 2,012 reads

Adding Actions to a Cube in SQL Server Analysis Services 2008

Actions are powerful way of extending the value of SSAS cubes for the end user. They can click on a cube or portion of a cube to start an application with the selected item as a parameter, or to retrieve information about the selected item. Actions haven't been well-documented until now; Robert Sheldon once more makes everything clear.  Read more...
By Additional Articles 2010/04/15 | Source: SimpleTalk | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 2,903 reads

Using SSAS MDX Calculation Color Expressions

Analysis Services calculations are great for storing formulas that your users need to see on a regular basis.  They also...  Read more...
By 2010/03/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,307 reads

Implementing User-Defined Hierarchies in SQL Server Analysis Services

To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on the database dimensions. Then you'll create the attribute relationships necessary to optimize performance. Analysis Services hierarchies offer plenty of possibilities for displaying the data that your business requires. Rob Sheldon continues his series on SQL Server Analysis Services 2008.  Read more...
By Additional Articles 2010/03/05 | Source: SimpleTalk | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 2,145 reads

Managing Analysis Services Deployment - Part 4

Part 4 of this series, Shahfaisal Muhammed brings another method of deploying your SSAS projects to a new server: the synchronize database method. The rest of the series covers other methods.  Read more...
Rating: |  Discuss |   Briefcase | 3,287 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,617 reads

Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices

This technical note describes the consolidation options, considerations, and best practices for Microsoft® SQL Server® 2008 Analysis Services that the SQL CAT team has derived from working with Analysis Services customers. In this technical note, we also discuss an Analysis Services load balancer solution that one of our internal customers uses to load balance queries from Microsoft Excel® and SQL Server Reporting Services clients across multiple query servers to increase query performance and provide availability.  Read more...
By Additional Articles 2010/02/24 | Source: SQLCAT | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 1,604 reads

Managing Analysis Services Deployment - Part 3

Part 3 of this series, Shahfaisal Muhammed brings a common method of deploying your SSAS projects to a new server: backup and restore. The rest of the series covers other methods.  Read more...
Rating: |  Discuss |   Briefcase | 3,208 reads

Development Lifecycle Deployment SSAS, SSRS, SSIS

Many companies have a very rigid development lifecycle for all products or solutions they develop.  Deploying to each of these...  Read more...
By Devin Knight 2010/02/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,501 reads

Why Use SSAS?

After a great presentation from Brian Knight at the NYC User Group, Robert Pearl summarizes some information about SSAS and when it makes sense to use this subsystem. And why you might want to attend that next user group meeting.  Read more...
By Robert Pearl 2010/02/19 | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 7,111 reads

Managing Analysis Services Deployment - Part 2

Continuing with this series, Shahfaisal Muhammed brings us another method of deploying your SSAS projects to a new server. The rest of the series will cover other methods.  Read more...
Rating: |  Discuss |   Briefcase | 4,846 reads

Managing Analysis Services Deployment - Part 1

In part 1 of this series, Shahfaisal Muhammed brings us one method of deploying your SSAS projects to a new server. The rest of the series will cover other methods.  Read more...
Rating: |  Discuss |   Briefcase | 7,035 reads

Professional Microsoft SQL Server Analysis Services 2008 with MDX - Sample Chapter

A sample chapter from a new book on Analysis Services. Check it out and see if this is the book for you.  Read more...
By Press Release 2010/02/16 | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 1,916 reads

Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS

Learn how the Analysis Services Processing Task can be used to process analysis services objects such as cubes, dimensions and mining models.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,446 reads
<< Newer    Items 41 to 60 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)