Good analysing, reporting end-user tool ??

Question

Good analysing, reporting end-user tool ??

Serge Josse

SSC-Addicted

Points: 436
More actions
February 14, 2007 at 2:21 am

#172252
Hi,
I'm looking for a good analysing program for our end-users.
It needs to be able to :
1. build queries with a simple GUI(see MS Access)
2. build pivot reports
3. build regular reports
4. save the reports
5. save qeuries as templates
6. export the results to other formats(excel)
7. pass parameters with a simple GUI
8. easily filter the results (see excel data filter)
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.
Thanks
Serge

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 1

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.

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Serge Josse SSC-Addicted Points: 436 More actions · Answer 2

The users will only get access to a datawarhouse not on the production db.

But thanks for the info.

rgds

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 3

you don't think a user can bring a DW server down with a query ? check out Business Objects !!

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

trey_johnson Mr or Mrs. 500 Points: 568 More actions · Answer 4

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 http://www.cizer.com.

Drop me a line if you like tjohnson AT cizer DOT com. I'd welcome the chance to discuss further.

Cheers,

Trey Johnson | Chief Business Intelligence Architect | Cizer Software (www.cizer.com)

Who? - Cizer - http://www.cizer.com/about.htm - Blog - http://www.sqlserverbi.com/
What? - Products enhancing Microsoft Business Intelligence - http://www.cizer.com/products.htm
Wow! - Empower your Developers.... NEW Drop In Reporting - http://www.cizer.com/cnr-drop-in-reporting.htm
How? - BI Training - http://www.cizer.com/training.htm - Cizer Solutions - http://www.cizer.com/solutions.htm

trey_johnson Mr or Mrs. 500 Points: 568 More actions · Answer 5

I also forgot to mention that we present the user with parameters from global parameter libraries which you can configure, provide fine grained data access permissions and support the ability to upsize QuickQueries into Reports which are then shared based on roles and the security model.

Trey Johnson | Chief Business Intelligence Architect | Cizer Software (www.cizer.com)

Who? - Cizer - http://www.cizer.com/about.htm - Blog - http://www.sqlserverbi.com/
What? - Products enhancing Microsoft Business Intelligence - http://www.cizer.com/products.htm
Wow! - Empower your Developers.... NEW Drop In Reporting - http://www.cizer.com/cnr-drop-in-reporting.htm
How? - BI Training - http://www.cizer.com/training.htm - Cizer Solutions - http://www.cizer.com/solutions.htm

Loner SSC-Insane Points: 21279 More actions · Answer 6

Have you looked at reporting service that came with SQL Server 2005?

michanne SSCrazy Points: 2329 More actions · Answer 7

I am totally impressed with Dimensional insight's Diver. Great for adhoc analysis and pretty intuitive but it would really depend on your users and how they want to use it.

rnd Valued Member Points: 67 More actions · Answer 8

Hi

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 http://www.exopensystems.se, I started out with a 30-days trialversion, contact them so you can evaluate for yourself.

Loner SSC-Insane Points: 21279 More actions · Answer 9

Don't use Cognos. It sucks.

Don't use Hyperion. Oracle just bought it, you don't know what would happen to this product.

Jeswanth Jaishanker SSCommitted Points: 1869 More actions · Answer 10

Any one tried QlikView ? http://www.qliktech.com/Home.asp?id=4

jeswanth .

--------------------------------

barbara.sorkin Newbie Points: 3 More actions · Answer 11

Are the products compliant with SQL Server 2012? The available information seems to reflect the 2005 version and nothing more current.

Paul Hernández SSCarpal Tunnel Points: 4961 More actions · Answer 12

I know this is a SQL Server and Microsoft flavour Forum, but I would try at least the Pentaho Reporting tools

Paul Hernández

aaron.reese SSChampion Points: 13498 More actions · Answer 13

My first port of call would be Reporting Services:

You can build a DW which allows users to create simple drag and drop reports but still provides enough flexibilty for advanced development of more in-depth reports. It plays quite nicely with sharepoint and can be scheduled using SQL agent to generate reports for emailing / publishing on sharepoint

Oh did I mention it is free (as in it comes as part of the SQL bundle)

The organisation I am at also use QlikView onto 2005 but I don't much care for it because it builds .qvd files which are its own data store

herladygeekedness SSCertifiable Points: 5878 More actions · Answer 14

barbara.sorkin (6/11/2013)
Are the products compliant with SQL Server 2012? The available information seems to reflect the 2005 version and nothing more current.

Given how old this thread is, that is no surprise.