@prefix qb: . @prefix ssb: . @prefix rdf: . @prefix rdfs: . @prefix qb4o: . @prefix skos: . @prefix xsd: . @prefix ex: . #### -- Data structure definition and dimensions ssb:SSBDW a qb:DataStructureDefinition ; qb:component [qb:dimension ssb:SupplierDim] ; qb:component [qb:dimension ssb:CustomerDim] ; qb:component [qb:dimension ssb:PartsDim] ; qb:component [qb:dimension ssb:DateDim] ; #### -- Definition of measures qb:component [qb:measure ssb:RevenueCount ; qb4o:AggregateFuction qb4o:Count ; rdf:predicate ssb:l_revenue ; ex:direction ex:forward ] ; qb:component [qb:attribute ssb:name ] ; rdfs:Datatype ssb:Lineorder . ### -- Dimension Suppliers ssb:SupplierDim a rdf:Property, qb:DimensionProperty ; rdfs:label "Supplier Dimension"@en ; qb4o:hasHierarchy ssb:SupplierHierarchy . ssb:SupplierHierarchy qb4o:inDimension ssb:SupplierDim ; qb4o:hasLevel ssb:Supplier ; qb4o:hasLevel ssb:S_City ; qb4o:hasLevel ssb:S_Nation ; qb4o:hasLevel ssb:S_Region . ssb:Supplier a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:S_City a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:S_Nation a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:S_Region a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:shl1 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:Supplier ; qb4o:hierarchyComponent ssb:SupplierHierarchy . ssb:shl2 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:S_City ; qb4o:hierarchyComponent ssb:SupplierHierarchy . ssb:shl3 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:S_Nation ; qb4o:hierarchyComponent ssb:SupplierHierarchy . ssb:shl4 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:S_Region ; qb4o:hierarchyComponent ssb:SupplierHierarchy . ssb:shs1 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:shl1 ; qb4o:childLevel qb:Observation ; rdf:predicate ssb:l_supplier ; ex:direction ex:forward ; qb4o:cardinality qb4o:OneToMany . ssb:shs2 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:shl2 ; qb4o:childLevel ssb:shl1 ; rdf:predicate skos:broader ; ex:direction ex:forward ; ex:isPartial "true"^^xsd:boolean ; qb4o:cardinality qb4o:OneToMany . ssb:shs3 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:shl3 ; qb4o:childLevel ssb:shl2 ; rdf:predicate skos:broader ; ex:direction ex:forward ; qb4o:cardinality qb4o:OneToMany . ssb:shs4 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:shl4 ; qb4o:childLevel ssb:shl3 ; rdf:predicate skos:broader ; ex:direction ex:forward ; qb4o:cardinality qb4o:OneToMany . ssb:shs5 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:shl3 ; qb4o:childLevel ssb:shl1 ; rdf:predicate ssb:s_nation ; ex:direction ex:forward; ex:isPartial "true"^^xsd:boolean ; qb4o:cardinality qb4o:OneToMany . ### -- Dimension Customers ssb:CustomerDim a rdf:Property, qb:DimensionProperty ; rdfs:label "Customer Dimension"@en ; qb4o:hasHierarchy ssb:CustomerHierarchy . ssb:CustomerHierarchy qb4o:inDimension ssb:CustomerDim ; qb4o:hasLevel ssb:Customer ; qb4o:hasLevel ssb:C_City ; qb4o:hasLevel ssb:C_Nation ; qb4o:hasLevel ssb:C_Region . ssb:Customer a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:C_City a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:C_Nation a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:C_Region a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:chl1 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:Customer ; ex:isViewable "false"^^xsd:boolean ; qb4o:hierarchyComponent ssb:CustomerHierarchy . ssb:chl2 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:C_City ; qb4o:hierarchyComponent ssb:CustomerHierarchy . ssb:chl3 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:C_Nation ; qb4o:hierarchyComponent ssb:CustomerHierarchy . ssb:chl4 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:C_Region ; qb4o:hierarchyComponent ssb:CustomerHierarchy . ssb:chs1 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:chl1 ; qb4o:childLevel qb:Observation ; rdf:predicate ssb:l_customer ; ex:direction ex:forward ; qb4o:cardinality qb4o:OneToMany . ssb:chs2 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:chl2 ; qb4o:childLevel ssb:chl1 ; rdf:predicate skos:broader ; ex:direction ex:forward ; ex:isPartial "false"^^xsd:boolean ; qb4o:cardinality qb4o:OneToMany . ssb:chs3 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:chl3 ; qb4o:childLevel ssb:chl2 ; rdf:predicate skos:broader ; ex:direction ex:forward ; qb4o:cardinality qb4o:OneToMany . ssb:chs4 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:chl4 ; qb4o:childLevel ssb:chl3 ; rdf:predicate skos:broader ; ex:direction ex:forward ; qb4o:cardinality qb4o:OneToMany . ### -- Dimension PartsDim ssb:PartsDim a rdf:Property, qb:DimensionProperty ; rdfs:label "Parts Dimension"@en ; qb4o:hasHierarchy ssb:PartHierarchy . ssb:PartHierarchy qb4o:inDimension ssb:PartsDim ; qb4o:hasLevel ssb:Part, ssb:Brand, ssb:Category, ssb:Manufacturer . #levels ssb:phl1 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:Part ; qb4o:hierarchyComponent ssb:PartHierarchy . ssb:phl2 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:Brand ; qb4o:hierarchyComponent ssb:PartHierarchy . ssb:phl3 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:Category ; qb4o:hierarchyComponent ssb:PartHierarchy . ssb:phl4 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:Manufacturer ; qb4o:hierarchyComponent ssb:PartHierarchy . ##### steps ssb:phs1 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:phl1 ; qb4o:childLevel qb:Observation ; rdf:predicate ssb:l_part ; ex:direction ex:forward; qb4o:cardinality qb4o:OneToMany . ssb:phs2 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:phl2 ; qb4o:childLevel ssb:phl1 ; rdf:predicate skos:broader ; ex:direction ex:forward; ex:isPartial "true"^^xsd:boolean ; qb4o:cardinality qb4o:OneToMany . ssb:phs3 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:phl3 ; qb4o:childLevel ssb:phl2 ; rdf:predicate skos:broader ; ex:direction ex:forward; qb4o:cardinality qb4o:OneToMany . ssb:phs25 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:phl3 ; qb4o:childLevel ssb:phl1 ; rdf:predicate ssb:p_category ; ex:direction ex:forward; ex:isPartial "true"^^xsd:boolean ; qb4o:cardinality qb4o:OneToMany . ssb:phs4 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:phl4 ; qb4o:childLevel ssb:phl3 ; rdf:predicate skos:broader ; ex:direction ex:forward; qb4o:cardinality qb4o:OneToMany . ### -- Dimension Dates ssb:DateDim a rdf:Property, qb:DimensionProperty ; rdfs:label "Date Dimension"@en ; qb4o:hasHierarchy ssb:DateHierarchy . ssb:DateHierarchy qb4o:inDimension ssb:DateDim ; qb4o:hasLevel ssb:Date ; qb4o:hasLevel ssb:Month ; qb4o:hasLevel ssb:Year . ssb:Date a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:Month a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:Year a qb4o:HierarchyProperty, qb4o:LevelProperty . ssb:dhl1 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:Date ; ex:isViewable "false"^^xsd:boolean ; qb4o:hierarchyComponent ssb:DateHierarchy . ssb:dhl2 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:Month ; qb4o:hierarchyComponent ssb:DateHierarchy . ssb:dhl3 a qb4o:LevelInHierarchy ; qb4o:levelComponent ssb:Year ; qb4o:hierarchyComponent ssb:DateHierarchy . ssb:dhs1 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:dhl1 ; qb4o:childLevel qb:Observation ; rdf:predicate ssb:l_orderdate ; ex:direction ex:forward ; qb4o:cardinality qb4o:OneToMany . ssb:dhs2 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:dhl2 ; qb4o:childLevel ssb:dhl1 ; rdf:predicate skos:broader ; ex:direction ex:forward ; qb4o:cardinality qb4o:OneToMany . ssb:dhs3 a qb4o:HierarchyStep ; qb4o:parentLevel ssb:dhl3 ; qb4o:childLevel ssb:dhl2 ; rdf:predicate skos:broader ; ex:direction ex:forward ; qb4o:cardinality qb4o:OneToMany .