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 |
I wish you love
7 years ago
2 comments:
Hi there,
This table is really useful.
Any chances that you could provide an updated table for v11.x equivalent versions of the Essbase and Smart View add-ins?
Cheers,
JBM
Very nice comparison between Excel Add-in Vs. Smart View 9.3.1.
Thanks
Excel Comparison
Post a Comment