AW: ISSUE-30 (CubeRel): Declaring relations between cubes [Data Cube Vocabulary]


Regarding this issue, I would like to point to the suggestion of [1]. Here, the component specification of a measure can define an aggregation function that should be used when aggregating measures to a higher level.

A vocabulary that may be used for data transformations to statistical data is Cogs [2]. 

Again, I have added a recommendation to [3]: "There should be a recommended way of declaring relations between cubes"



[1] QB4OLAP: a Vocabulary for Business Intelligence over the Semantic Web. <>
[2] Cogs. ETL Provenance Vocabulary. <>
[3] <>

Von: Government Linked Data Working Group Issue Tracker []
Gesendet: Freitag, 17. Februar 2012 17:03
Betreff: ISSUE-30 (CubeRel): Declaring relations between cubes [Data Cube Vocabulary]

ISSUE-30 (CubeRel): Declaring relations between cubes [Data Cube Vocabulary]

Raised by: Dave Reynolds
On product: Data Cube Vocabulary

In some situations statistical data sets are used to derive further datasets. Should Data Cube be able to explicitly convey these relationships?

A simple specific use case is that the Welsh Assembly government publishes a variety of population datasets broken down in different ways. For many uses then population broken down by some category (e.g. ethnicity) is expressed as a percentage. Separate datasets give the actual counts per category and aggregate counts.  In such cases it is common to talk about the denominator (often DENOM) which is the aggregate count against which the percentages can be interpreted.

Should Data Cube support explicit declaration of such relationships either between separated qb:DataSets or between measures with a single qb:DataSet (e.g. ex:populationCount and ex:populationPercent)?

If so should that be scoped to simple, common relationships like DENOM or allow expression of arbitrary mathematical relations?

Note that there has been some work towards this within the SDMX community as indicated here:

Received on Friday, 11 January 2013 13:27:47 UTC