Dates

From DataSelf Knowledge Base
Jump to navigation Jump to search

Notes

Primary Date Dimensions

Main dates have the XXX Date Details that has Fiscal Code, Rolling Periods, etc. See also Date Formulas and

_B_ main views Dates for DSA data sources

The main date(s) in each datasource needs to have the following XXX Date XXXXX fields (from _C_Dates view), to be included in the DSA datasource within the XXX Date Fields hierarchy.

InvoiceDateFields.png InvoiceDateFiscalCodeFormula.png

SQL View Field Field Source
view=dbo._B_SalesHeader column=[Invoice Date Fiscal Code] source=dbo._c_dates.basedatefiscalcode
view=dbo._B_SalesHeader column=[Inv Date Rolling Months Key] source=dbo._c_dates.[rolling months key]
view=dbo._B_SalesHeader column=[Inv Date Rolling Months] source=dbo._c_dates.[rolling months]
view=dbo._B_SalesHeader column=[Inv Date Rolling Qtr Key] source=dbo._c_dates.[rolling qtr key]
view=dbo._B_SalesHeader column=[Inv Date Rolling Quarters] source=dbo._c_dates.[rolling quarters]
view=dbo._B_SalesHeader column=[Inv Date Rolling Week Key] source=dbo._c_dates.[rolling week key]
view=dbo._B_SalesHeader column=[Inv Date Rolling Weeks] source=dbo._c_dates.[rolling weeks]
view=dbo._B_SalesHeader column=[Inv Date Rolling Year Key] source=dbo._c_dates.[rolling year key]
view=dbo._B_SalesHeader column=[Inv Date Rolling Years] source=dbo._c_dates.[rolling years]
view=dbo._B_SalesHeader column=[Inv Date Today MTD] source=dbo._c_dates.[today mtd]
view=dbo._B_SalesHeader column=[Inv Date Today QTD] source=dbo._c_dates.[today qtd]
view=dbo._B_SalesHeader column=[Inv Date Today Relative Date Key] source=dbo._c_dates.[today relative date key]
view=dbo._B_SalesHeader column=[Inv Date Today Relative Month Key] source=dbo._c_dates.[today relative month key]
view=dbo._B_SalesHeader column=[Inv Date Today Relative Qtr Key] source=dbo._c_dates.[today relative qtr key]
view=dbo._B_SalesHeader column=[Inv Date Today Relative Year Key] source=dbo._c_dates.[today relative year key]
view=dbo._B_SalesHeader column=[Inv Date Today YTD] source=dbo._c_dates.[today ytd]

System Info Dates

Date Formulas

See also

Including_Dates_in_Rows