SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag MDX Rss

Search for any content tagged mdx

   Items 1 to 20 of 65    Older >>
 

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 2018/01/17 (first published: 2011/09/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,008 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 2018/01/03 (first published: 2011/08/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,034 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 2017/11/22 (first published: 2011/05/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,000 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 2017/11/15 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 16,884 reads

MDX Calculations Across Multiple Calendars Using Nested SCOPEs

A solution to the problem of multiple calendar calculations within SSAS Multimdimensional cubes using nested SCOPEs  Read more...
By Paul Burton 2016/10/10 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 1,394 reads

Stairway to MDX - Level 15: Basic Set Functions: The Tail() Function

Return, in order, a specified number of elements from the end of a set. SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Tail() function.  Read more...
By Bill Pearson 2015/09/30 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,141 reads

Stairway to MDX - Level 14: Basic Set Functions: The Head() Function

SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Head() function, which allows us to return, in order, a specified number of elements within a set.  Read more...
By Bill Pearson 2015/09/09 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,911 reads

Stairway to MDX - Level 13: MDX Time/Date Series Functions: LastPeriods() and ParallelPeriod() Functions

BI Architect Bill Pearson continues with the third of a subseries surrounding a group of MDX functions we can use to support analysis and reporting in a time / date context. In this Level, we will explore the LastPeriods() and ParallelPeriod() functions, and get hands-on practice with each in meeting sample business requirements.  Read more...
By Bill Pearson 2015/08/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,336 reads

Stairway to MDX - Level 12: : MDX Time/Date Series Functions: OpeningPeriod() and ClosingPeriod() Functions

BI Architect Bill Pearson continues with the second of a set of articles surrounding a group of MDX functions specialized to support the analysis of data within the context of time / date. In this article, we will explore the OpeningPeriod() and ClosingPeriod() functions, and get hands-on practice with each in meeting sample business requirements.  Read more...
By Bill Pearson 2015/07/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,321 reads

Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions

BI Architect Bill Pearson launches a set of articles surrounding a group of MDX functions specialized to meet the pervasive business need to analyze data within the context of time / date. In this article, we will overview the PeriodsToDate() function, and then we will introduce "shortcut" functions that are based upon it.  Read more...
By Bill Pearson 2015/06/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,702 reads

Data Mining: Part 12 DMX for Data Mining

In this lesson we will learn the basics of DMX and create some samples.  Read more...
By Daniel Calbimonte 2014/07/21 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 3,003 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 2014/06/13 (first published: 2012/11/01) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 20,528 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 | 70,381 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 | 4,258 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 | 4,434 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,692 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 | 3,564 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 | 7,527 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 2014/06/13 (first published: 2012/11/01) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 20,528 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 2017/11/15 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 16,884 reads
   Items 1 to 20 of 65    Older >>