Have Suggestions for a Front End Tool?

I am currently using Microsoft Excel pivot tables to access data cubes from SQL Server 2002 as a front end tool for users to access sales data. I have run into issues when I am asking the pivot to filter too much. Does anyone have any suggestions on another frontend tool for cubes that does not run into limitations like Excel does? A 3rd party tool? I know Access could be used but I would like to purchase something not write a program?

Thank you,

Carla C. HertelCheck out the following link:

link (http://www.hungrydogsoftware.com/)|||Here is a bigger list:

list (http://www.dwinfocenter.org/olap.html)

But the hungry dog intellibrowser is pretty good.|||Have you checked out Microsoft's pivot table Office Web Component? If you haven't it might be worth a look.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrworkingwithofficewebcomponents.asp

Good luck|||Panorama Novaview http://www.pansw.com/ OLAP front-end is made by the same company that licensed Microsoft the OLAP server technology for Analysis Services. It has write-back capabilities unlike Bus Obj, Cognos, Crystal et al and some nice features like bubble-up exceptions, wizards for query creation and good thin-client support.

SQLmag published a review of the leading OLAP front-ends for Microsoft Analysis Services:

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=26486

There are many tools on the market, but this is the short list.|||i can recommend BusinessObjects - although some dum people (like our MIS dept) use universes only, BusinessObjects can work with MS Analytical Servicers just fine. Business Objects is more reporting tool. They have also special add-in into Excel called BusinessQuery.

microsoft has data analyzer (it's 100% analytical tool) http://www.microsoft.com/office/dataanalyzer/default.asp

jiri|||Hi,

as a client tool we use Q4bisAnalysis.
A quit nice little tool which could be learned within minutes.

More infos:
www.q4bis.com

regards

Michael

Hardware considerations for Report Server?

Hi all,
we use SSRS based on SSAS Cubes.
We thought about installing SSAS on one server, the relational data on an
other SQL Server and put the Report Server with the IIS 6.0 on a third
machine.
As we haven't any experiences with load and performance for BI-Applications
I'm wondering how many memory we should buy for each server.
The idea of our system service is the following:
32 GB for the analysis server
16 GB for the relational database server
4 GB for the web and reporting server
I have the impression that the 4 GB for the web/reporting server is too few,
but memory for the two others sounds pretty good.
What do you say?
Thanks a lot for any answers...
Cheers
MarcYou didn't talk about the expected load on the server and the number of
CPU's. My experience is that 4 GB is fine but I would want multiple CPUs. If
you design the way you should (i.e. limit the data at the source and limit
the report to what the user needs to see) then that configuration will be
pretty darn good. I would look at 4 CPU (but again, it depends on your
load).
Without knowing the load (expected number of reports per hour for instance),
it is really hard to say.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Marc" <Marc@.discussions.microsoft.com> wrote in message
news:17E86835-FF86-429F-8424-A7BE431093B1@.microsoft.com...
> Hi all,
> we use SSRS based on SSAS Cubes.
> We thought about installing SSAS on one server, the relational data on an
> other SQL Server and put the Report Server with the IIS 6.0 on a third
> machine.
> As we haven't any experiences with load and performance for
> BI-Applications
> I'm wondering how many memory we should buy for each server.
> The idea of our system service is the following:
> 32 GB for the analysis server
> 16 GB for the relational database server
> 4 GB for the web and reporting server
> I have the impression that the 4 GB for the web/reporting server is too
> few,
> but memory for the two others sounds pretty good.
>
> What do you say?
> Thanks a lot for any answers...
>
> Cheers
> Marc

Handling database connection errors

If my database goes down, i get a popup error with the red x saying can't
connect to database, can't find the cubes, or the cubes are busy, etc...
Is there a way to change the error message to say:
"Report Cubes are being refreshed right now, please try again" in the
popup.
Or point to another page?No this is not possible, unless you implement your own custom data extension
which wraps the original data provider and throws specific exceptions with
your custom error message (which will then show up as inner error message).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:OfpbodJ3EHA.2804@.TK2MSFTNGP15.phx.gbl...
> If my database goes down, i get a popup error with the red x saying can't
> connect to database, can't find the cubes, or the cubes are busy, etc...
> Is there a way to change the error message to say:
> "Report Cubes are being refreshed right now, please try again" in the
> popup.
> Or point to another page?
>|||Is this an IIS thing?
Easy to do?
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OxvRcpP3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> No this is not possible, unless you implement your own custom data
extension
> which wraps the original data provider and throws specific exceptions with
> your custom error message (which will then show up as inner error
message).
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Cindy Lee" <cindylee@.hotmail.com> wrote in message
> news:OfpbodJ3EHA.2804@.TK2MSFTNGP15.phx.gbl...
> > If my database goes down, i get a popup error with the red x saying
can't
> > connect to database, can't find the cubes, or the cubes are busy,
etc...
> >
> > Is there a way to change the error message to say:
> >
> > "Report Cubes are being refreshed right now, please try again" in the
> > popup.
> >
> > Or point to another page?
> >
> >
>