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);
}
