Glossary of technical terms

    A
  • i.e., Application Programming Interface; a set of functions made available to interact and integrate with a software application or system
  • B
  • Represents the quantity of data read, transformed and loaded into a destination at one time
  • C
  • A sequence of characters that specifies information about a data source and how to connect to it
  • When a server is taking too long to reply to a data request made from another device
  • A multidimensional structure containing aggregated and calculated data that can be viewed in different ways (through slices) for a better understanding of the collected data
  • D
  • An angle through which the Measures are analyzed
  • E
  • i.e., Extract, Transform and Load; processes by which you can perform tasks within a database; Extract (i.e., read) consists of collecting data from one or more sources; Transform consists of converting extracted data into the correct format through tables to be processed in the data warehouse; Load (i.e., store) consists of writing the converted data into the destination database
  • I
  • Contains information about its associated Data Model and can be used to execute scripts using given parameters
  • M
  • A numeric field whose values can be measured, e.g., Sales Total, Costs, Margins, Quantities, etc.
  • S
  • A subsection of data within the Cube; defined by a set of Dimension elements
  • T
  • Key that identifies the field used in the incremental load
  • U
  • i.e., Uniform Resource Identifier; a string (i.e., sequence) of characters that unambiguously identifies a particular resource
  • V
  • Presents data in different formats that are easy to read, such as Worksheets and many types of Graphs.