Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag MDX Rss

Search for any content tagged mdx

<< Newer    Items 21 to 40 of 60    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 2011/09/02 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,706 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 | 6,588 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 | 10,526 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 | 69,520 reads

How to reduce MDX code redundancy in SQL Server Analysis Services (SSAS)

To query an Analysis Services cube, MDX is used as the query language. In most business settings, one would find a set of queries that are common across a number of user query requirements. To cater to this, even with a modest size IT team, there is a good chance that the same queries are developed redundantly either within a SSAS MDX script or repetitively in an ad-hoc manner in client applications. In this tip we would look at how to reuse queries without redeveloping them over and over.   Read more...
By Additional Articles 2011/03/01 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 3,419 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 | 16,213 reads

MDX Performance - burdens of IIF

I used to think naively that IIF is an innocent little function that can only do good and help me...  Read more...
By aedna-843346 2011/02/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,590 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,959 reads

MDX Utility Belt of Calculations Part 4

This is part four in the series of blog posts that will help in building a library of calculations you...  Read more...
By 2009/12/14 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,975 reads

Custom Rounding and Truncation of Numbers in MDX

MDX applies "bankers' rounding" algorithm in its ROUND() function. This article shows you how to avoid that and round like in T-SQL and Excel.  Read more...
By Boyan Penev 2009/10/06 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 3,336 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: clustering
Rating: (not yet rated)  Rate this |   Briefcase | 1,825 reads

The LEVEL_UNIQUE_NAME Intrinsic Member Property

SSAS Architect Bill Pearson examines another intrinsic member property, LEVEL_UNIQUE_NAME, which allows us to exercise a great deal of presentation “sleight of hand” in working with MDX in Analysis Services, as well as within Reporting Services and various other reporting applications that can access an Analysis Services cube.  Read more...
Rating:  Rate this |   Briefcase | 1,184 reads

Intrinsic Member Properties: The HIERARCHY_UNIQUE_NAME Property

This month's installment of "MDX Essentials" examines the HIERARCHY_UNIQUE_NAME intrinsic member property. Join SSAS Architect Bill Pearson in an introduction of this intrinsic member property, which Bill complements with hands-on exercises and sample uses.  Read more...
By Additional Articles 2009/02/13 | Source: Database Journal | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 1,226 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 2009/01/30 (first published: 2008/02/20) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 34,268 reads

Writing a Basic MDX Query Pt.2 - SQL School Video

In the second part of this basic video on MDX queries, MVP Brian Knight continues with his discussion of MDX, examining some more advanced MDX features.  Read more...
By Brian Knight 2008/12/11 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 6,686 reads

Writing a Basic MDX Query Pt.1 - SQL School Video

MDX is the query language for multidimensional queries, usually against SSAS cubes. Brian Knight introduces us to the basics of MDX in this video.  Read more...
By Brian Knight 2008/12/09 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 9,015 reads

Combine BottomCount() with Other MDX Functions to Add Sophistication

Discover, through a hands-on practice exercise, a more sophisticated business use for the MDX BottomCount() function, in combination with the Generate(), Descendants(), Ancestor() and other functions we have explored within our series. Join BI Architect Bill Pearson in this, the second part, of an extended examination of the MDX BottomCount() function.  Read more...
By Additional Articles 2008/12/05 | Source: Database Journal | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 1,861 reads

Exporting MDX queries to SQL Relational Databases using SSIS 2005

Most of the time we move data from an RDBMS to a cube, but there are places where you might want to provide a feedback loop to the RDBMS. Andrew Muyobo shows how SSIS can help you do this.   Read more...
By Andrew Muyobo 2008/11/21 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 7,966 reads

Filtering Unneeded Dimension Members in PerformancePoint Filters

Removing redundant dimension members from a Tree filter in PerformancePoint 2007 by using a simple MDX query.  Read more...
By Boyan Penev 2008/11/14 | Source: SQLServerCentral.com | Category: performancepoint
Rating: |  Discuss |   Briefcase | 2,279 reads

MSSQL Analysis Services - Attribute Member Names

Business Intelligence Architect Bill Pearson continues his exploration of Attribute Members, in another member of a subseries surrounding significant components of the Analysis Services dimensional model. In this article we examine the attribute member Name property, whose appropriate use is important to good model design and overall system performance.  Read more...
By Additional Articles 2008/10/24 | Source: Database Journal | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 1,967 reads
<< Newer    Items 21 to 40 of 60    Older >>