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 Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4627 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 Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4627 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 Rookie
SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)

Group: General Forum Members
Points: 44 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 Rookie
SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)

Group: General Forum Members
Points: 44 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
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3534 Visits: 3350
Have you looked at reporting service that came with SQL Server 2005?
michanne
michanne
SSC Veteran
SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)

Group: General Forum Members
Points: 291 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
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 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
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3534 Visits: 3350

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