Excel Add-in vs. Smart View (overall) | Excel Add-in | Smart View |
Excel | Yes | Yes |
Word, PowerPoint, Outlook | No | Yes |
Essbase | Yes | Yes |
FM and Planning | No | Yes |
Reporting and Analysis Modules (FR, WA, IR) | No | Yes |
Copy and Paste Data Points across Office | No | Yes |
Visual Data in Excel from Word or PowerPoint | No | Yes |
POV Manager across Office | No | Yes |
Showing posts with label Excel Add-in. Show all posts
Showing posts with label Excel Add-in. Show all posts
Sunday, October 12, 2008
Excel Add-in vs. Smart View 9.3.1 - 50,000 Foot View
This tables compares the Excel Add-in vs. Smart View from a high level. The main point you'll find here is that the Excel Add-in only works with Essbase and Excel while Smart View works with the full suite of Hyperion products and with all of the Office products (including PowerPoint and Word).
Saturday, October 11, 2008
Excel Add-in vs. Smart View 9.3.1 - Essbase Analysis
Have you made the switch from our beloved Excel Add-in to the Smart View Add-in? I've been slow to make the change too (I love the Excel Add-in and can use it in my sleep). But Smart View 9.3.1 makes a compelling case and version 11 seals the deal for me (feature comparison for 11.1.1 coming soon). Here is a side-by-side comparison of the Excel Add-in vs. Smart View (for Essbase) features:
Excel Add-in 9.3.1 | Smart View Add-in – Essbase 9.3.1 | |
Drill Capabilities | Yes | Yes |
Keep only, Remove Only | Yes | Yes |
Member Selection | Yes | Yes |
Query Designer | Yes | Yes (different) |
Retain Formulas | Yes (must select formula preservation) | Yes (by default) |
Formatted Reports | Yes | Yes |
Cell Text / LROs | Yes | No |
Adjust function | No | Yes |
DTS | Yes | Yes |
Substitution Variables | Yes | No; Coming Soon |
Member name referenced in a linked formula | Yes | No; Coming Soon |
Cascade | Yes | No; Coming Soon |
Ancestor Position | Yes | Yes |
Use Excel Formatting & Cell Styles | Yes | Yes |
Flashback / Undo | Yes – One Undo | Yes – Multiple Undo’s |
POV Manager – Copy and Paste POVs | No | Yes |
Share POVs | No | Yes |
Define Default Starting POV | No | No; Coming soon with Smart Slices |
Multi-Source Grids / Reports | Yes | Yes (using data points) |
Alias Table defaults to Default | Yes | No |
Submit Data to Essbase | Yes | Yes |
MDX vs. Rpt Script | Rpt Script | MDX |
Copy / Paste Data Points | No | Yes |
Refreshable Essbase Data in Word and PowerPoint | No | Yes |
Visualize in Excel | No | Yes |
Launch business rules | No | No |
Subscribe to:
Posts (Atom)
