Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Good analysing, reporting end-user tool ?? Expand / Collapse
Author
Message
Posted Wednesday, February 14, 2007 2:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 13, 2007 2:11 AM
Points: 16, Visits: 1

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

Post #344752
Posted Wednesday, February 14, 2007 4:32 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:08 AM
Points: 2,674, Visits: 695

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 GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #344776
Posted Thursday, February 15, 2007 8:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 13, 2007 2:11 AM
Points: 16, Visits: 1

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

But thanks for the info.

rgds

Post #345160
Posted Thursday, February 15, 2007 3:27 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:08 AM
Points: 2,674, Visits: 695
you don't think a user can bring a DW server down with a query ? check out Business Objects !!

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #345320
Posted Thursday, February 22, 2007 9:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 06, 2007 11:16 AM
Points: 34, Visits: 8

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.

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
Post #346882
Posted Thursday, February 22, 2007 9:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 06, 2007 11:16 AM
Points: 34, Visits: 8
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
Post #346883
Posted Wednesday, February 28, 2007 6:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 8:31 AM
Points: 2,800, Visits: 3,041
Have you looked at reporting service that came with SQL Server 2005?
Post #348102
Posted Wednesday, February 28, 2007 12:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, July 27, 2013 8:41 PM
Points: 241, Visits: 168
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.


Post #348259
Posted Friday, March 16, 2007 7:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 10, 2014 6:03 AM
Points: 1, Visits: 104

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

 




Post #352060
Posted Monday, March 19, 2007 3:21 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 8:31 AM
Points: 2,800, Visits: 3,041

Don't use Cognos. It sucks.

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

Post #352523
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse