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

By: Pascal PERRY

Posted:

Calculations Functions & Features

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 Functions & Features are an important module of the comprehensive BI RFP Template.

The BI RFP template with Calculations 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.

The Calculations Functions & Features comprise the following elements:

  • Multiple aggregation functions: sum, min, max, count, and others

    Multiple aggregation functions: sum, min, max, count, and others, Calculations Functions & Features
  • Calculated facts, based on predefined functions or user-defined formulas

    Calculated facts, based on predefined functions or user-defined formulas, Calculations Functions & Features
  • Multidimensional formula language allows to operate with totals, subtotals, and any elements of cube data

    Multidimensional formula language allows to operate with totals, subtotals, and any elements of cube data, Calculations Functions & Features
  • Conditional operators, built-in functions, user-defined functions and constants in formulas

    Conditional operators, built-in functions, user-defined functions and constants in formulas, Calculations Functions & Features
  • Bases multiple calculated facts on other calculated facts

    Bases multiple calculated facts on other calculated facts, Calculations Functions & Features
  • Interactive Excel-like custom formula definition

    Interactive Excel-like custom formula definition, Calculations 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