OLAP (Online Analytical Processing)

GPTKB entity

Statements (50)
Predicate Object
gptkbp:instanceOf data analysis technology
gptkbp:abbreviation Online Analytical Processing
gptkbp:characterizedBy dimensions
measures
multidimensional cubes
gptkbp:contrastsWith OLTP
gptkbp:enables pivot
data exploration
trend analysis
forecasting
dashboarding
data consolidation
ad hoc reporting
what-if analysis
drill-down
KPI analysis
roll-up
slice and dice
gptkbp:example gptkb:IBM_Cognos
gptkb:Oracle_OLAP
gptkb:SAP_BW
gptkb:Microsoft_Analysis_Services
Pentaho Mondrian
gptkbp:firstDefined gptkb:Edgar_F._Codd
1993
gptkbp:focusesOn historical data
aggregated data
analytical queries
gptkbp:hasType gptkb:ROLAP
HOLAP
MOLAP
https://www.w3.org/2000/01/rdf-schema#label OLAP (Online Analytical Processing)
gptkbp:relatedTo ETL
OLTP
data warehouse
gptkbp:standardizedBy gptkb:OLAP_Council
XMLA Council
gptkbp:supports gptkb:data_visualization
data modeling
trend analysis
data summarization
complex calculations
gptkbp:supportsLanguage gptkb:MDX
gptkb:DAX
SQL
gptkbp:usedFor business intelligence
data mining
multidimensional analytical queries
gptkbp:bfsParent gptkb:software
gptkbp:bfsLayer 4