Techniques in this MSDN paper, which discusses how to deal with slowly
changing dimesnions, may be useful:

http://msdn.microsoft.com/library/de.../en-us/dnolap/
html/slowly2.asp
Amir Netz
Microsoft Corporation

April 1, 1999

Summary: This article outlines several main types of slowly changing
dimensions. After showing how an online analytical processing (OLAP)
server operates when reading dimension members, the article then offers
ways to handle these and other real-world scenarios using Microsoft SQL
Server OLAP Services. (17 printed pages)
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thank you for the link. The article mentions dealing with this type of
dimension by creating calculated members and using the aggregate
function. Although useful for small dimensions, the example provided
doesn't work for my large level (400,000+ customer level members). In
addition, I've been unable to think of anyway of adapting this
solution to my problem. Anyone have an idea? I've considered pulling
the records into an array or even submitting the MDX via SQL Server
OpenQuery and collapsing the rows...

Deepak Puri <deepak_puri (AT) progressive (DOT) com> wrote