Create Calculated Members That Are Elegant and Perform Well

Friday Jan 25th 2008 by DatabaseJournal.com Staff
Share:

It's not uncommon for MDX programmers to create an elegant calculated member, only to discover that it's so slow that it can't be used in queries against a full data set. Learn why performance problems can occur and ways to work around those problems.

[From SQL Server Magazine]

MDX programmers like calculations that are elegant (i.e., a solution that is simple yet powerful and easy to maintain) and have good query performance. However, it’s not uncommon for MDX programmers to create a calculated member whose business definition and initial implementation are elegant, only to find out later that the member is so slow that it’s unusable in queries against a full data set.

The article continues at http://www.sqlmag.com/Articles/ArticleID/97790/97790.html?Ad=1

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved