Skip to content

TobiasWeller/SemanticOLAP

Repository files navigation

Semantic OLAP

Semantic OLAP

The repository contains the Semantic OALP extension for Semantic MediaWiki. The extension provides a plugin for analyzing SMW Data by using Pivot Tables.

Table of content

Prerequisites

Installation

  • Download and extract the repository
  • Place the extracted folder in your extension folder of MediaWiki
  • Add the following code at the bottom of your LocalSettings.php:
    wfLoadExtension( 'SemanticOLAP' );
  • To users running MediaWiki 1.24 or earlier: Add the folloding at the bottom of your LocalSettings.php:
    require_once "$IP/extensions/SemanticOLAP/SemanticOLAP.php";

Usage

  • Go to Special Pages and Click on Semantic OLAP under the Group Semantic MediaWiki

Query Data

  • Before analyzing the data, the data must be queried.
  • Semantic OLAP supports the creation of queries by using a Form.
  • At least one Category and one Property must be entered. The forms supports the entries by auto-suggestions.
  • If no Category or Property is entered, an Error appears. If no Data was retrieved by the Query, then an error appears as well.
  • After entering Category and Property, then Click on Submit
  • Note: Currently are no multiple values for one property supported.

Query Data

Analyze Data

  • Use Drag & Drop to put the attributes/properties into column and row. The Pivot Table will build up the data.
  • Use Drag & Drop to put the attributes/properties into the Data section.
  • Pivot Table allows for filtering and sorting (by clicking on the icon next to the properties/attributes; see image)
    Filter / Sort Data
  • Properties, marked as Datatype Quantity, which has a unit will display the corresponding unit in the Pivot Table.
    Data in Pivot Table


    Filter / Sort Data

Export Data

  • Click on the Button XLS next to the Button Export to export the current view of the Pivot Table in xls.

Export Data in xls

License

Semantic OLAP is currently under the MIT License.

Acknowledgements

Semantic OLAP uses orb.js. This is a library for building interactive pivot tables, built with React.js.

Links