OLAP Statistics and Reporting for Access v.2.0.157


OLAP Statistics & Reporting for MicrosoftdlT« Access enables you to connect to a fact table (and their related tables, if available) from an Access database and select fields of interest, and then explore them 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 not so obvious data.Highlights:Works with all version of Microsoft Access databases - 97/2000/2002/2003/2007 (*.mdb), 2007/20101 (*.accdb)Save OLAP cube schema (*.olapschema) and re-use it for subsequent operations to generate cube from the database.Support almost all data types in MS Access.Choose your own fields from the fact/transaction table and their related tables and set them as measures or dimensions for the OLAP cube.Supports the following functions for Measures - Count, Distinct Count, Max, Min, Average, Sum etc.Supports most of the common OLAP operations including 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 > CityCreate your own calculated member involving computational relationship. Eg. Total Sales = (UnitPrice X Quantity) + FreightOLAP 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 without requiring to start from scratch.Support offline cube (to *.offlinecube in compressed or uncompressed format) 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, CSV2, PDF3, HTML, XML, XLS4Share pivot details, reports, offline cube, cube schema files among team members to facilitate collaboration.Unicode SupportPrint Preview toolNo requirement of Microsoft ExceldlT« , Microsoft AccessdlT« or Analysis Server.

OLAP Statistics & Reporting for MicrosoftdlT« ... Enabling Business Intelligence (BI) - OLAP application that makes it very easy and effortless to analyze your MicrosoftdlT« AccessdlT« database in multiple dimensional views, and get useful insights and sense out of your enormous relational dat ...

tables, microsoft, access, schema, reports, offline, details, count, table, friendly, customizable, interactive, statistics, reporting

  • OLAP Statistics and Reporting for Access
  • 2.0.157
  • AssistMyTeam
  • WinXP, Win2003, Win2000, Win Vista, Windows 7
  • Shareware
  • 6.07 Mb
  • 198

Review OLAP Statistics and Reporting for Access

  • captcha

Other software of AssistMyTeam
  • Attachment Manager for Outlook  v.1.0Attachment management addin for Outlook to detach attachments and embedded images as files and link them up with the email. Reduce your Inbox size and make Outlook run much faster. Remove links and re-attach files back when required, or when replying ...
  • Data Publisher for Outlook & SharePoint  v.2.2Data Publisher brings SharePoint integration to Microsoft Outlook for seamless publication of emails, appointments, tasks or contacts to SharePoint, where they can be shared with other users. Supports automatic publication to SharePoint. Provides a ...
  • Database Exporter  v.1.0Database Exporter for MicrosoftdlT« OutlookdlT« enables you to export the contents of an Outlook folder to an external database.

New Miscellaneous software
  • DreamPlan Home Edition  v.6.26DreamPlan Home Edition for Windows is an easy to use software. See your dream floor plan with customized kitchens, bathrooms and bedrooms for a home or apartment. Plan out your landscape. Customize paint, textures and decorations.
  • ORTWIN  v.17.03ORTWIN is a program for the inquiry of localities in Germany. It finds postal zip codes, telephone pre selections, coordinates. It performs perimeter searches and distance calculations. It finds landscapes, natural units, snow- and wind load zones.
  • Free 2D Barcode Generator  v. programe generates and prints most popular matrix and stacked 2D barcode symbologies including Aztec Code, Data Matrix, QR Code, PDF417, Micro QR Code, MicroPDF417, MaxiCode, Code 16K, RSS family, etc.
  • Awario  v.3.29.03Discover and be in charge of every conversation that matters to your business in social media and across the web. Interact with the mentions right from the platform to keep up the reputation of your brand and engage with customers.
  • Random Item Picker  v.3.5Randomly pick items and remove duplicates from large lists.
  • Reservation 123  v. 123 is a motel reservation booking system designed to simplify the reservation process and allow you to get on with running your business.