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 163    Next 20 >>
 

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 | 1,346 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 | 1,769 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: (not yet rated)  Rate this |  Briefcase | 1,152 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 | 1,961 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 | 2,794 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 | 2,565 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 | 3,854 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,343 reads

Introduction to Security in Analysis Services

Join BI Architect Bill Pearson in this introduction to Security in Analysis Services 2008. Here we explore security concepts and implementation, and look forward to hands-on practice with security in other articles of this subseries.  Read more...
Rating:  Rate this |  Briefcase | 1,621 reads

Cube Storage: Planning Partitions from a SQL Server Management Studio Perspective

BI Architect Bill Pearson continues his discussion of Partition planning for Analysis Services, this time focusing on the settings and properties involved from a SQL Server Management Studio perspective.  Read more...
By Additional Articles 2009/12/16 | Source: Database Journal | Category: business intelligence
Rating: (not yet rated)  Rate this |  Briefcase | 1,258 reads

Using the SQL Server Analysis Services (SSAS) Deployment Wizard

I have to deploy my SQL Server Analysis Services project to a test server then to a production server after testing is completed. For both of these deployments I need to provide an installation program. I am not allowed to access either of these servers. For my own testing I can deploy my project using Business Intelligence Development Studio (BIDS) and this works great. How can I create an installer that my IT team can use to perform the deployment?  Read more...
By Additional Articles 2009/11/25 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |  Briefcase | 1,316 reads

XY (Scatter) Chart for Analysis Services Data

Display data series' as a set of points with an XY (scatter) chart - typically to compare distinct values across categories. BI Architect Bill Pearson leads the hands-on creation of an XY chart based upon an Analysis Service data source.  Read more...
Rating: (not yet rated)  Rate this |  Briefcase | 1,230 reads

Cube Storage: Introduction to Partitions

Join BI Architect Bill Pearson in this introduction to Partitions in Analysis Services 2008. Here we explore partitioning concepts and advantages, and look forward to hands-on practice with partitions in subsequent articles.  Read more...
Rating: (not yet rated)  Rate this |  Briefcase | 2,754 reads

Introduction to Cube Storage

BI Architect Bill Pearson introduces Storage in Analysis Service 2008. This article begins an extended examination of storage topics, including partitions and aggregations, within a multiple-article subseries.  Read more...
Rating: (not yet rated)  Rate this |  Briefcase | 2,924 reads

Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005

I have seen the tip Dynamically Control Data Filtering in SQL Server Reporting Services Reports which showed how to leverage a SQL Server database table to filter sales data based on the user running the report. I have a similar requirement to implement dynamic filtering except my data is in a SQL Server Analysis Services (SSAS) cube and the users query the data with a variety of different tools. How can I implement dynamic security in my case?  Read more...
By Additional Articles 2009/09/15 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |  Briefcase | 1,178 reads

SQL Server Analysis Services ( SSAS ) - Introduction

Microsoft SQL Server 2005 Analysis Services (SSAS) delivers both online analytical processing (OLAP) and data mining functionality for business intelligence applications. This article thoroughly explores the architecture of SSAS and how it can be implemented.  Read more...
Rating:  Rate this |  Briefcase | 3,514 reads

Simple Doughnut Chart for Analysis Services Data

Architect Bill Pearson leads the hands-on creation of a simple doughnut chart based upon an Analysis Services data source.  Read more...
Rating: (not yet rated)  Rate this |  Briefcase | 2,039 reads

Attribute Discretization: Using the “Clusters” Method

Join BI Architect Bill Pearson as he leads hands-on practice with the “Clusters” discretization method in Analysis Services. In this article we continue to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.  Read more...
By Additional Articles 2009/08/04 | Source: Database Journal | Category: clusters
Rating: (not yet rated)  Rate this |  Briefcase | 1,272 reads

SQL Server 2008 Analysis Services Performance Guide

Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments.   Read more...
By Additional Articles 2009/08/04 | Source: Microsoft MSDN | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |  Briefcase | 2,104 reads

Creating and managing Analysis Services partitions

S partitions from the ground up, with advice on binding, merging, and selecting partition data.   Read more...
Rating: (not yet rated)  Rate this |  Briefcase | 1,587 reads
   Items 1 to 20 of 163    Next 20 >>
 
Tags
data warehousing (62)    
mdx (14)    
sql server 2005 (10)    
olap server (9)    
design and theory (7)    
dimensions (7)    
reporting services (ssrs) (7)    
amo (6)    
video (6)    
data mining (5)    
powershell (5)    
sql server 7, 2000 (5)    
news (4)    
chart (3)    
integration services (ssis) (3)    
miscellaneous (3)    
performance tuning (3)    
programming (3)    
security (3)    
sql server 2008 (3)    
attributes (2)    
business intelligence (2)    
excel (2)    
hierarchies (2)    
proclarity (2)    
administration (1)    
ado (1)    
advanced querying (1)    
backup / restore (1)    
backup and recovery (1)    
basic querying (1)    
blogs (1)    
change data capture (cdc) (1)    
clusters (1)    
consolidation (1)    
cube (1)    
cubes (1)    
data integrity (1)    
data modeling (1)    
date manipulation (1)    
detach (1)    
dimension (1)    
holap (1)    
informatica (1)    
level_number() (1)    
linked server (1)    
matrix (1)    
measures (1)    
migration (1)    
molap (1)    
olap (1)    
operational analytics (1)    
partition (1)    
partitioning (1)    
qlikview (1)    
report builder (1)    
rolap (1)    
sample chapters (1)    
software development (1)    
ssas (1)    
ssrs (1)    
strategies (1)    
t-sql (1)    
user groups (1)    
user-defined hierarchies (1)    
visio (1)    
visual basic 6 (1)