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.
Navigate Effortlessly
Vivid makes it easier than ever to explore an SSAS cube in Excel. Plus all of the power of Excel is done over actual Excel pivot tables,
which allows Vivid to enhance, rather than replicate, Excel's capabilities. It also allows you to work seamlessly, even with those
colleagues who aren't yet using Vivid.
Uses Actual Excel Pivot Tables
Vivid uses actual Excel pivot tables. You can use it with any existing spreadsheet. And spreadsheets you create can be opened and modified by any Excel user, even if they don't have Vivid installed.
Click for video
(0:15)
Supports PowerPivot Cubes
The ease and power of Vivid is available when working with PowerPivot tables, regardless of if the PowerPivot data is embedded in the workbook or on Sharepoint.
Easy Access to Slicers
One click slicer creation via drag and drop of hierarchies to the new slicer drop zone.
SmartFilter
Filters the fields of the pivot table editor to show only show the relevant fields.
Click for video
(0:14)
Measure / Hierarchy Search
Search for any measure or hierarchy right from the pivot table editor.
Click for video
(0:19)
Dimension Type Icons
Intuitive icons in the pivot table editor let you know the type of each dimension at a glance.
Click for video
(0:18)
Dimension Type Filter
Filter the pivot table editor to only show the dimensions of a specific type, such as Time, Geography, or Product.
Click for video
(0:18)
Measure Type Icons
Intuitive icons in the pivot table editor let you know the datatype of each measure at a glance.
Click for video
(0:16)
Measure Type Filter
Filter the pivot table editor to only show the measures that are of a specific datatype, such as Currency, Floating Point, or Integer.
Click for video
(0:19)
Full Cube Member Search
Search the full cube for a member, using server-side search.
Click for video
(0:30)
Properties-Based Cube Search
Search the full cube on the server, not only by searching for the members name, but also by searching the members properties.
Click for video
(0:29)
Expand / Collapse All
One click to expand or collapse the complete measure or dimensions groups in the pivot table editor.
Click for video
(0:17)
MDX Formatting and Syntax Coloring
Configurable MDX formatting and syntax coloring for the MDX Query Viewer.
Click for video
(0:12)
Informative ToolTips
Display measure and hierarchy properties, such as unique name and expression, on mouse hover.
Click for video
(0:15)
View Members
Easily view hierarchy members, without having to modify the pivot table.
Click for video
(0:25)
Background Member Loading
When loading large hierarchies to view them, the loading takes place in the background, allowing you to continue using Excel.
Click for video
(0:25)
Large Hierarchies
Pivot table editor highlights hierarchies with a large number of members. The definition of "Large" is user configurable.
Click for video
(0:21)
Pivot Table Overlay
A convenient windows where you can drag and drop fields to be added to the pivot table.
Click for video
(0:44)
Translucent Dialog Boxes
Translucent dialog boxes and windows make it easier to see the contents of the spreadsheet behind the wdinow. User can enable or disable this feature.
Click for video
(0:35)
