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

Content with tags Analysis Services (SSAS), MDX Rss

   Items 1 to 20 of 22    Older >>
 

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 | 19,101 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,412 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,145 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 | 19,101 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,235 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,271 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,929 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,848 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,696 reads

SSAS Cubes

By jconesa 2009/04/07 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 3,258 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,064 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,088 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,230 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,599 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,246 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,574 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,659 reads

Introduction to MDX Scripting in Microsoft SQL Server 2005

This document describes how Multidimensional Expressions (MDX) for Microsoft SQL Server 2005 can be applied to common business problems. This document assumes some familiarity with MDX.  Read more...
By Additional Articles 2008/05/02 | Source: TechNet Blogs | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 3,103 reads

Set Functions: The StripCalculatedMembers() Functio

Business Intelligence Architect Bill Pearson continues his examination of MDX functions, this time introducing StripCalculatedMembers(). In this article, we expose the function, and then lead a hands-on practice session with examples that reinforce the concepts.  Read more...
By Additional Articles 2008/04/18 | Source: Database Journal | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 2,051 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,230 reads
   Items 1 to 20 of 22    Older >>
 
Tags
dimensions (4)    
cube (3)    
hierarchy (3)    
olap (3)    
blogs (2)    
clustering (1)    
design and theory (1)    
hierarchies (1)    
iif (1)    
rdbm (1)    
sample chapters (1)    
sql server 2005 (1)    
sql server 2008 (1)    
video (1)