Skip to Content
avatar image
Former Member

Analysis for OLAP vs Excel

I haven't been able to find a document outlining the differences between Analysis for OLAP vs. Analysis for Excel. I've been working mainly with accountants, so we've been using OLAP for Excel because they are already comfortable with Excel. However, it has been suggested to me that Analysis for OLAP has features not available with the Excel version. Is this true, and if so is there a document or website outlining the difference in features?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 26, 2014 at 03:28 PM

    Probably the most recent comparison is attached to this KBA:

    My take is accountants will be more happy with Analysis Office for Excel; accountants work most of the time in Excel anyway

    Analysis OLAP has some nice features like conditional formatting preview, focused analysis - it is all web based and part of the BI platform

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Tammy,

        Ao workbook displaying # or Not assign but same query I'm executing through Bex analyzer it's displaying empty cell please find the below screen shot. I have to display empty cells instead of not assign. Kindly help me

      Bex Output                                        Analysis office 1.4 Output



      Alagappan R