Sql+Time+Period+Column Details

Element Details: Sql+Time+Period+Column

Available in: Logi Info

Source code name: SqlTimePeriodColumn

The ActiveSQL SqlTimePeriodColumn adds a new column in the DataLayer that represents a time period such as year, quarter, month, etc. The column can be used like any other column.

Set the ID attribute to the name of the new column.

Set the DataColumn attribute to the name of a column that has a date value.

Element Group:Add and Replace Columns

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

DataColumn

UserDefined

(Required) The name of a data field/column returned from the DataLayer.

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

TimePeriod

Year

Week

Second

Quarter

MonthName

MonthAbbreviation

Month

Minute

LastDayOfYear

LastDayOfWeek

LastDayOfQuarter

LastDayOfMonth

LastDayOfFiscalYear

LastDayOfFiscalQuarter

Hour

FiscalYear

FiscalQuarter

FirstSecondOfMinute

FirstMinuteOfHour

FirstHourOfDay

FirstDayOfYear

FirstDayOfWeek

FirstDayOfQuarter

FirstDayOfMonth

FirstDayOfFiscalYear

FirstDayOfFiscalQuarter

DayOfYear

DayOfWeekName

DayOfWeekAbbreviation

DayOfWeek

DayOfMonth

Date

(Required) The time period.

PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.ActiveSQL

Sql Query

CHILD ELEMENTS

Click element to drill down for more information.