ETL+ Time Series

zData Warehouse tables for fiscal period time series (fiscal weeks, quarters, years; day of the fiscal year). The time series tables are 4_Today, 5_Date, 6_Date_Period, and ZDu.

4_Today

4_Today consists of 1 row with values relative to today’s date (_Date)

• Customizations NOT Recommended.

• You might find this table under the zData Warehouse grouping on ETL page’s center panel.

4_Today Columns

_Date: Today’s date as datetime (e.g.: 2022-04-03 00:00:00.000).

Value depends on ETL+ Settings page > Reporting Date.

(options: Today, Yesterday, Last Month’s End). See ETL+ Settings Page.

FP_NoInt2: This Fiscal Period as a 2-digit integer (e.g.: 4).
FP_NoChar2: This Fiscal Period as a char(2) (e.g.: ‘04').
FP_YYYYPP_NoInt6: This Fiscal Period with a YYYYPP value as a 6-digit integer (ex.: 202204).
FP_FYYYY-PP_Char10: This Fiscal Period with a ‘FY YYYY-PP’ value as a char(10) (ex.: ‘FY 2022-04'). ‘FY ' prefix only shows when first fiscal period is not Jan.
FQ_NoInt1: This Fiscal Quarter as a 1-digit integer (ex.: 2).
FQ_NoChar3: This Fiscal Qaurter as a char(3) (e.g.: ‘FQ2’).
FY_NoInt4: This Fiscal Year as a 4-digit integer (e.g.: 2022).
FY_NoChar4: This Fiscal Year as a char(4) (e.g.: ‘2022’).
FW_NoInt2: This Fiscal Week as a 2-digit integer (e.g.: 8).
FW_NoChar2: This Fiscal Week as a char(2) (e.g.: ‘08’).
CWDay_NameChar3: Today’s calendar week day as char(3) (e.g.: ‘Mon’).
FY_DayNo_Int3: Day of the fiscal year as a 3-digit integer. e.g.: if fiscal year starts on Feb 1st and today is Jan 31, this column becomes 364. Useful for YTD calculations at the day level.

5_Date

DataSelf Date table: 1 row per day.
Customizations NOT Recommended.
You might find this table under the zData Warehouse grouping on ETL page’s center panel.

6_DatePeriod

DataSelf DatePeriod table: 1 row per period.
Customizations NOT Recommended.
You might find this table under the zData Warehouse grouping on ETL page’s center panel.

Special Fiscal Periods.

zDateUntreated

You might find this table under the zDateUntreated grouping on ETL page’s center panel.

DataSelf hosted data warehouse: This table comes pre-loaded to your data warehouse. It’s not listed on the ETL+ pages, but it’s available for data warehouse re-imports.

Your on-premises or private cloud data warehouse: You might find this table under the zData Warehouse grouping on ETL page’s center panel. Right-click this table on the center panel → Load Now. This downloads the DataSelf Excel template to your hard drive into the ETL+ folder\DS_SourceFiles Windows folder, and load its data to your data warehouse.

If you need to re-load this file’s data, you can change ETL+ source to import it directly from your locally downloaded Excel file.

If you don’t want to accidentally re-load this table, delete it from ETL+ center panel, but do NOT confirm “Delete the physical table?” prompt to keep the table static in the data warehouse.

Check out other helpful columns: This file has several additional columns that might be of value to your specific needs but that aren’t mapped in the time series tables above. Ex.: columns for fiscal week ‘FY 2022-W08’ and day number in a quarter.