Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Analysis Services (SSAS), Data Warehousing Rss

   Items 1 to 20 of 62    Older >>
 

Scale-Out Querying with Analysis Services

This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers.  Read more...
Rating:  Rate this |   Briefcase | 1,221 reads

Analysis Services 2005 defines for peak performance

Analysis Services 2005 in SQL Server improves cube design and performance. Learn how attribute relationships advise Analysis Services how data should be rolled up.  Read more...
Rating:  Rate this |   Briefcase | 1,583 reads

What is Analysis Services in SQL Server 2005?

Check out our Top 10 tips on Analysis Services 2005 that will help you navigate through the features and functionality of this priceless Business Intelligence tool.  Read more...
Rating:  Rate this |   Briefcase | 4,332 reads

Scale-Out Querying with Analysis Services

This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers. Load-balanced querying ensures that readers of OLAP cubes can consistently query for the latest aggregations throughout the day and distribute the load of all queries among the available servers. This scale-out querying architecture optimizes cube processing time, increases the frequency of cube update, and makes processing more robust as you can afford more frequent processing and transparent error recovery.  Read more...
Rating:  Rate this |   Briefcase | 2,180 reads

Conditional Formatting in the Analysis Services Layer

Support conditional formatting for enterprise reports from the Analysis Services layer of the integrated Microsoft business intelligence solution.  Read more...
Rating:  Rate this |   Briefcase | 1,403 reads

Synchronising Databases in SSAS 2005

Planning for disaster recovery in SQL Server Analysis Services can be tricky. Fortunately SQL Server 2005 introduces the concept of a database synchronization, allowing you to transfer information and meta data from one server to another. Yaniv Mor brings us a look at this feature.   Read more...
By Yaniv Mor 2007/05/02 | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 4,413 reads

Connect to a Remote SSAS 2005 Database

Connecting to a SQL Server 2005 database is a simple process, but connecting to an Analysis Services 2005 database takes a bit more effort. Longtime data warehousing author Jacob Sebastian brings us a quick tutorial on how you can connect from Management Studio.   Read more...
Rating: |  Discuss |   Briefcase | 6,915 reads

Creating a Basic SSAS Cube

In this demonstration, you'll quickly learn how to create a basic cube using the Cube Wizard upon a data warehouse. Brian walks through the entire process in this 10 minute video to get you started with creating a browsing a cube.  Read more...
By Additional Articles 2007/05/01 | Source: JumpStartTV | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 3,028 reads

SQL Server Profiler for Analysis Services

Use SQL Server Profiler to “look behind the scenes” within Analysis Services 2005. BI Architect Bill Pearson leads a hands-on introduction to determining resource utilization effectiveness for both processing and query performance with profiling.  Read more...
Rating:  Rate this |   Briefcase | 2,335 reads

Analysis Services Performance Tuning Whitepape

A whitepaper on getting the best performance from your system.  Read more...
Rating:  Rate this |   Briefcase | 2,159 reads

MDX Operators: The IsLeaf() Operator: Conditional Logic within Filter

In this article, we will examine IsLeaf(), once again as a conditional logic modifier, but within the context of a filter. Combining IsLeaf() with the MDX Filter() function is another way we commonly see it in action in the business environment, and our exposure to the practical aspects of its employment in this way will serve to round out our overall awareness of the potential of IsLeaf().   Read more...
Rating:  Rate this |   Briefcase | 1,740 reads

MDX Operators: The IsLeaf() Operator: Conditional Logic within Calcula

In this article, we will concentrate upon the useful IsLeaf() operator, from the perspective of its use within a calculation. We will discuss the straightforward purpose of the operator, to ascertain whether a member is a leaf-level member of a dimension; the manner in which IsLeaf() manages to do this; and ways we can leverage the operator to support effective conditional logic to meet various business needs within our own environments.  Read more...
Rating:  Rate this |   Briefcase | 1,544 reads

MDX Numeric Functions: The .Ordinal Function

In this lesson, we will expose another useful function in the MDX toolset, the .Ordinal function. The general purpose of the .Ordinal function is to return the ordinal value of a specified dimensional level.  Read more...
Rating:  Rate this |   Briefcase | 2,007 reads

Using Excel 2007 with Analysis Services

In this presentation, you'll see how you can use Excel 2007 to view data and create quick reports against data in Analysis Services. Then, you'll see how to conditionally format the data and apply rules to the data.   Read more...
By Brian Knight 2006/11/08 | Source: JumpStartTV | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 2,279 reads

Storage Modes in SSAS 2005

Analysis Services and business intelligence are new structures for most of the SQL Server world. BI expert Yaniv Mor brings us another article on Analysis Services, this time explaining the various different options for storing your cube data.   Read more...
By Yaniv Mor 2006/10/31 | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 7,101 reads

Introducing Actions in Analysis Services 2005

In this and the related articles, we will overview Actions in Analysis Services 2005. Much as they did in the previous version of Analysis Services, Actions allow information consumers to go beyond the robust OLAP perspective offered by Analysis Services, and to "step outside" for related information, or to generate commands or initialize programs, without leaving their current analysis focus.  Read more...
Rating:  Rate this |   Briefcase | 2,132 reads

Mastering OLAP Reporting: Prototype KPIs in Reporting Services

Need a quick KPI prototype, using Reporting Services / Analysis Services 2000 or 2005? BI Architect Bill Pearson leads hands-on practice in presenting simple KPIs to management with Reporting Services.  Read more...
Rating:  Rate this |   Briefcase | 2,334 reads

Other MDX Entities: Perspectives

Leverage Perspectives, new to Analysis Services 2005, through MDX. BI Architect Bill Pearson leads hands-on practice with this means of visually focusing data retrieved from the UDM.   Read more...
Rating:  Rate this |   Briefcase | 2,202 reads

Mastering Enterprise BI: Introduction to Perspectives

Support information consumers with easier navigation and more focused analysis choices. In this article, BI Architect Bill Pearson leads hands-on exposure to Perspectives, another new Analysis Services 2005 feature.  Read more...
Rating:  Rate this |   Briefcase | 2,075 reads

Management Issues - SSAS 2005

For those of you using Analysis Services, Yaniv Mor takes a look at some of the manageablity tools with SQL Server 2005. The way you work with Analysis Services and your cubes has changed dramatically and this is a good overview to get you started.   Read more...
By Yaniv Mor 2006/06/07 | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 6,133 reads
   Items 1 to 20 of 62    Older >>
 
Tags
olap server (9)    
design and theory (5)    
sql server 7 (5)    
news (4)    
miscellaneous (3)    
programming (3)    
data mining (2)    
administration (1)    
ado (1)    
advanced querying (1)    
performance tuning (1)    
strategies (1)    
t-sql (1)    
visual basic 6 (1)