Thanks all.

I probably will have use for a tally table in future so have gone for that option.

And I didn't use the While Loop when generating it

Thank you very much!

This is how I modified it (I don't have access to the master db) - and added more rows

DECLARE @count INT

SET @count = 1

DECLARE @TALLY...

This is now fixed. It was simply a permissions issue. Once the role was modified to allow the correct permissions on the cube the data was visible in...

Or does it work if you access it via https:// rather than http://?

What is the error message you are getting? What OLAP provider are you using to connect?

Hi Carolyn! This is a very helpful article, thanks. We are upgrading to SQL 2005 this week so this article will prove very useful to double check we...

That's a really nice tip - it worked for me too. I inherited a few encrypted jobs when I took over this position so have now been able to...

Hi Steve,

Just wanted to say thanks for pushing me in the right direction - that worked. It's a huge weight off my mind, so it's much appreciated. If...

I've looked at the package logs and you're right (of course, not that I doubted it) they were being incrementally updated in the dts. So ignore my last post....

Hi Steve,

No the dts doesn't process the dimensions first. To be honest, I don't know how to set that but it wasn't set for the old cubes either. ...

Great article, very impressed!