protected function generateFunction($columnPrefix, ColumnMetaData $parentColumn, $configuration, $allowDate, $allowTime) { if (($configuration['part'] == 'date') && !$allowDate) { return; } if (($configuration['part'] == 'date:fiscal') && (!$allowDate || (FiscalYearConfiguration::$FIRST_MONTH == 1))) { return; } if (($configuration['part'] == 'time') && !$allowTime) { return; } // preparing extension for date value formatting $key = $this->datasourceHandler->getDataSourceType(); if (!isset($this->dateFormatExtensions[$key])) { $this->dateFormatExtensions[$key] = $this->datasourceHandler->getExtension('formatDateValue'); } $dateFormatExtension = $this->dateFormatExtensions[$key]; // preparing expression for calculated column $extensionMethodName = $configuration['methodName']; try { $expression = $dateFormatExtension->$extensionMethodName($this->datasourceHandler); } catch (UnsupportedOperationException $e) { $expression = FALSE; } if ($expression === FALSE) { $column = new ColumnMetaData(); $column->used = FALSE; } else { $formulaExpressionParser = new FormulaExpressionParser(SQLFormulaExpressionHandler::LANGUAGE__SQL); $column = new FormulaMetaData(); $column->type->applicationType = $configuration['datatype']; $column->source = str_replace( array('<columnName>', '<fiscalYearOffset>'), array( $formulaExpressionParser->assemble($columnPrefix), (12 - FiscalYearConfiguration::$FIRST_MONTH + 1)), $expression); } $column->name = $columnPrefix . '__' . $configuration['name']; $column->publicName = t($configuration['publicName']); $column->loaderName = get_class($this); // processing nested elements if (isset($configuration['elements'])) { foreach ($configuration['elements'] as $nestedConfiguration) { $this->generateFunction($columnPrefix, $column, $nestedConfiguration, $allowDate, $allowTime); } } if (($expression !== FALSE) || (count($column->branches) != 0)) { $parentColumn->branches[] = $column; } }
protected static function registerFactMeasure(CubeMetaData $cube, ColumnMetaData $column, $functionName, $additivity, $selectedApplicationType = NULL) { $measureName = StarSchemaNamingConvention::getFactRelatedMeasureName($column->name, $functionName); $measure = $cube->registerMeasure($measureName); $measure->publicName = t($functionName); $measure->description = t("System generated '@functionName' measure for '@columnName' column", array('@functionName' => $measure->publicName, '@columnName' => $column->publicName)); $measure->used = FALSE; $expression = FALSE; if ($column->persistence == FormulaMetaData::PERSISTENCE__CALCULATED) { if ($column->isUsed()) { try { $expressionAssembler = new FormulaExpressionAssembler($cube->factsDataset); $expression = $expressionAssembler->assemble($column); $measure->used = TRUE; } catch (Exception $e) { $message = t("@functionName measure assembled with errors. @error", array('@functionName' => $functionName, '@error' => $e->getMessage())); $measure->functionError = $message; LogHelper::log_warn($message); } } else { $measure->functionError = t("@functionName measure was not assembled for the unused column", array('@functionName' => $functionName)); } } else { $formulaExpressionParser = new FormulaExpressionParser(SQLFormulaExpressionHandler::LANGUAGE__SQL); $expression = $formulaExpressionParser->assemble($column->name); $measure->used = TRUE; } $measure->function = $expression === FALSE ? FALSE : $functionName . '(' . $expression . ')'; $measure->additivity = $additivity; $measure->type->applicationType = isset($selectedApplicationType) ? $selectedApplicationType : $column->type->applicationType; $measure->type->scale = $column->type->scale; }