SetsCurrentPeriod Property

The SetsCurrentPeriod property sets or returns whether Transformer searches a data source to find the current period date.

Syntax

object .SetsCurrentPeriod

Applies To

CrossTabDataSource Object

DataSource Object

DbDataSource Object

FlatFileDataSource Object

IqdDataSource Object

Query Object

Discussion

When set to True, Transformer uses the associated data source to determine the current period date; that is, the latest date in the date column.

Transformer uses the current period date to evaluate relative time categories. For example, if the current date is 20010831, the Prior Month category shows a value of July.

If the model contains multiple data sources, choose which data sources Transformer examines to find the current period date. If this property is not specified, Transformer checks all data sources and selects the latest date.

Set this property to False in a data source used to populate a currency table. Alternatively, ensure that the name of the date column is different from the one used by the time dimension.

Default: True

Type

Boolean

Access

Read/Write

Examples

objDataSource 
= objModel.DataSources
	.Add(xtrObjectType.trFlatFileDataSource)objDataSource.SetsCurrentPeriod
= True