sorry it's taken a few days to get back to you.

I suspect it not actually anything to do with the result set. Double check your SQL statement is correct.

When...

highly unlikely that they will - it's a poorly...

Hi Simon.

the RSExecRole wasn't something I ever really considered - most likley because I never encountered an issue with security and accessing the report server db.

As you mention it, my...

damn it. I suspected as much.

The 'largest values' row size I have to deal with is a horendous 4276 bytes! the actual data contained in the fields is probably...

two things to double check first.

1 - when mapping the parameter User::TxType variable. make sure you set the Parameter name to 0 (zero) (by default it'll be something like...

OK thanks for your input. It's all useful stuff.

we had a demo actually from one of our support suppliers and they did make a comment that there consultancy experience has seen SSAS cubes perform better than Cognos cubes....

Thats what I like to hear 🙂

thanks guys. All interesting comments to read.

Should we move to a MS solution then it's definately going to be at least SQL 2008. I am pushing...

Here is a PDF copy of the article with images for those that can't see them. ( I can only guess it's because you can't access the flickr server...

images are hosted on flickr - but they should be fine.

Also I guess...

Bertil Forsberg: I've learnt something new today! every day is a school day. 🙂

fszendzielarz: Partitioning for me was not an option as we are only using SQL Server...

ha ha - it actually might be! Things don't move that fast where I am.

I would certainly be very interest to hear your views on both. I'm quite...

Hi Karen

I'm a real newbie when it comes to web services, so forgive me if I ask any stupid questions.

Is possible you can provide me with an example of how...