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

Content with tag MDX Rss

   Items 1 to 20 of 59    Older >>
 

Stairway to MDX - Level 1: Getting Started with MDX

To learn MDX, there is really no alternative to installing the system and trying out the statements, and experimenting. William Pearson, the well-known expert on MDX, kicks off a stairway series on this important topic by getting you running from a standing start.  Read more...
By Bill Pearson 2013/10/02 (first published: 2011/03/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 59,879 reads

Create a Named Set with all but one Member in MDX – SSAS

I was trying to create a Named set in SSAS 2008 using the MDX calculations. I wanted to include all...  Read more...
By MikeDavis 2013/07/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 628 reads

Stairway to MDX - Level 10: “Relative” Member Functions: .CurrentMember, .PrevMember, and .NextMember

SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces three “major players” within the MDX “relative” functions. These basic, but highly employed, functions include the .CurrentMember, .PrevMember and .NextMember functions.  Read more...
By Bill Pearson 2013/06/12 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,810 reads

Per Member Per Month Per 1000 Calculations in MDX

In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the...  Read more...
By MikeDavis 2013/05/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,073 reads

Comparison of Queries Written in T-SQL and SQL Server MDX

Beginning to learn and comprehend SQL Server Analysis Services (SSAS) MDX queries can be difficult after one has spent years writing queries in T-SQL. When trying to write SQL Server MDX queries, it's worth considering "How would I write this query in T-SQL?"   Read more...
By Additional Articles 2013/04/19 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 3,914 reads

MDX #26 – SSN can only be referenced as a member property in MDX

I’ve blogged about the Properties()  function before. MDX #11 – How to get number of cars each customer owned using Properties() function? MDX...  Read more...
By Sherry Li's BI Corner 2013/02/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 770 reads

MDX Guide for SQL Folks: Part III - Advanced Analysis

Learn everything about MDX drawing only on your T-SQL knowledge in this series. Frank Banin continues talking about Calculated Members, Named Sets, and more in part III.  Read more...
By Frank A. Banin 2013/02/14 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 5,020 reads

Using MDX to Calculate Both Values and Percentages for Analysis Services

When creating pie charts using data from Analysis Services, having the MDX query calculate and return the percentages along with the counts or sums is extremely efficient. In this tip, we walk through an example of how this can be done.  Read more...
By Additional Articles 2013/01/11 | Source: MSSQLTips.com | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 2,950 reads

MDX Guide for SQL Folks: Part II - Hierarchies and Functions

Learn everything about MDX by drawing only on your SQL knowledge.   Read more...
By Frank A. Banin 2012/12/18 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 6,726 reads

MDX Guide for SQL Folks: Part I - Navigating The Cube

Learn all you need to know about MDX, by drawing only on your current SQL knowledge.   Read more...
By Frank A. Banin 2012/11/01 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 12,604 reads

Stairway to MDX - Level 2: The Ordinal Function

Business Intelligence Architect Bill Pearson introduces the MDX Ordinal Function, as a means for generating lists and for conditionally presenting calculations. He also demonstrates the use of the function in creating datasets to support report parameter picklists.  Read more...
By Bill Pearson 2012/08/24 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 12,621 reads

Stairway to MDX - Level 1: Getting Started with MDX

To learn MDX, there is really no alternative to installing the system and trying out the statements, and experimenting. William Pearson, the well-known expert on MDX, kicks off a stairway series on this important topic by getting you running from a standing start.  Read more...
By Bill Pearson 2013/10/02 (first published: 2011/03/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 59,879 reads

Stairway to MDX - Level 9: Member “Family” Functions: .LastSibling and Cousin()

BI Architect Bill Pearson concludes his introduction to the MDX Members functions. In this Level we wrap up our exploration of the “family” group with the .LastSibling, and Cousin() functions.  Read more...
By Bill Pearson 2011/10/26 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,452 reads

Stairway to MDX - Level 8: Member “Family” Functions: .LastChild and .FirstSibling

BI Architect Bill Pearson continues his introduction to the MDX Members functions. In this Level we continue our exploration of the general “family” group with the .LastChild and .FirstSibling functions.  Read more...
By Bill Pearson 2011/10/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,187 reads

Stairway to MDX - Level 7: Member "Family" Functions: Ancestor() and .FirstChild

BI Architect Bill Pearson continues his introduction to the MDX Members functions. In this Level we continue our exploration of the general “family” group, with the Ancestor() and .FirstChild functions.  Read more...
By Bill Pearson 2011/09/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,804 reads

Stairway to MDX - Level 6: Member “Family” Functions: .Parent and .Children

Some of the most important 'Member' functions of MDX are often known as the 'Family Functions'. These are used in queries on multidimensional structures for analysis and reporting, and can refer to relative nodes in the hierarchy in much the same way as in a family tree.  Read more...
By Bill Pearson 2011/09/09 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,350 reads

Stairway to MDX - Level 5: Members, and an Introduction to the MDX Members Functions

Bill explains what is meant by a 'Member' and 'Member function' in MDX. A member is an item in a dimension that include the 'measures' which are the values of the attributes that belong to a dimension. 'Measures' are themselves members of a dimension called the “measures” dimension. MDX has a set of functions, known as member functions, each of which allow us to perform operations upon any member of a dimension   Read more...
By Bill Pearson 2011/09/02 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,920 reads

Stairway to MDX - Level 4: The Order() Function: Beyond Cube Hierarchies

Bill Pearson continues his examination of the versatile Order() function, focusing upon its use in providing dataset sorts that reach beyond dimensional hierarchies  Read more...
By Bill Pearson 2011/08/26 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,313 reads

Stairway to MDX - Level 3: The Order() Function

The Order() function provides the 'hierarchized' sorts you need for reports and applications using MDX. In this Step, Business Intelligence Architect Bill Pearson explores using the versatile Order() function for providing dataset sorts that respect dimensional hierarchies.  Read more...
By Bill Pearson 2011/05/25 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,725 reads

Stairway to MDX - Level 1: Getting Started with MDX

To learn MDX, there is really no alternative to installing the system and trying out the statements, and experimenting. William Pearson, the well-known expert on MDX, kicks off a stairway series on this important topic by getting you running from a standing start.  Read more...
By Bill Pearson 2013/10/02 (first published: 2011/03/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 59,879 reads
   Items 1 to 20 of 59    Older >>
 
Tags
analysis services (ssas) (20)    
stairway series (10)    
blogs (5)    
dimensions (5)    
data warehousing (4)    
cube (3)    
hierarchy (3)    
olap (3)    
sql server 2005 (2)    
t-sql (2)    
video (2)    
.currentmember (1)    
.nextmember (1)    
.prevmember (1)    
bankers' rounding (1)    
clustering (1)    
design and theory (1)    
format_string (1)    
hierarchies (1)    
iif (1)    
integration services (ssis) (1)    
performancepoint (1)    
rdbm (1)    
round() (1)    
sample chapters (1)    
sql server 2008 (1)