• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Ad-Hoc Application and Excel... > Crystal Analysis Excel Plug-in

Crystal Analysis Excel Plug-in

Similar to the Crystal Enterprise Add-in for Excel covered in the previous section, the Crystal Analysis Add-in for Excel exposes the power of Crystal Analysis (CA) from within Excel. However, the CA Add-in differs in that it does not report directly from existing CA workbooks stored in Crystal Enterprise—instead it connects to a cube and works from there. The Crystal Enterprise ActiveX viewer for Crystal Analytic reports and the thick client CA designer also enable exported CA views to the Excel Add-in and enable continued analysis from within Excel.

End users find that the CA plug-in offers very much the same interface that they are accustomed to within the CA worksheet, and offers the capability to massage a view, or several views, at a time, and then tie them together using standard Excel formulas and functionality. This flexibility facilitates much more self-service. The user interface, although powerful, uses simple concepts that enable data manipulation that most users prefer to Excel's own pivot tables, which require quite a bit of training to properly use.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint