LookUpCube Function MDX Query Performance Test

In my previous blog post, I mentioned that there was a performance cost for using the LookUpCube function. Well recently a coworker asked me just home much of a performance hit was the LookUpCube function going to cause. So I decided to conduct a test. I wrote two simple MDX queries (one using the LookUpCube function and one not), then executed the queries (6 times each: 3 w/ cold cache and 3 w/ warm cache) while running SQL Server Profiler and compared the duration times of the query. Read more...