# Set Functions: The StripCalculatedMembers() Functio

• Article

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.

2008-04-18

# MDX Numeric Functions: The Min() Function

• Article

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

2008-02-25

# The Unpopular SELECT Statement

• Article

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.

4.33 (52)

You rated this post out of 5. Change rating

2009-01-30 (first published: )

# MDX Numeric Functions: The Max() Function

• Article

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

2008-01-29

# Compose MDX graphically

• QotD Question

You rated this post out of 5. Change rating

2008-01-24

# Set Functions: The .AllMembers Function

• Article

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

2008-01-04

# MDX Numeric Functions: The Max() Function

• Article

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

2008-01-02

# String Functions: The .Properties Function, Part II

• Article

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.

2007-11-05

# String Functions: The .Properties Function

• Article

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.

2007-09-14

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

• Article

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.

2007-08-17

## Blogs

### Connect With More Clients: Our Partner Directory Has Arrived

The partner directory connects your agency with new customers.

### Can You See Who Forced a Plan

I had an excellent group of people in Gothenburg Sweden when I taught there...

### Monday Monitor Tips–Finding CUs for My Instance

How can I quickly get a CU patch for a system that’s out of...

## Forums

### GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

### SSISDB: finding executions from an Execute Package Task

By Lowell

I am trying to find usage and non-usage of package sin my ssisdb catalog....

### workaround for problems that cant be try caught

By stan

hi a peer of mine recalls an error in an edi app that often...

Visit the forum

## Question of the Day

### Trigger Order III

I have created these triggers in SQL Server 2022:

```CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT
AS
PRINT 'one'
GO
CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT
AS
PRINT 'two'
GO```
I want to be sure that the trigger with "1" runs first. I decide to run this:
`EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'`
What happens?