Extension:Semantic OLAP

From MediaWiki.org
Jump to: navigation, search
MediaWiki extensions manualManual:Extensions
Crystal Clear action run.png
Semantic OLAP

Release status:Extension status stable

px
ImplementationTemplate:Extension#type Ajax, Special page, Data extraction
DescriptionTemplate:Extension#description Analyse data in Semantic MediaWiki by using OLAP functionality
Author(s)Template:Extension#username Tobias Wellertalk
Latest versionTemplate:Extension#version 1.0 (2017-06-12)
MediaWikiTemplate:Extension#mediawiki 1.19+
PHPTemplate:Extension#php 5.3+
Database changesTemplate:Extension#needs-updatephp Bo
LicenseTemplate:Extension#license MIT License
Download

Translate the Semantic OLAP extension if it is available at translatewiki.net

Check usage and version matrix.

Semantic OLAP is an extension to Semantic MediaWiki that allows to query and analyse data, stored in the semantic MediaWiki, by using OLAP functionality. Users can analyse the data from different views by changing the pivot table. Semantic OLAP uses orbjs, which is based on React.js, to customize and control the pivot table.

Installation[edit]

The Semantic MediaWiki extension must be installed in order to use this extension.
  • Download, extract and place the file(s) in a directory called SemanticOLAP in your extensions/ folder.
  • Add the following code at the bottom of your LocalSettings.php:
    wfLoadExtension( 'SemanticOLAP' );
    
  • YesY Done - Navigate to Special:Version on your wiki to verify that the extension is successfully installed.

To users running MediaWiki 1.24 or earlier:

The instructions above describe the new way of installing this extension using wfLoadExtension() If you need to install this extension on these earlier versions (MediaWiki 1.24 and earlier), instead of wfLoadExtension( 'SemanticOLAP' );, you need to use:

require_once "$IP/extensions/SemanticOLAP/SemanticOLAP.php";

Usage[edit]

Select Data[edit]

In the initial screen of the Semantic OLAP Special Page, the data that should be queried must be selected.

  • At least one Category and one Property must be selected.
  • Autocomplete simplifies the input and suggests available Categories and Properties

On the basis of the input, a simple ASK Query is created in the background. If no result is returned, a Popup appears with the corresponding ASK query.


SemanticOLAP Select.png


Analyse Data[edit]

Tool allows to analyse the data by using OLAP functionality.

  • Use Drag&Drop to change the view on the pivot table
  • If multiple values are linked to the same Property then only the first Value is selected.
  • If a property is of type "Quantity", the corresponding unit is displayed.
  • Click on "Select Data" to get back to the initial screen and select the data for analysis


SemanticOLAP Analyse.jpg


Filter and Sort Values[edit]

Semantic OLAP allows to filter for values. In order to filter, click on the right icon on the corresponding property and filter vor values either by

  • Matches (i.e. greater than, lower than)
  • Tick the concrete values


SemanticOLAP Filter.jpg


Export Data[edit]

The current view on the data is downloaded in spreadsheet format by clicking on the export xls button.


SemanticOLAP Export.png

Known issues[edit]

Future Work[edit]

  • Select aggregation function (sum, avg, max, min)
    • Currently, only sum is available
  • Advanced ASK Queries/Selection of data
  • Allow to display information in graphs

Remarks[edit]

*Not all units are displayed. It is part of future work to display all available units *Sometimes the Multibox is not properly loaded. Please reload the page in that case

See also[edit]

Link to authors


Link to information pages