Is there no way you can use the object model instead? 

If you really have to use an XML approach then it will definitely help if you can use another...

Depending on your situation you could always select the fields you're actually interested in rather than simply doing a 'select *' over the openrowset.

Just remember to double-up your (closing) square...

Definitely, yes, we do this quite often (have an enterprise app that clients opt to upgrade for the AS/cubing but can't simply cut across to the SQL2K5 immediately).

Did you try using IsEmpty versus trying for equality to null?

I understand where you're coming from re: anomaly tracking however I'd argue that if you're truly tracking the anomalies, then...

Perhaps try using [Don].[Don].Members rather than .Allmembers?

I knew i'd seen something better more recently -> grab yourself the May edition of SQL Server Magazine; there's a 5 page article on how to do exactly this (repository...

Just out of interest, have you looked to see if the Health & History tool could do some of the heavy lifting for you?

Just to clarify, you don't need SQL Server installed to have AS installed, if you decide you don't need/want it.  If you're using SQL 2005, it's a single installer and...

I'd say you need a new dimension, the ORder Count Group dim.  It's likely that this dim would be related only to a new, higher level aggregate fact table.  In...

I'm guessing from the schema you've supplied that you don't actually keep the original of the subsequently changed record(s)?  If you've  not kept the original, what test would you use...

I'm thinking that maybe use of the GENERATE function in conjunction with something like DESCENDANTS could give you what you want.  Along the lines of GENERATE([ProdCat].[blah01]:[ProdCat].[Blah99], DESCENDANTS([ProdCat].CURRENTMEMBER, [ProdCat].[SubCat]))  The idea...

If I had my choice, I would get Chris Webb to deliver hs recently created MDX course but i'm thinking he wouldn't fly out to Aus for cheap.  So failing...

I don't personally have any samples but the following links should give you some clear info on how to implement them and also things to be aware of when using...

Hey Sam,

Are you using 2005 or 2000?  If 2005 then I think you might have to write your formula using either case or nexted IIF's to pre-determine the hierarchy.  There...

Again, not sure which version you're using but if it's AS2K5, then you could write a Stored Procedure (look them up in BOL) which returns the character value based on...