Nice article I'd agree that it is my first time seeing CROSS APPLY as well.

Another one busted the dust out on me...

duda (12/9/2009)

ALTER CUBE CURRENTCUBE

Update DImension [Date].[YearQuarterMonthDay],

Default_Member = StrToMember("Tail(Filter([Date].[YearQuarterMonthDay].[Month Name And Year].members,

...

Thanks guys, even though it took time for me to update you with this regard.

The main issue as to why I raised this is that I have 1 time dimensions...

Beaten but a leeson learned should never be learned again.

Got it right but I didn't understand the question. I actually thought that the question meant to say DATETIME but indeed it was DATE and TIME.

RBarryYoung (8/4/2008)

There's not much that I...

I cannot seem to find what the issue is with the relationships nor the properties of the non-working dimension. I have decided to re-create the time dimension. Instead of creating...

I just took my chances but I was pretty sure that I have never seen the SP_Compatibility sysprocedure and the sp_help was not even an option for me.Nice Q though

didn't know much about PLINQ but this increased my knowledge:

http://blogs.msdn.com/pfxteam/archive/2009/06/13/9741072.aspx

Nice one, Noticed that when you use your case statement as per below then you get the "Date is Null" results as you do not have your else statement.

SELEC CASE...

Amen

Warren Brunk (7/15/2007)

<SPAN id=Showtread1_ThreadRepeater__ctl3_lblFullMessage>On my box the service is called "SQL Server Analysis Services (Named Instance)".</SPAN>

<SPAN>This answer wasnt even listed on the choices. But whatever even the questions makers can...

I haven't done an MDX qry that gets data from 2 cubes and I tried querieng a cube from another and oI got an error.

I suppose I missed something: http://msdn.microsoft.com/en-us/library/ms191301.aspx