I too care about my points... but that's immaterial.

I can confirm that the results will be -1,0,1 on SQL 2000, 2005, 2008 and 2008 R2 I didn't even need...

Oh it's not an average over time.

It's Two dimensions being used to calculate the average/Mean for each cell.

Sum of Loadtime / Count of records of Loadtime

Gah show my rust.

Ok when I gave the new group rights to the SSRS server, I didn't click on Home as my admin account, then click properties, and put the...

I did that like this.

CREATE MEMBER CURRENTCUBE.[Measures.[Median of Enterprise Users]

AS MEDIAN([Enterprises and Users].[Users].[All].Children,[Measures].[Average Loadtime] ),

VISIBLE = 1;

I found when brought onto the data space, it would...

I take it back... It's there now (not sure why), and indeed if I go to pivot table options I can make it show up. 🙂

Awesomeness. At least...

But the built in browser for BIDS should show it by default right?

Because it doesn't show it either. :/

Thanks Steve,

I'm glad to know I at aleast got the formula right for the calculation.

I'm not writing MDX, just using Excel or the built in browser to look at...

Ok after analyzing a sample cube, I figured out that what I wanted, which is a Median measure of the values underlying the base cells is basically not doable with...

I used...

246747 (5/20/2010)

---

The way to not grant the user access to...

Tim Cullen (5/20/2010)

---

One of the things I do during development of a stored procedure that includes dynamic SQL is instead of executing the statement I PRINT (http://msdn.microsoft.com/en-us/library/ms176047.aspx) the statement. ...

Grant Fritchey (5/20/2010)

---

I'm sorry to disagree with you here, but dynamic queries do get cached. And if you build them using the parameterized approach, they can get reused too. I...

bjarup (5/20/2010)

---

Nice writeup.

Maybe I am a bit off topic, but I would never allow null values to pass through to the select statement in a procedure if the tables underneath...

tasneem 27027 (4/21/2010)

---

insert into a (b) values (1), (2), (3)

This would ideally give you an exception at the insert statement. Because as far I know the comma seperated value insertion...

Got it right, but there's apparently an edition missing...

Evaluation Edition... granted I think that's Enterprise with an expiration, but still. 🙂

http://msdn.microsoft.com/en-us/library/bb933866.aspx