Hi Chris,

Firstly, are the two date functions in a SQL or OLEDB compliant DB? If so, then you could use a SQL (execute) task to run the storedprocedure(s) and...

Hi Jen,

I think the following does what you want, but before putting it into production, I would ensure that you're happy that the count measure is working as expected in...

Can you give me a hint on the basis of your re-writes? We have started doing our set definitions at the start of the query (ie WITH SET statements)...

If you look up a doc on MSDN about using Large Dimensions With OLAP Services (I know that this is from SQL 7, not 2K, but it's a pointer at...

I agree re:workflow, but what takes precedence? I haven't used VB to call a job like this (ie step by step) but the logic reads to me like you...

Why do you want to Sum the NULLS? And more importantly, how would you *like* them summed?

If you have a critical need (in your...

Hi Samui,

Further to this post, I also posted on Msft OLAP newsgroup, where George S replied, gist of reply was that functions used in MDX may be causing execution...

Hi,

Not that it will make you feel any better, but we experience exactly the same type of issue - AS doing virtually no work, and PTS doing basically everything....