SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tags Analysis Services, MDX Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 2005 (1)    
   Items 1 to 5 of 5   
 

Introduction to MDX Scripting in Microsoft SQL Server 2005

This document describes how Multidimensional Expressions (MDX) for Microsoft SQL Server 2005 can be applied to common business problems. This document assumes some familiarity with MDX.  Read more...
By Additional Articles 2008/05/02 | Source: TechNet | Category: MDX
Rating: (not yet rated)  Rate this |  Briefcase | 1,954 reads

Set Functions: The StripCalculatedMembers() Functio

Business Intelligence Architect Bill Pearson continues his examination of MDX functions, this time introducing StripCalculatedMembers(). In this article, we expose the function, and then lead a hands-on practice session with examples that reinforce the concepts.  Read more...
By Additional Articles 2008/04/18 | Source: Database Journal | Category: MDX
Rating: (not yet rated)  Rate this |  Briefcase | 1,083 reads

The Unpopular SELECT Statement

SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.  Read more...
By Vincent Rainardi 2008/02/20 | Source: SQLServerCentral.com | Category: MDX
Rating: |  Discuss |  Briefcase | 13,490 reads

Building a Localized Report on a SQL Server 2005 Analysis Service Cube Data Source

Learn how to use an Analysis Services cube as a data source by using parameterized MDX queries, as well as how to localize label strings in a report, in SQL Server 2005.  Read more...
By Additional Articles 2008/01/07 | Source: TechNet | Category: SQL Server 2005
Rating: (not yet rated)  Rate this |  Briefcase | 1,168 reads

Set Functions: The .AllMembers Function

Business Intelligence Architect Bill Pearson introduces the useful .AllMembers function, reinforcing the basic concepts, as always, with hands-on practice examples.  Read more...
By Additional Articles 2008/01/04 | Source: Database Journal | Category: MDX
Rating: (not yet rated)  Rate this |  Briefcase | 1,200 reads
   Items 1 to 5 of 5