home | products | services | support | knowledge base | free license | blog | about | contact


 
Product Overview
Enabling Business Intelligence (BI) - OLAP application for Microsoft® SharePoint® that makes it very easy and effortless to analyze your ever-growing SharePoint list data in multiple dimensional view, and get useful insights and sense out of your lists, appointments or tasks.
 
OLAP Statistics & Reporting for Microsoft® SharePoint® enables you to connect to a SharePoint list, task or calendar and explore data in a multi-dimensional grid, pivot tables, filters, graph or chart view. With the capability of complex calculations, trend analysis and sophisticated data modeling, and reporting, it helps you to identify critical information on your SharePoint data.

 


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

Highlights:
 

bullet

Works with WSS1, MOSS2, SharePoint 2010

bullet

Support almost all data types used in SharePoint list

bullet

Choose your own fields and set them as measures or dimensions for OLAP representation

bullet

Supports the following functions for Measures - Count, Distinct Count, Max, Min, Average, Sum etc.

bullet

Supports most of the common OLAP operations including slice and dice, drill down, roll up, and pivoting on the cube.

bullet

Supports date/time fields to be summarized or broken down to year, month, day, week, hours, minutes etc.

bullet

Create your own composite hierarchy. Eg. Country > State > City

bullet

Create your own calculated member involving computational relationship. Eg. Total Sales = (UnitPrice X Quantity) + Freight

bullet

OLAP Grid and Chart with highly interactive, customizable and user friendly interface.

bullet

Save the pivot details to file (*.olapreport) to make it easy for later retrieval and use without requiring to start from scratch.

bullet

Support offline cube (to *.offlinecube in compressed or uncompressed format)  for use in disconnected mode.

bullet

Complete control over the export settings of the grid/chart reports.

bullet

Export grid/chart reports as BMP, GIF, JPEG, PNG, TIFF, TXT, CSV3, PDF4, HTML, XML, XLS

bullet

Share pivot details, reports, offline cube, cube schema files among team members to facilitate collaboration.

bullet

Export raw SharePoint list data to an Microsoft® Access® 2003/2007 database (*.mdb)

bullet

Unicode Support

bullet

Print Preview tool
 

1Microsoft Windows SharePoint Services
2Microsoft Office SharePoint Server
3Comma Separated Values
4Adobe Portable Document

Version: 2.1

 

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

 

 

30 days trial

Personal License (Single Seat) - 75 USD
Country Enterprise License (Unlimited Seats) - 300 USD


Download brochures (PDF)

License is valid life-time. However, technical assistance and free upgrades are bound to the validity of the Support and Maintenance Contract
 

Free license for Academic Institutions (Schools, Colleges and Universities) - Learn More...
50% discount for non-profit, non-academic organizations (e.g., Charitable trusts, hospitals,). Learn More...

 

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
 
bullet

Combine your data in any order, at any level of summarization, and over several time periods

bullet

Run complex calculations on the OLAP cube to provide aggregated data

bullet

Get multiple views on summarized data and perform complex detailed analysis

bullet

Interact with your data to investigate relationships, context and relevance within dimensions

bullet

Create new 'report views' of the particular snapshot of the statistics and save it for easy retrieval and future use

bullet

Share or publish the statistical snapshot, export it to image, PDF, Excel, or print it.

 

 

Similar and related products from AssistMyTeam SMB Solutions:
bullet OLAP Statistics and Reporting for Microsoft® Access®
bullet OLAP Statistics and Reporting for Microsoft® Outlook®

 

Some useful external links related to this product:

bullet What is OLAP?
bullet Wiki - Online Analytical Processing
bullet OLAP White Paper
 
   
Copyright © 2017 AssistMyTeam. All rights reserved.
Press Releases | About
 
 

Looking for a Business Intelligence (BI) tool for Microsoft® Access®?

Try
OLAP Statistics
for Access

Analyze your Access data in OLAP Grid and Chart, perform trend analysis, modeling and reporting.

 

 

Looking for a Business Intelligence (BI) tool for Microsoft® Outlook®?

Try
OLAP Statistics
for Outlook

Analyze your Outlook data in OLAP Grid and Chart, perform trend analysis, modeling and reporting.

 

latest news from
bahrurBlog
Converting your emails and attachments to PDF without the fuss
Turning your emails and attachments into PDFs makes them portable, smaller, searchable and generally easier to view, print, store and share, independent of application software, hardware and operating systems.....(30th Jan'17)
 
Building solutions that work on both 32 bit and 64 bit native Office version
Today, 64 bit processors are found in most of our consumer and business systems. Because of its inherent capacity to support more virtual and physical memory than 32-bit ones..(18th Feb'13)
 

Seamless integration of SharePoint based Knowledge Base in Microsoft Outlook
It's simple! Computers are so much engraved in today's businesses, but in the end, the ultimate goal is all about maximizing knowledge wealth and enhancing human intelligence..(23rd Feb'12)

 
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.