spaceDimension.loadObject(connection);
openTables.add(spaceDimension);
openTables.add(facts);
PresenceCube presenceCube = new PresenceCube(facts);
SpaceDimension spaceDim = new SpaceDimension(spaceDimension);
this.addDimension(spaceDim);
String sql = "case when get_trj_space_area_intersections(trdw_episode_facts.geom) > 0 then ceil(1/get_trj_space_area_intersections(trdw_episode_facts.geom)) else 0 end";
Measure episodePresence = new MondrianVirtualMeasure( "Episode Presence",
facts,
Measure.DATATYPE_NUMERIC,
Measure.AGGR_SUM,
sql);
presenceCube.addDimension(spaceDim);
presenceCube.addMeasure(episodePresence);
this.addCube(presenceCube);
}