Technical Addendum

SPARQL Queries for specific tasks

• SPARQL Queries to remove cube
• SPARQL Queries used in Development
• SPARQL Queries to check the cube

Preloaded Ontologies

To enable faster selection of common properties the following ontologies are preloaded in some fields in cube-creator for autocompletion.

• rdfs
• schema
• qb
• sdmx
• dcterms
• dc11
• skos
• skosxl
• xkos
• xsd
• wgs

Required write permissions for SPARQL operations

Cube creator uses two databases: one for the projects (env variables STORE_*_ENDPOINT), and another for shared dimensions and hierarchies (env variables MANAGED_DIMENSIONS_STORE_*_ENDPOINT).

The following table summarises the write permissions required by the two users, whose names are configured by the environment variables menton in first column

User	Database	Graph
STORE_ENDPOINTS_USERNAME	STORE_*	*
STORE_ENDPOINTS_USERNAME	MANAGED_DIMENSIONS_STORE_*	MANAGED_DIMENSIONS_GRAPH
MANAGED_DIMENSIONS_STORE_USERNAME	MANAGED_DIMENSIONS_STORE_*	Organisation profile graphs (see below)

The organisation profile graphs are configured in cube creator and can be retrieved by running a query on the cube creator database. They are required for publishing cubes.

PREFIX schema: <http://schema.org/>
prefix cc: <https://cube-creator.zazuko.com/vocab#>

select ?publishGraph
WHERE {
  graph ?org {
    ?org a schema:Organization ; cc:publishGraph ?publishGraph
  }
}