1. Home
  2. BI
  3. Analytics
  4. OLAP

By: Pascal PERRY

Posted:

OLAP Functions & Features

Major modules covered Interactive data analysis and reporting;Web-specific features;Calculations;Data visualization;Report distribution;.. OLAP Functions & Features are an important module of the comprehensive BI RFP Template.

The BI RFP template with OLAP Functions & Features for BI is a Microsoft Excel spreadsheet (.xlsx) featuring a total of 1955 decision criteria. The BI RFP template allows you to quickly and easily prepare the business, functional, and technical requirements sections of the solicitation package you'll send to BI software vendors. It ensures for:

  • complete response from each BI software vendor
  • deep and accurate evaluation of submitted BI proposals
  • impartial side-by-side comparison of BI solutions evaluated
  • rational and documented selection of the best matching BI system

The BI software comparison report can save you up to 90% of the time you would have otherwise spent comparing all the BI solutions from scratch.

Download Now!

The OLAP Functions & Features comprise the following elements:

  • Calculations

    Features and functions below include Multiple aggregation functions: sum, min, max, count, and others;Calculated facts, based on predefined functions or user-defined formulas;Multidimensional formula language allows to operate with totals, subtotals, and any elements of cube data;Conditional operators, built-in functions, user-defined functions and constants in formulas;Bases multiple calculated facts on other calculated facts;Interactive Excel-like custom formula definition;. Calculations, OLAP Functions & Features

  • Data visualization

    Functionality covered Real time control over all appearance properties at design and at runtime;Cascading conditional style rules to highlight various data in the grid;Runtime editors for connection settings, fields used, report layout, header and footer, styles and rules;Wraps outside area to show user all available filters;Flat and 3D modes, Windows XP styles;Smart wrapping of long data strings and captions;. Data visualization, OLAP Functions & Features

  • Web-specific features

    Functionality covered Integrates into any web application;Flat appearance, ideal for HTML pages;Reads compact reports by HTTP and FTP;. Web-specific features, OLAP Functions & Features

  • Report distribution

    Functionality covered Stores both data and report layout settings in a single universal mobile report container;Report exchange technology;Exports to other formats for analysis e.g., XLS, PDF, RFT, CSV, etc.;. Report distribution, OLAP Functions & Features

  • Interactive data analysis and reporting

    Modules covered Processing millions of rows with sub-second response time;Loading data from virtually unlimited number of data sources;Dynamic data filtering, pivoting, drill-down and roll-up;Interactive drill-down into multiple detail levels;Alternate drill paths to view different perspectives on the same data;Shows/hides detail levels in summary views;. Interactive data analysis and reporting, OLAP Functions & Features

TEC Advisor can save you up to 90% of the time you would have otherwise spent figuring out on your own which BI solution is the best for your needs.

Compare Now!
Functions and Features