SQL Server Central: Content tagged MDX

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 | Category: MDX

Rating: (not yet rated) Rate this |

Briefcase | 1,955 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 | 1,086 reads

MDX Numeric Functions: The Min() Function

Business Intelligence Architect Bill Pearson introduces the numeric Min() function, and leads hands-on practice examples of its use. Read more...

By Additional Articles 2008/02/25 | Source: Database Journal | Category: MDX

Rating: (not yet rated) Rate this |

Briefcase | 878 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 2008/02/20 | Source: SQLServerCentral.com | Category: MDX

Rating:

|

Discuss |

Briefcase | 13,494 reads

MDX Numeric Functions: The Max() Function

Business Intelligence Architect Bill Pearson introduces the numeric Max()function, and leads hands-on practice examples of the basic concepts. Read more...

By Additional Articles 2008/01/29 | Source: Database Journal | Category: MDX

Rating: (not yet rated) Rate this |

Briefcase | 983 reads

Compose MDX graphically

Building a Localized Report on a SQL Server 2005 Analysis Service Cube Data Source

Learn how to use an Analysis Services cube as a data source by using parameterized MDX queries, as well as how to localize label strings in a report, in SQL Server 2005. Read more...

By Additional Articles 2008/01/07 | Source: TechNet | Category: SQL Server 2005

Rating: (not yet rated) Rate this |

Briefcase | 1,169 reads

Set Functions: The .AllMembers Function

Business Intelligence Architect Bill Pearson introduces the useful .AllMembers function, reinforcing the basic concepts, as always, with hands-on practice examples. Read more...

By Additional Articles 2008/01/04 | Source: Database Journal | Category: MDX

Rating: (not yet rated) Rate this |

Briefcase | 1,200 reads

MDX Numeric Functions: The Max() Function

Business Intelligence Architect Bill Pearson introduces the numeric Max()function, and leads hands-on practice examples of the basic concepts. Read more...

By Additional Articles 2008/01/02 | Source: Database Journal | Category: MDX

Rating: (not yet rated) Rate this |

Briefcase | 1,199 reads

String Functions: The .Properties Function, Part II

Business Intelligence Architect Bill Pearson continues his hands-on introduction to the .Properties function. In this article, we examine the use of the TYPED flag within the .Properties function to deliver a strongly typed value using .Properties. Read more...

By Additional Articles 2007/11/05 | Source: Database Journal | Category: MDX

Rating: (not yet rated) Rate this |

Briefcase | 1,411 reads

String Functions: The .Properties Function

Business Intelligence Architect Bill Pearson introduces the basic .Properties function, within the first of a two-part article surrounding this important member of our MDX toolsets. Read more...

By Additional Articles 2007/09/14 | Source: Database Journal | Category: MDX

Rating:

Rate this |

Briefcase | 1,974 reads

Logical Functions: IsGeneration(): Conditional Logic within Filter Exp

Use IsGeneration() to support conditional logic within filter expressions. BI Architect Bill Pearson looks beyond employing IsGeneration() in calculations, and provides hand-on practice in its use within the MDX Filter() function. Read more...

By Additional Articles 2007/08/17 | Source: Database Journal | Category: MDX

Rating:

Rate this |

Briefcase | 1,256 reads

Different forms of CrossJoin

This article is about different syntactical ways to write CrossJoin in MDX, all of which are completely equivalent from the functional and performance standpoint. Therefore, the article doesn't convey any practical information, and can be ignored. Readers curious about history of MDX can keep reading, however. Read more...

By Additional Articles 2007/03/16 | Source: MSDN Communities | Category: MDX

Rating:

Rate this |

Briefcase | 3,173 reads

Logical Functions: IsAncestor(): Conditional Logic within Calculations

Use IsAncestor() to support conditional logic within calculations. BI Architect Bill Pearson introduces IsAncestor(), and then leads a hands-on practice session with this valuable MDX function. Read more...

By Additional Articles 2007/02/15 | Source: Database Journal | Category: MDX

Rating:

Rate this |

Briefcase | 1,644 reads

Content with tag MDX

Refine your search with one of the following additional tags (with number of items):