| Excerpt |
|---|
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
DataSelf Today table: 4_Today consists of 1 row with today's values. values relative to today’s date (_Date)
Customizations NOT Recommended.
You might find this table under the
zData Warehousegrouping on ETL page’s center panel.
4_Today Columns
_Date: Today’s date as datetime (exe.g.: 2022-04-03 00:00:00.000). This column
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 (exe.g.: 4).
FP_NoChar2: This Fiscal Period as a char(2) (exe.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) (exe.g.: ‘FQ2’).
FY_NoInt4: This Fiscal Year as a 4-digit integer (exe.g.: 2022).
FY_NoChar4: This Fiscal Year as a char(4) (exe.g.: ‘2022’).
FW_NoInt2: This Fiscal Week as a 2-digit integer (exe.g.: 8).
FW_NoChar2: This Fiscal Week as a char(2) (exe.g.: ‘08’).
CWDay_NameChar3: Today’s calendar week day as char(3) (exe.g.: ‘Mon’).
FY_DayNo_Int3: Day of the fiscal year as a 3-digit integer. e. Exg.: if fiscal year starts on Feb 1st and today is Jan 31, this column becomes 364. Useful for YTD calculations at the day level.
...