Home > Products > OLAP for Microsoft Databases > Download

OLAP for Microsoft Databases is available for a free 30-days trial. This initial trial period allows you to evaluate the software. If you then choose to purchase, you can continue using the program without making any changes to your setup or data. The trial downloads are full-featured product versions.

Please input your name and email address below to continue with the download.

Version: 3.1.9.35
Release Date: 27th April 2018

AssistMyTeam OLAP tool can be easily deployed through an installer across the entire organization.

The following highlights the main pre-requisite for running AssistMyTeam OLAP tool.

Windows Version Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista (both 32bit and 64bit are supported) and all server based Windows 2008 R2 and above

NOTE: Windows XP is not supported.
DatabaseMicrosoft SQL Server and Express Editions (Any version) Microsoft Azure SQL (cloud)
Microsoft Access 97 – 2007 (*.mdb format)
Microsoft Access 2007 – 2016 (*.accdb1 format)

1Microsoft Access as such, is not required to be installed on the system, for this software to work. However, it requires installation of ‘Data Connectivity Components’ drivers for ‘Office System 2007’. The software will automatically take you to the download site if it is not installed on the system.

Microsoft .NET Framework

The .NET framework 4.5 or higher must be installed and activated on your system before you can install and use AssistMyTeam Software. In newer windows, such as Windows 10, 8.1 and 8, .Net framework 4.5 is available as part of the OS, and is installed by default. For Windows 7 and Vista, you need to download the .NET framework 4.5 redistributable from Microsoft website and install it manually. .NET Framework 4.5 is not supported (cannot be installed) on Windows XP.

For server based windows, .NET framework 4.5 is installed part of Windows Server 2012 and higher versions. If you are using older versions such as Windows Server 2008 R2, you would need to download and install the 4.5 framework.

NOTE that, even if you have  older versions of .NET Framework 2 or 3.5, you still need to enable or install .NET Framework 4.5 on your system for our product to work. Multiple versions of the .NET Framework can be loaded on a single computer at the same time. This means that you do not have to uninstall previous versions of. NET frameworks in order to install a later version.

  • For Windows 7 and Vista, Windows Server 2008 R2, you can download the .NET framework 4.5 redistributable here https://www.microsoft.com/en-in/download/details.aspx?id=30653
  • For Windows 8 and higher versions (8.1, 10), the .NET framework 4.5 is already built-in with the OS and installed/enabled by default. However, it may not be enabled by default. To enable it, follow the steps below:

    STEP 1) You will need to have an Administrator account in Windows 8/8.1/10 to turn Windows Features on or off. From Metro/Start Menu, right-click anywhere in the background and a tab appears in the bottom. Click the icon labeled All apps in the bottom-right corner. (or you can simply search for the term ‘Uninstall’ from Start menu under Settings tab)STEP 2) The Apps menu opens. Scroll to the right and click Control Panel.

    STEP 3) The Control Panel opens. Click Uninstall a Program.

    STEP 4) The Programs and Features window opens. Click Turn Windows features on or off.

    STEP 5) The Windows Features window opens. Check the box labeled ‘.NET Framework 4.5 Advanced Services’ or ‘.NET Framework 4.6 Advanced Services’ and then click Ok.

    or

    STEP 6) You are notified that Windows completed the requested changes (see below). Click Close, and then restart your computer.

It typically takes not more a minute to perform the install and configuration.

With this guide, you would be able to quickly and easily install and configure AssistMyTeam OLAP Statistics and Reporting tool.

For ‘Per User Installation’ (ideal for standalone single user/workstation)
AssistMyTeamOLAPSetup_x86.zip (for Windows with 32-bit MS Office)
AssistMyTeamOLAPSetup_x64.zip (for Windows with 64-bit MS Office)

For ‘Per Machine Installation’ (ideal for installing on Citrix and Terminal Servers)
AssistMyTeamOLAPSetup_x86_Citrix.zip (for Windows with 32-bit MS Office)
AssistMyTeamOLAPSetup_x64_Citrix.zip (for Windows with 64-bit MS Office)

