no this is purely an equals or not equals, the same code works fine on dozens of other sql 2k sites. Theres a foreign key with nocheck on that column...

turning off drillthrough for the cube before processing can fix som consistency problems like this. if its a shared dimension this will need processing as well as the cube.

The blank values are nulls, if you want these to be assumed to be 0 then you need to get rid of the nulls in the sql used to generate...

you could take a look at business scorecard accelerator, I would think this would be an indication of how it will progress..

You need OWC installed on the server for sharepoint if interfacing with cubes, this could be the reaon...

its strange i tried your page yesterday & it was working?? the parameters came up & the report started to render, didnt wait to see the results so I assumed...

I think that companies will always go for software that gives them a competitive advantage. Many web retailers use open source as its far cheaper & does the job.

have you tried restarting iis?

I would guess that somewhere along the line between the web server, report services and sql server some privileges are required that the session doesnt have! judging by the message...

A great way of finding out more about system tables is to look at the system stored procedures in the master database, whenever I need to find out something about...

Thanks thats a really useful article, not what i wanted to hear though!

Sounds fine to me, I'd go with the web based client though, unless its going to be administered by someone who doesnt know what theyre doing as its properly tested...

We're planning to extend form based security to the reports as users may be over the web or in intranet. Parameters selected via our generated asp pages rather than using...

We just add the tables whether they have the additional application or not. This could be confusing for someone writing a report but takes a lot of complexity out of...

just keep it simple, make a list of pros and cons and run through list with colleagues.