SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Good analysing, reporting end-user tool ??


Good analysing, reporting end-user tool ??

Author
Message
Serge Josse
Serge Josse
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 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


colin.Leversuch-Roberts
colin.Leversuch-Roberts
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12113 Visits: 715

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/
Serge Josse
Serge Josse
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 1

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

But thanks for the info.

rgds


colin.Leversuch-Roberts
colin.Leversuch-Roberts
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12113 Visits: 715
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/
trey_johnson
trey_johnson
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 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
trey_johnson
trey_johnson
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 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
Loner
Loner
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6392 Visits: 3364
Have you looked at reporting service that came with SQL Server 2005?
michanne
michanne
SSChasing Mays
SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)SSChasing Mays (609 reputation)

Group: General Forum Members
Points: 609 Visits: 182
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
rnd
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 144

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.





Loner
Loner
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6392 Visits: 3364

Don't use Cognos. It sucks.

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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search