Business Intelligence from SharePoint list

Introducing OLAP for Microsoft SharePoint

  • Works with WSS, MOSS, SharePoint 2010, 2013, 2016 and Office 365
  • Support almost all data types used in SharePoint list
  • Choose your own fields and set them as measures or dimensions for OLAP representation
  • Supports the following functions for Measures – Count, Distinct Count, Max, Min, Average, Sum etc.
  • Supports common OLAP operations including slice and dice, drill down, roll up, and pivoting on the cube.
  • Supports date/time fields to be summarized or broken down to year, month, day, week, hours, minutes etc.
  • Create your own composite hierarchy. Eg. Country > State > City
  • Create your own calculated member involving computational relationship. E.g.. Total Sales = (UnitPrice X Quantity) + Freight
  • OLAP Grid and Chart with highly interactive, customizable and user friendly interface.
  • Save the pivot details to file (*.olapreport) to make it easy for later use without starting from scratch.
  • Support offline cube (to *.offlinecube) for use in disconnected mode.
  • Complete control over the export settings of the grid/chart reports.
  • Export grid/chart reports as BMP, GIF, JPEG, PNG, TIFF, TXT, CSV, PDF, HTML, XML, XLS
  • Share pivot details, reports, offline cube, cube schema files among team members to facilitate collaboration.
  • Print Preview tool.

how it works

In the OLAP SharePoint Manager tool, you can enter the URL of your SharePoint site (e.g.. http://companyweb/) such that it would show up all the available lists in a hierarchical tree from which you can select a particular SharePoint list to configure for OLAP Cube. Alternatively, you can also enter the URL of the particular SharePoint list (e.g.. http://companyweb/Lists/Tasks/AllItems.aspx) to directly load the available fields in the grid for cube configuration. With either techniques, you can choose which SharePoint fields to include in the cube. You can also set aggregate function for the measure fields or define new derived fields such as a hierarchy or a calculated field.

OLAP SharePoint Manager allows you to prepare and configure a SharePoint list for generating an OLAP cube

As seen in the screenshot above, apart from the SharePoint fields, you can add your own derived OLAP fields such as a composite hierarchical field (e.g.. Project-Task) or a calculated field (e.g.. Total Project Budget), based on existing SharePoint fields. For easy recognition, derived fields are distinctly colored and highlighted (in green).

New OLAP composite dimension – E.g. Project – Task

New OLAP calculated member – E.g. Total Project Budget

When you click the ‘Run Statistics‘ button, it would generate a cube, which will be loaded in the OLAP Statistics tool that consists of the Grid and Chart Views as shown below.

OLAP Grid allows for building reports of exceptional level of complexity, in a few steps

OLAP Chart allows representing the data graphically which is much easier to perceive

With over 1200+ customers across 50 countries including fortune 500 companies, government and non-profit agencies, freelance consultants, educational institutions and universities, etc.