@prefix qb: <http://purl.org/linked-data/cube#> .
@prefix lubm: <http://lubm.org/#> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix qb4o: <http://purl.org/olap#> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .
@prefix xsd:   <http://www.w3.org/2001/XMLSchema#> .
@prefix ex: <http://purl.org/rdfmav#> .

#### -- Data structure definition and dimensions
lubm:SSBDW a qb:DataStructureDefinition ;
	qb:component [qb:dimension lubm:StudentDim] ;
	qb:component [qb:dimension lubm:ProfessorDim] ;
	qb:component [qb:dimension lubm:CourseDim] ;
	#### -- Definition of measures
	qb:component [qb:measure lubm:CourseCount ; qb4o:AggregateFuction qb4o:Count ] ;
	qb:component [qb:attribute lubm:name ] ;
	rdfs:Datatype lubm:Course ;
	rdfs:Datatype lubm:GraduateCourse.


### -- Dimension Students
lubm:StudentDim a rdf:Property, qb:DimensionProperty ;
	rdfs:label "Student Dimension"@en ;
	qb4o:hasHierarchy lubm:StudentHierarchy .
	
lubm:StudentHierarchy qb4o:inDimension lubm:StudentDim ;
	qb4o:hasLevel lubm:Student ;
	qb4o:hasLevel lubm:StDepartment ;
	qb4o:hasLevel lubm:StUniversity ;
	qb4o:hasLevel lubm:StDegreeUniversity ;
	qb4o:hasLevel lubm:Adviser .

lubm:Student a qb4o:HierarchyProperty, qb4o:LevelProperty .

lubm:StDepartment a qb4o:HierarchyProperty, qb4o:LevelProperty .

lubm:StUniversity a qb4o:HierarchyProperty, qb4o:LevelProperty .

lubm:StDegreeUniversity a qb4o:HierarchyProperty, qb4o:LevelProperty .

lubm:Adviser a qb4o:HierarchyProperty, qb4o:LevelProperty .

lubm:AdviserUniversity a qb4o:HierarchyProperty, qb4o:LevelProperty .
	
lubm:shl1 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:Student ;
	qb4o:hierarchyComponent lubm:StudentHierarchy .

lubm:shl2 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:StDepartment ;
	qb4o:hierarchyComponent lubm:StudentHierarchy .

lubm:shl3 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:StUniversity ;
	qb4o:hierarchyComponent lubm:StudentHierarchy .

lubm:shl4 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:Adviser ;
	rdfs:Datatype lubm:Advisor ;
	qb4o:hierarchyComponent lubm:StudentHierarchy .
	
lubm:shl5 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:StDegreeUniversity ;
	qb4o:hierarchyComponent lubm:StudentHierarchy .

lubm:shl6 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:AdviserUniversity ;
	qb4o:hierarchyComponent lubm:StudentHierarchy .
	
lubm:shs1 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:shl1 ;
	qb4o:childLevel qb:Observation ;
	rdf:predicate lubm:takesCourse ;
	ex:direction ex:backward ;
	qb4o:cardinality qb4o:OneToMany .
	
lubm:shs2 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:shl2 ;
	qb4o:childLevel lubm:shl1 ;
	rdf:predicate lubm:memberOf ;
	ex:direction ex:forward ;
	qb4o:cardinality qb4o:OneToMany .	

lubm:shs3 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:shl3 ;
	qb4o:childLevel lubm:shl2 ;
	rdf:predicate lubm:subOrganizationOf ;
	ex:direction ex:forward ;
	qb4o:cardinality qb4o:OneToMany .

lubm:shs4 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:shl4 ;
	qb4o:childLevel lubm:shl1 ;
	rdf:predicate lubm:advisor ;
	ex:direction ex:forward ;
	qb4o:cardinality qb4o:OneToMany .

lubm:shs5 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:shl6 ;
	qb4o:childLevel lubm:shl4 ;
	rdf:predicate lubm:doctoralDegreeFrom ;
	ex:direction ex:forward;
	qb4o:cardinality qb4o:OneToMany .

lubm:shs6 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:shl5 ;
	qb4o:childLevel lubm:shl1 ;
	rdf:predicate lubm:undergraduateDegreeFrom ;
	ex:direction ex:forward ;
	qb4o:cardinality qb4o:OneToMany .
	
### -- Dimension ProfessorDim
lubm:ProfessorDim a rdf:Property, qb:DimensionProperty ;
	rdfs:label "Professor Dimension"@en ;
	qb4o:hasHierarchy lubm:ProfessorHierarchy .

lubm:ProfessorHierarchy qb4o:inDimension lubm:ProfessorDim ;
	qb4o:hasLevel lubm:ProfessorLvl, lubm:PrDepartment, lubm:PrUniversity, lubm:PrDegreeUniversity .

#levels
lubm:phl1 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:ProfessorLvl ;
	qb4o:hierarchyComponent lubm:ProfessorHierarchy .

lubm:phl2 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:PrDepartment ;
	qb4o:hierarchyComponent lubm:ProfessorHierarchy .

lubm:phl3 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:PrUniversity ;
	qb4o:hierarchyComponent lubm:ProfessorHierarchy .

lubm:phl4 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:PrDegreeUniversity ;
	qb4o:hierarchyComponent lubm:ProfessorHierarchy .


##### steps
lubm:phs1 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:phl1 ;
	qb4o:childLevel qb:Observation ;
	rdf:predicate lubm:teacherOf ;
	ex:isPartial "true"^^xsd:boolean ;
	ex:direction ex:backward;
	qb4o:cardinality qb4o:OneToMany .

lubm:phs2 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:phl2 ;
	qb4o:childLevel lubm:phl1 ;
	rdf:predicate lubm:worksFor ;
	ex:isPartial "false"^^xsd:boolean ;
	ex:direction ex:forward;
	qb4o:cardinality qb4o:OneToMany .	

lubm:phs25 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:phl2 ;
	qb4o:childLevel qb:Observation ;
	rdf:predicate lubm:offeringDepartment ;
	ex:isPartial "true"^^xsd:boolean ;
	ex:direction ex:forward;
	qb4o:cardinality qb4o:OneToMany .
	
lubm:phs3 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:phl3 ;
	qb4o:childLevel lubm:phl2 ;
	rdf:predicate lubm:subOrganizationOf ;
	ex:direction ex:forward;
	qb4o:cardinality qb4o:OneToMany .

lubm:phs4 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:phl4 ;
	qb4o:childLevel lubm:phl1 ;	
	rdf:predicate lubm:doctoralDegreeFrom ;
	ex:direction ex:forward;
	qb4o:cardinality qb4o:OneToMany .
	
	
### -- Dimension CourseDim
lubm:CourseDim a rdf:Property, qb:DimensionProperty ;
	rdfs:label "Course Dimension"@en ;
	qb4o:hasHierarchy lubm:CourseHierarchy .

lubm:CourseHierarchy qb4o:inDimension lubm:CourseDim ;
	qb4o:hasLevel lubm:CourseType .

#levels
lubm:chl1 a qb4o:LevelInHierarchy ;
	qb4o:levelComponent lubm:CourseType ;
	qb4o:hierarchyComponent lubm:CourseHierarchy .

##### steps
lubm:chs1 a qb4o:HierarchyStep ;
	qb4o:parentLevel lubm:chl1 ;
	qb4o:childLevel qb:Observation ;
	rdf:predicate rdf:type ;
	ex:direction ex:forward;
	qb4o:cardinality qb4o:OneToMany .