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 53    Older >>
 

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,907 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,807 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,299 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,653 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,038 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,057 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,171 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,531 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,746 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,794 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,475 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,233 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,831 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,821 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,198 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,545 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,520 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,776 reads

Intrinsic Member Properties: The MEMBER_KEY Property

Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.  Read more...
Rating:  Rate this |   Briefcase | 1,623 reads

Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part I

Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor – but then, you really didn’t think that you could avoid actually touching MDX at all, did you? BI Architect Bill Pearson demonstrates a way to parameterize the highly useful LastPeriods() function.  Read more...
By Additional Articles 2008/06/24 | Source: Database Journal | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 1,351 reads
<< Newer    Items 21 to 40 of 53    Older >>