I'm looking for a good analysing program for our end-users.
It needs to be able to :
So it should be more or less the combination of MS Access and MS Excel, but only in read mode to the database.
So any one using such a tool please let me know.
You seem to have listed the available tools, allowing that level of freedom will surly allow the queries from hell to hit your database so good luck.
I would have thought the office suite was the answer. Could be Performance Point Server will do the trick, but I've not installed this yet to know for sure.
The users will only get access to a datawarhouse not on the production db.
But thanks for the info.
I am a bit biased but you might want to take a look at Cizer's Products. We have two core capabilities within our CNR platform. One is the ability to design Reporting Services RDL compliant reports in the browser (think of it as zero footprint Report Design similar to Visual Studio's report designer). The second capability is provided via our QuickQuery technology which gives users the ability to browse schema objects to which they have rights and then build a Reporting Services compliant RDL report via a few simple selections for included columns, filtering, sorting, and basic formatting including uploading a logo.
We have videos and plenty of references on our website for how our technology works. The best news is our technology is a cost effective addition that takes full advantage of the Reporting Services licensing you likely already own. We also expose much of our functionality via webservices in a Drop In Reporting Development Kit.
Our website is www.cizer.com.
Drop me a line if you like tjohnson AT cizer DOT com. I'd welcome the chance to discuss further.
Here is another tip ExOpen Report, it's an Excel add-in, that makes the Excel Pivotable Wizard look like kindergarden.
It's a Swedish company www.exopensystems.se, I started out with a 30-days trialversion, contact them so you can evaluate for yourself.
Don't use Cognos. It sucks.
Don't use Hyperion. Oracle just bought it, you don't know what would happen to this product.