Clearway SmartGrid

World’s first pivot table built just for SharePoint

Users want a quick and easy way to connect and analyze data in an OLAP database. This is especially true when information is delivered via Microsoft SharePoint. Users prefer the power and familiarity of SharePoint to connect to and analyze Business Intelligence data. Though users love using Excel, it is difficult to share the results of the analysis done in Excel with other users through SharePoint without an investment in Excel Services.

Clearway SmartGrid allows users to connect and analyze Business Intelligence data in SQL Server Analysis Services right within Microsoft SharePoint. SmartGrid easily creates heat maps that synthesize complex data to help users make faster and better business decisions. With SmartGrid, users have the ability to perform functional analysis quickly and easily with a click of a button and share that analysis with other users who have access to the SharePoint site. SmartGrid provides increased productivity at an incredible value for businesses.

• Connect to SQL Server Analysis Services 2005 and SQL Server Analysis Services 2008 OLAP cubes for source of data
• Connect to SQL Server 2005 and SQL Server 2008 Relational Database as data source
• Connect to SharePoint List as data source
• Wizard interface right within the SharePoint web part that allows you to select a hierarchy or attribute from one dimension on the rows and two measures for columns
• Drill down and drill up functionality within the grid in case a hierarchy is selected
• Each of the two measures will automatically be presented as a color shaded heat map. There are two different colors for the two measures
• Change measures to analyze on the fly with handy measure picker
• Change the hierarchy or attribute of another or same dimension for analysis on the fly
• One click access to top and bottom five values
• One click access to hide empty data values
• Allow user to filter results by slicing data from another dimension in SQL Server Analysis Services by using Clearway OLAP Filter Web Part
• Multiple text sizes available for selection during web part configuration.