An add-in for Microsoft®
Outlook® that provides a turnkey solution to OLAP
requirement, making it very easy and effortless to analyze
your ever-growing Outlook and Exchange data in multiple dimensional view,
and get useful insights and sense out of your emails,
appointments or tasks.
OLAP Statisticsfor Outlook enables you
to select both Outlook and user-defined custom fields of
interest, and then explore them in a multi-dimensional grid,
graph or chart view
with the capability of complex calculations, trend analysis
and sophisticated data modeling, all from inside your
The simplistic point-and-click
interface ensures that you easily achieve the high-level
views of information you require. Additionally, the OLAP
client makes creating reports destined for different
management levels a simple task - eliminating managers'
dependence on IT personnel.
version: v5.1 released on 18th
Seamless integration with Microsoft Outlook1
almost all data types used in
Microsoft Outlook items.
Supports user definedcustom fields as
well as built-in Outlook
the following functions for Measures
- Count, Distinct Count, Max,
Min, Average, Sum etc.
own fields from the Outlook
folder/items and set them as
measures or dimensions for the OLAP
most of the common OLAP operations
including slice and dice,
drill down, roll up, and
pivoting on the cube.
date/time fields to be summarized or
broken down to year, month, day,
week, hours, minutes etc.
own composite hierarchy.
Eg. Country > State > City
own calculated member
relationship. Eg. Total Sales = (UnitPrice
X Quantity) + Freight
Grid and Chart with
highly interactive, customizable and
user friendly interface.
pivot details to file (*.olapreport)
to make it easy for later retrieval
and use without requiring to start
offline cube (to *.offlinecube
in compressed or uncompressed
format) for use in disconnected
Complete control over the exportsettings
of the grid/chart reports.
License is valid for the subscribed term only. Technical
assistance and upgrades are free for the subscribed term
Perpetual 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.,
Need for Business Intelligence
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
OLAP Statistics & Reporting for Microsoft Outlook is
perfectly suited for this purpose, and allows you to define
any field as the measure with different function - sum,
count, distinct count, maximum, minimum etc, against which
statistics is to be executed.
Real strength of this tool is its ability to examine and
view data in ways not ordinarily possible. By allowing
varying levels of granularity during data inspection and
visualization, a lot of information can be revealed
that would otherwise be hard to attain. Now it is easier than ever to
spot new trends and easily answer many of the perspective
information which otherwise are hidden
How does it work?
On every outlook folder, you will find
the OLAP Statistics 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
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 Statistics and Reporting client tool, as shown
OLAP Grid view
OLAP Chart view
To put in perspective,
AssistMyTeam OLAP Add-in for
Represents Outlook fields
(including custom fields) as OLAP dimensions, which are naturally interrelated through
functional subject areas.
Provides an OLAP Gridview with support for a multi-dimensional
table with expandable nodes. Unique features of control allows for
building the OLAP-reports of the exceptional level
Provides an OLAP
Chart view that allows representing the data graphically.
This gives you a unique
opportunity to analyze your business data visually,
dealing with charts rather than numbers, which is
much easier to perceive.
Enables you to navigate through these
dimensions by drilling down,
across - drill down
to access the detailed level of
data, or roll up to see
the summarized data. Roll up
through the hierarchy levels of
dimensions or to specific
characteristics or data elements
(columns) of the dimensions.
Drill across dimensions to
access the data of interrelated
computational functions such
as sum, averages,
distinct count, maximum,
minimum etc. for the
measure field (when creating
Allows you to save
the current state of the statistics
in the Grid/Chart working area to a report view
file, with specific member
fields on the pivot panels (Rows and Column areas)
and measure fields in the values area. You can use
this report view file in future, to
retain back the same state of
reports to a wide range of formats
including Excel, Adobe PDF, XML,
bitmaps or web pages.
Leverage Outlook for employee timesheet collection, payroll and
For many managers, the collection and processing of timesheets
can be a slow and labor intensive work. And employees hate to
fill out timesheets – a common universal fact which makes
supervisors and managers constantly struggle to adopt an
effective and accurate time tracking in the organization...
Turn Outlook into a Knowledge Base with Exchange Folders
Technology is driving and transforming business every day, but
the ultimate goal is all about maximizing knowledge wealth and
enhancing human intelligence. And for any organization, this
acquired intelligence is the... (22nd Mar'18)
Microsoft and the Office logo are
trademarks or registered trademarks of Microsoft Corporation in the
United States and/or other countries.