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

Articles with tag MDX Rss

Search for any content tagged mdx

<< Newer    Items 21 to 40 of 55    Older >>
 

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 | 13,190 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,204 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,916 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,823 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,306 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,670 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,046 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,068 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,210 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,561 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 | 8,806 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,802 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,550 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,246 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,850 reads

Basic Set Functions: The BottomCount() Function, Part I

Isolate worst / lowest performers from the member population at large, and perform sophisticated analysis with BottomCount(). Join MSAS Architect Bill Pearson in the first of a pair of articles focusing upon the powerful BottomCount() function, where we experience “hands-on” some of the possible ways it can offer multi-perspective decision support.  Read more...
By Additional Articles 2008/10/15 | Source: Database Journal | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 2,827 reads

Parent-child dimensions in SQL Server 2005

Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using Analysis Services MDX.  Read more...
By Additional Articles 2008/10/10 | Source: SearchSQLServer | Category: dimensions
Rating: (not yet rated)  Rate this |   Briefcase | 3,221 reads

Intrinsic Member Properties: The MEMBER_VALUE Property

MSAS Architect Bill Pearson leads hands-on exercises providing exposure to the use of the MEMBER_VALUE intrinsic member property. Join us in generating simple lists, as well as datasets to support report parameter picklists.  Read more...
By Additional Articles 2008/09/23 | Source: Database Journal | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 1,559 reads

Intrinsic Member Properties: The MEMBER_UNIQUE_NAME Property

Join MSAS Architect Bill Pearson in hands-on exercises, where we gain exposure to the use of the MEMBER_UNIQUE_NAME property in generating simple lists, as well as datasets to support report parameter picklists.  Read more...
By Additional Articles 2008/08/21 | Source: SQLServerCentral.com | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 1,534 reads

Mastering OLAP Reports: Parameterizing Number of “Top” Items with the MDX TopCount() Function, Part I

Writing high-performance reports against Analysis Services cubes means learning MDX to some extent. Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor. BI Architect Bill Pearson demonstrates a way to parameterize the highly useful TopCount() function.  Read more...
By Additional Articles 2008/08/08 | Source: Database Journal | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 1,782 reads
<< Newer    Items 21 to 40 of 55    Older >>