Vivid
This powerful add-in for Microsoft Office extends Excel with new features that will allow your organization to more effectively collaborate, while at the same time greatly simplifying the process of building insightful reports, even against the most unwieldy SQL Server Analysis Services OLAP or PowerPivot cubes. You will soon never want to use Excel without Vivid.
Client-Side Perspectives
Creating perspectives typically requires modifications to the cube definition on the server. Vivid's client-side perspectives give you the ability to build custom views of the cube directly inside of Excel. No server-side intervention needed, and the changes are local to your workbook.
Custom Calculations
Convenient MDX editor supports drag/drop and auto-completion to build the perfect calculation.
Click for video
(0:31)
Custom Named Sets
Convenient MDX editor supports drag/drop and auto-completion to build the perfect named set.
Click for video
(0:24)
Edit Items
Edit the expression/formula for an existing measure, attribute, calculation, or named set.
Click for video
(0:21)
Create Display Folders
Create display folders to store sets, calculations, or other named sets in convenient locations.
Click for video
(0:21)
Restore Hidden Items
Restore any hidden item so that users can once again see them.
Click for video
(0:18)
Create and Use Virtual Hierarchies
Create hierarchies from constituent attribute hierarchies. Especially useful for PowerPivot, which doesn't have built-in support for creating user hierarchies.
Create and Use Virtual Dimensions
Group hierarchies the way you want them to be grouped through simple creation of virtual dimensions.
