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.

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.

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.

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.

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.

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.

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.

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.

RE: Adhoc - Prepared queries

An example of a prepared query is a stored procedure. This is precompiled on the server in advance of execution and therefore has performace benefits (e.g the execution plan is optimized in advance of running the sp).An adhoc query is a generic submission of sql to the server that, because it is not defined in […]