Business Intelligence from emails, appointments
Introducing OLAP for Microsoft Outlook
- Seamless integration with Microsoft Outlook
- Support almost all data types used in Microsoft Outlook items.
- Supports user defined custom fields as well as built-in Outlook fields.
- Supports the following functions for Measures – Count, Distinct Count, Max, Min, Average, Sum etc.
- Choose your own fields from the Outlook folder/items, set as measures or dimensions for the OLAP cube.
- Supports common OLAP operations i.e., 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. Eg. 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 retrieval and use.
- 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.
- Supports POP, IMAP, Exchange mailbox and Public folders, and even local PST.
- No requirement of Microsoft Excel , Microsoft Access or Analysis Server.
- Special MSI installer available for enterprise wide deployment (upon request)
Though Outlook views are excellent way of presenting information in a more obvious way in folder, it does not give you the summarized data that one needs often, to see broader trends based on aggregation, and to see these trends broken down by any number of variables.
Given that the generalization of information using Outlook views are constrained by a few fields (or dimensions) at a time, it is hard to fully evaluate a complex set of answers without the ability to inspect each dimension in detail, while at the same time, preserving context eliminating all guesswork.
how it works
On every outlook folder, you will find the OLAP toolbar, containing two buttons. The first button enables you to choose which fields or dimensions (including user defined ones) to include in the statistic. It also lets you define which fields will act as ‘measures’ in the function column. Selected fields and other settings are saved for that specific folder so that when you come back to this folder next time, it will show the same selected fields.
As seen in the screenshot above, user-defined fields are distinctly highlighted for easy recognition. For example, ProjectCode, ProjectCost, ProjectCountry, ProjectManager, ProjectPoints are user-defined fields in this task folder. You can also add new OLAP fields – a composite (also known as hierarchy) or a calculated field, based on the existing member fields of Outlook. OLAP fields are also colored differently for easy recognition (e.g. green)
New OLAP composite dimension – E.g. Projects per Country
New OLAP calculated member – E.g. Projects Total Cost
Then you can run the statistics tool from the toolbar or from the fields selection dialog. Depending on the number of folder items, it might take a few seconds to generate the cube from the Outlook folder, before loading the OLAP client tool, as shown below.
OLAP Grid view
OLAP Chart view