public function prepareDatasetColumnLookupIds($datasetName, ColumnMetaData $column, array &$lookupValues) { $lookupValueColumn = new ColumnMetaData(); $lookupValueColumn->name = self::$COLUMN_NAME__ATTRIBUTE_LOOKUP_VALUE; $lookupValueColumn->initializeTypeFrom($column->type); $this->prepareIdentifiers(DateDimensionDatasetNames::YEARS, array($lookupValueColumn), NULL, self::$SEQUENCE_NAME__TIME, $lookupValues); }
public function prepareDatasetColumnLookupIds($datasetName, ColumnMetaData $column, array &$lookupValues) { $lookupDatasetName = StarSchemaNamingConvention::getAttributeRelatedName($datasetName, $column->name); $sequenceName = $lookupDatasetName; $lookupValueColumn = new ColumnMetaData(); $lookupValueColumn->name = 'value'; $lookupValueColumn->initializeTypeFrom($column->type); $this->prepareIdentifiers($lookupDatasetName, array($lookupValueColumn), NULL, $sequenceName, $lookupValues); }
public function prepareDatasetColumnLookupIds($datasetName, ColumnMetaData $column, array &$lookupValues) { $entryDateColumn = new ColumnMetaData(); $entryDateColumn->name = self::$COLUMN_NAME__ATTRIBUTE_LOOKUP_VALUE; $entryDateColumn->initializeTypeFrom($column->type); $this->loadIdentifiers(DateDimensionDatasetNames::DATES, array($entryDateColumn), $lookupValues); // even if we find a record for a particular date we still need to check if there are corresponding records for related fiscal year and quarters $dates = NULL; foreach ($lookupValues as $lookupKey => $lookupPproperties) { $entryDate = $lookupPproperties->{self::$COLUMN_NAME__ATTRIBUTE_LOOKUP_VALUE}; $datetime = new DateTimeProxy(new DateTime($entryDate)); $dates[$lookupKey] = $datetime; } $processedYearValues = $this->prepareYearIds($dates); $this->prepareQuarterIds($processedYearValues, $dates); $processedMonthValues = $this->prepareMonthIds($processedYearValues, $dates); $this->prepareDateIds($column, $lookupValues, $processedMonthValues, $dates); }