Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2002
    Location
    Chicago
    Posts
    3

    Question Unanswered: 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. Hertel

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Check out the following link:

    link

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Here is a bigger list:

    list

    But the hungry dog intellibrowser is pretty good.

  4. #4
    Join Date
    Sep 2002
    Location
    Seattle, Washington
    Posts
    1
    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/de...components.asp

    Good luck

  5. #5
    Join Date
    Jan 2003
    Posts
    1

    Thumbs up Panorama Novaview

    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...rticleID=26486

    There are many tools on the market, but this is the short list.

  6. #6
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    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/data...er/default.asp


    jiri

  7. #7
    Join Date
    Sep 2003
    Location
    Nuernberg, Germany
    Posts
    36
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •