CUBE and ROLLUp are older than SQL 2008, Grouping_ID is a function and not a subclause of group by.

Hence Grouping Sets is the only new feature introduced to GROUP BY...

Actually,

I managed to resolve this late on Friday...

When I basically coded an ISEMPTY result for the goal field that returned Null when the referenced field was empty, all the...

If the data_date field is indeed your Primary Key from what you've posted you have a problem.

What if two records have the same datetime stamp?

There are ways to work around...

lacelle (9/25/2009)

---

Hello again,

SELECT row_number() OVER (ORDER BY p_printerID) AS RecId

,[p_printerID] as PrinterID

,[pmh_pollDate] as HistoryDate

...

Temp tables that begin with one # are only available to that instances of the stored procedure. they get different names in the tempdb database so that each is...

If I can't force SSAS to not calculate KPIs when there is no data, should I instead cut my customer's dimension down to just those that I have records for?

Ok the client is Excel 2007.

The trouble is that when I bring a KPI status or KPI trend onto the cube view it gives them for dimension members that have...

I guess rather I should aski how to not perform KPI calculations when there is no data to perform them on. I can do that to a degree with...

I was until I realized that my formula to calculate standard deviation was wrong.

SELECT STDDEV(duration) FROM TABLE

yeilded something entirely different from the stddev I was calculating with my formula, so...

I've also been google searching a couple other problems.

So I wanted the Average duration for the cube... at each level.

What I noticed was that AverageofChildren was working fine until it...

Ok I misread what you had there...

So based on the Axis(0).currentmember.parent approach I tried this

(ABS(([Measures].[Average Loadtime])-(Axis(1).CurrentMember.Parent,[Measures].[Average Loadtime]))/(Axis(1).CurrentMember.Parent,[Measures].[Standard Deviation]))

I get back

the current member function expects a hierarchy expression for the...

Ok... now to figure out how to reference a higher level...

So I want to get the absolute value of the difference between a lower level's average and the higher level's...

Ok so I now am calculating Standard Deviations...

My problem was my dimension I was using for the count of them had a different name in my cube, but on the...

Hmmm which brings to the thought...

What if they use columns and rows?

Again... is there a really good tutorial on doing these sorts of things?

I've looked at the Microsoft tutorial on...

Hey Steve,

I've looked at creating MDX queries, but my problem is dimensions.

If I create a query that will calculate the standard deviation, as I understand it, I have to specify...