Note: You can also refer to the video demonstration hosted on our site here

Version: 2.1

Have any questions? Email us: support@assistmyteam.net

Purpose of this tool

SharePoint has become a de-facto platform for storing and sharing business data in lists, document libraries etc. among team members in organizations. But unlike the ease of reporting and running statistics on relational database, SharePoint on its own does not provide such flexibility when it comes to extracting business intelligence. Due to this limitation, often, managers might find themselves spending a lot of time and resource in exporting data to spreadsheet, and performing manual computation and parsing. Some organizations even use specialized data professionals and a dozen different software packages, just to produce simple reports. Worst, if the report doesn't have the required information, you will have to start over, wasting precious time.

As there is a time and expense involved in getting answers from SharePoint lists, a lot of business intelligence information often goes unused, due to that fact that, SharePoint is designed to store data, and not to help you analyze it. It is with this requirement in mind, that we have designed OLAP Statistics and Reporting for SharePoint, to give you a simple and yet powerful tool to let you configure OLAP cube from your SharePoint lists, and then analyze and create reports straightaway, out of the box.
 

How does it work?

In the OLAP SharePoint Manager tool, you can enter the URL of your SharePoint site (eg. 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 (eg. 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 (eg. Project-Task) or a calculated field (eg. 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 and Reporting 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

To put in perspective, OLAP Statistics & Reporting for SharePoint can   Combine your data in any order, at any level of summarization, and over several time periods Run complex calculations on the OLAP cube to provide aggregated data Get multiple views on summarized data and perform complex detailed analysis Interact with your data to investigate relationships, context and relevance within dimensions Create new 'report views' of the particular snapshot of the statistics and save it for easy retrieval and future use Share or publish the statistical snapshot, export it to image, PDF, Excel, or print it.