protected function useApplicableCubeRegions(CubeQueryRequest $request, CubeMetaData $cube)
{
$metamodel = data_controller_get_metamodel();
if (!isset($cube->regions)) {
return;
}
// FIXME add support for measures in query list. Selected region needs to suport not only returning measures but also querying onces
$isExactMatchRequired = FALSE;
if (isset($request->measures)) {
foreach ($request->measures as $requestMeasure) {
$measureName = $requestMeasure->measureName;
$cubeMeasure = $cube->findMeasure($measureName);
if (isset($cubeMeasure) && isset($cubeMeasure->aggregationType)) {
switch ($cubeMeasure->aggregationType) {
case MeasureTypes::ADDITIVE:
break;
case MeasureTypes::SEMI_ADDITIVE:
case MeasureTypes::NON_ADDITIVE:
$isExactMatchRequired = TRUE;
break;
default:
throw new UnsupportedOperationException(t('Unsupported measure aggregation type: @measureAggregationType', array('@measureAggregationType' => $cubeMeasure->aggregationType)));
}
}
}
}
// collecting possible eligible regions
$eligibleRegionNames = NULL;
foreach ($cube->regions as $regionName => $region) {
// checking if the region supports all requested measures
if (isset($request->measures)) {
foreach ($request->measures as $requestMeasure) {
if (!isset($region->measures[$requestMeasure->measureName])) {
continue 2;
}
}
}
$eligibleRegionNames[] = $regionName;
}
if (!isset($eligibleRegionNames)) {
return;
}
// filtering eligible regions based on requested or queried dimensions
if (isset($request->dimensions)) {
$this->excludeIneligibleRegions($cube, $eligibleRegionNames, $request->dimensions, $isExactMatchRequired);
}
if (isset($request->queries)) {
$this->excludeIneligibleRegions($cube, $eligibleRegionNames, $request->queries, $isExactMatchRequired);
}
// do we still have any regions which could be used for the request
if (count($eligibleRegionNames) === 0) {
return;
}
// we select first region suitable for the request
$selectedRegionName = reset($eligibleRegionNames);
$selectedRegion = $cube->regions->{$selectedRegionName};
// preparing new cube configuration
$regionCube = new CubeMetaData();
$regionCube->name = "{$cube->name}_using_{$selectedRegionName}_region";
// source dataset
$regionCube->sourceDatasetName = $selectedRegion->datasetName;
// dimensions
if (isset($cube->dimensions)) {
foreach ($cube->dimensions as $dimension) {
$dimensionName = $dimension->name;
if (!isset($selectedRegion->dimensions->{$dimensionName})) {
continue;
}
$regionCubeDimension = $regionCube->registerDimension($dimensionName);
$selectedRegionDimension = $selectedRegion->dimensions->{$dimensionName};
if (isset($selectedRegionDimension->levels)) {
// we need to prepare new dimension which contains levels which are supported by this region
$sourceLevel = NULL;
$isSelectedLevelFound = FALSE;
foreach ($dimension->levels as $level) {
$levelName = $level->name;
if (!$isSelectedLevelFound && isset($level->sourceColumnName)) {
$sourceLevel = $level;
}
$isLevelPresent = isset($selectedRegionDimension->levels->{$levelName});
if ($isLevelPresent) {
if ($isSelectedLevelFound) {
throw new UnsupportedOperationException(t("Only one level is supported yet for each dimension in '@selectedRegionName' region of '@cubeName' cube", array('@selectedRegionName' => $selectedRegionName, '@cubeName' => $cube->publicName)));
}
$isSelectedLevelFound = TRUE;
}
if ($isSelectedLevelFound) {
$regionLevel = $regionCubeDimension->registerLevel($levelName);
$regionLevel->initializeFrom($level);
if ($isLevelPresent) {
$regionLevel->sourceColumnName = $sourceLevel->sourceColumnName;
} elseif (isset($regionLevel->sourceColumnName)) {
// we cannot support source key on consecutive levels. It is only supported for 'virtual' cubes
unset($regionLevel->sourceColumnName);
}
}
}
} else {
$regionCubeDimension->initializeFrom($dimension);
}
}
}
// measures
if (isset($request->measures)) {
foreach ($request->measures as $requestMeasure) {
$measureName = $requestMeasure->measureName;
$cubeMeasure = $cube->getMeasure($measureName);
$regionMeasure = $regionCube->registerMeasure($measureName);
$regionMeasure->initializeFrom($cubeMeasure);
}
}
// FIXME the following code will throw an exception if we try to reuse the same region during execution of a PHP script
// registering the cube in meta model
$regionCube->temporary = TRUE;
// FIXME when loading meta model automatically create cubes for all regions
$metamodel->registerCube($regionCube);
// updating the request to use new cube
LogHelper::log_notice(t("Using '@selectedRegionName' region of '@cubeName' cube", array('@selectedRegionName' => $selectedRegionName, '@cubeName' => $cube->name)));
LogHelper::log_info(t('Creating temporary cube to satisfy this request: @regionCubeName', array('@regionCubeName' => $regionCube->name)));
// FIXME create new request and delete the following method in request class
$request->setCubeName($regionCube->name);
}