The downloaded zip file contains the setup.exe and other supporting documents. Extract these file contents to a file folder.

NOTE: Per User Installation and Per Machine Installation
In Per User Installation, the install is performed 100% on the local system and nothing is installed on your Windows Server. Further, this install is intended to serve only the current logged on user of the system/workstation and will be installed under the user’s application data folder (instead of Programs Files folder) and no elevated permission is required (This is known as per user installation). So, there won’t be a prompt from UAC to allow this install unless you change the install directory to say, Programs Files which will warrant an elevated permission/UAC prompt. If the same system is used by multiple users, each one needs to install the add-in on their profile with the default installation folder location.

Per Machine Installation: If you have the need to have a single install that serves all users of the system (i.e., per machine installation, which technically means the files will be installed under Program files folder and the add-in will be registered under HKEY_LOCAL_MACHINE registry hive rather than HKEY_CURRENT_USER), request here for the Citrix/Terminal Server version of the setups to perform a per machine installation.

Step 1. Run the AssistMyTeamOLAPSetup_xXX.exe to start the installation. Click ‘Next‘ to Continue.

Step 2. Select the appropriate destination folder where the application files will be installed. If you change the default folder path, please make sure you have appropriate permission. (Note: by default, it will be installed under your application data folder)

Step 3. Click ‘Next’ to continue with the files extraction. It just takes a few minutes to complete the whole copying process.

Step 4. Click ‘Finish’. This ends the files installation process in your system.

Now go to Start Menu > All Apps. If the installation was successful, you will see new menu entry ‘AssistMyTeam OLAP Tool’.

To start creating OLAP configuration and cube from a Microsoft database (Access, SQL Server or Azure SQL), click ‘AssistMyTeam OLAP Manager’ from the menu (above).

Once a configuration is achieved, click ‘Run Statistics’ from the toolbar of the OLAP Manager tool. This will load the configured OLAP cube in the OLAP Client tool.

For more references and help, refer to the PDF Help Manual, which can be invoke from Start Menu > All Apps > AssistMyTeam OLAP tool > Help Manual.

You can also download the full PDF help manual directly from this link.

Detail information on upgrading your old installation of ‘AssistMyTeam OLAP Tool’ with new version and update.

Upgrade Steps to Version 3.1 (from version 1.X, 2.X)

  • Download the latest setup to your system.

  • Extract the contents of the zip file to a file folder in your system.

  • Uninstall the previous/older ‘OLAP Statistics for Access’ from your system. You can do that from Control panel -> ‘Add or Remove programs’ (in Windows XP) or ‘Programs and Features’ (in Windows Vista and Windows 7, 8 or 8.1, 10), then choose “OLAP Statistics for Access” and click the remove button.

  • Run the newly downloaded ”AssistMyTeamOLAPSetup.exe’ file to install version 3.1 of AssistMyTeam OLAP Tool.

Version 3.1.9.34

  • FIXED: When trying to run the OLAP Manager application in Windows 7, you get the following error:

    Firma problema:
    Nome evento problema: CLR20r3
    Firma problema 01: AssistMyTeam.OLAP.Manager.exe
    Firma problema 02: 3.1.9.33
    Firma problema 03: 5ab37444
    Firma problema 04: FarPoint.Win.Spread
    Firma problema 05: 6.0.3506.2008
    Firma problema 06: 50b5c02e
    Firma problema 07: 2c20
    Firma problema 08: a4
    Firma problema 09: System.InvalidOperationException
    Versione SO: 6.1.7601.2.1.0.256.48
    ID impostazioni locali: 1040
    Informazioni aggiuntive 1: 0a9e
    Ulteriori informazioni 2: 0a9e372d3b4ad19135b953a78882e789
    Ulteriori informazioni 3: 0a9e
    Ulteriori informazioni 4: 0a9e372d3b4ad19135b953a78882e789
     

Version 3.1.9.32

  • NEW FEATURE: Added support for OLAP analysis of Microsoft SQL Server (including Express Edition), Azure SQL (cloud database) and Microsoft Access databases.
     
  • Requires .NET Framework 4.5 or above.