Newbie: Frontent for SQL-Server Analysis Service

Discussion in 'microsoft.public.sqlserver.olap' started by arno, May 13, 2008.

  1. arno

    arno Guest


    I've been using OLAP cubes on an IBM AS/400 for years, now I am
    investigating how to work with cubes in an windows environment.

    So far, I found Applix TM1 and MIS ALEA (both have new owners and maybe new
    names) that have nice frontends for MS Excel. Then I found Jedox Palo which
    may not be powerfull enough and I had performance problems when testing,
    however, the frontend in Excel is nice (except for missing zero suppression)
    and easy to use.

    But there are als the MS Analysis Service of SQL-Server. I find a lot of
    information on server issues but what is the frontend that can be used in
    Excel? I read about (relatively complicated?) MDX queries or external
    datasources like pivot tables.

    Are there commercial Addins for Excel to query SQL-Server Analysis Services?

    I'd appreciate any help on the basics regarding the frontend to Analysis


    arno, May 13, 2008
    1. Advertisements

  2. Arno,

    Excel 2007 with Analysis Services 2005 works great without any additional
    tools. It is very powerful! If you add Microsoft SharePoint, you will have
    repository - central location for your connection strings and for your
    reports. And as SharePoint 2007 comes with Excel Services, users who do not
    have Excel 2007 will be able to browse published reports with limited

    Here is the list of all client tools that work with Analysis Services 2005:


    Vidas Matelis
    Microsoft SQL MVP
    Vidas Matelis, May 14, 2008
    1. Advertisements

  3. arno

    arno Guest

    Hello Vidas,
    we have Excel 2003, I do not see chances to switch to 2007. So, I'll need
    one of the client tools you listed, right?

    I am wondering if I can fire MDX-statements directly from Excel 2003 (like I
    could do with normal transact-sql using ADO) and receive the result in an
    Excel sheet? Are there any sample files available (I mean Excel files with
    MDX queries to Sql server analysis services)?
    Is it worth while to wait for SQL Server 2008 as I will setup everything
    from scatch during the next months? Or are there no substancial changes
    between SQL 2005 and 2008 regarding Analysis Services?

    wow, that's a long list, thank you. Are there any feature comparisons
    between those tools available? (eg. XLCubed Demo looks very impressive)

    arno, May 14, 2008
  4. arno

    arno Guest

    arno, May 14, 2008
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.