Model: Cash Planning - Specifications for Dimension Table: CASH FLOW PERIOD

On this page you will find the specifications regarding the Model: Cash Planning and Dimension Table: CASH FLOW PERIOD.

Attributes

AttributeDescription (where applicable)
Cash Flow DateRepresents the date for when the cash flow occurs
Current Month FlagRepresents a flag that is set to 1 if the date represents the current month. Else the value is 0.
Current Year FlagRepresents a flag that is set to 1 if the date represents the current year. Else the value is 0.
DateRepresents the date as YYYY-MM-DD
IDRepresents the date as YYYY-MM-DD
ISO WeekRepresents the ISO week number
Last 12 Months FlagRepresents a flag that is set to 1 if the date represents previous 12 months. Else the value is 0.
Last 24 Months FlagRepresents a flag that is set to 1 if the date represents previous 24 months. Else the value is 0.
MonthRepresents the date as month with three capital letters (JAN, FEB, MAR, …)
Month NoRepresents the date as month as number (1, 2, 3, …)
Month StringRepresents the date as month name (January, February, March, …)
Previous Month FlagRepresents a flag that is set to 1 if the date represents the previous month. Else the value is 0.
Previous Year FlagRepresents a flag that is set to 1 if the date represents the previous year. Else the value is 0.
QuarterBuild as "Q" + "Quarter No" (Q1, Q2, Q3 or Q4)
Quarter NoQuarter as number (1, 2, 3 or 4)
Reporting Day of MonthDay of Month
WeekBuild as "W" + "ISO WEEK" (W1, W2, W3, …)
Weekday NoRepresents the weekday number
Weekday StringRepresents the name of the day (in the week)
YearRepresents the year using four digits
Year (Week based)Represents the ISO year
YearMonthRepresents the year and month using six digits

Hierarchies

HierarchyLevel
YearQuarterMonthDateNo
Year
Quarter No
Month No
Date
YearQuarterMonthWeekDateString
Year
Quarter
Month
Week
Date

USED BY MODEL(S)

Model Name
Cash Planning

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
CASH FLOW PERIODDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line