•ISO
|
Attribute |
Description |
Example |
|---|---|---|
|
Calendar |
This sets the hierarchy of the date measures: [Year] > [Year Quarter] > [Year Month] > [Date] |
|
|
Date in the format YYYY-MM-DD |
2018-09-24 |
|
|
Day Of Month Name |
Abbreviated month name followed by the day of the month. |
Sep-24 |
|
Name of the month |
September |
|
|
Quarter |
Number of the Quarter: •1 is January to March •2 is April to June •3 is July to September •4 is October to December |
3 |
|
Quarter Name |
Name of the Quarter: •Q1 is January to March •Q2 is April to June •Q3 is July to September •Q4 is October to December |
Q3 |
|
Year in YYYY |
2018 |
|
|
Month of one Year. Year followed by abbreviated month name. |
2018 Sep |
|
|
Quarter of one Year. Year followed by Quarter name. |
2018 Q3 |
|
Attribute |
Description |
|---|---|
|
Financial |
This sets the hierarchy to: [Financial Year] > [Financial Period] > [Date] |
|
This is the fiscal period. |
|
|
Financial Period ID |
Financial Period ID |
|
Financial Year |
|
Attribute |
Description |
Example |
|---|---|---|
|
Date in MM/DD/YYYY |
9/24/2018 |
|
|
Name of the day. |
Monday |
|
|
Is Default Date |
This boolean measure is either True or False .
The value is True if date = default date. |
True |
|
Is Production Day |
This boolean measure is either True or False .
The value is True if date = day of production. |
False |
|
Is Shipment Day |
This boolean measure is either True or False .
The value is True if date = day of shipment. |
True |
|
Attribute |
Description |
Example |
|---|---|---|
|
ISO Day Of Week |
Number of the day of the week. Values: 1 - 7 (1=Monday, 2= Tuesday, ..., 7= Sunday) |
1 |
|
Number of the calendar week. Values: 1 - 53 |
39 |
|
|
ISO Weeks |
This sets the hierarchy to: [ISO Year] > [ISO Year Week] > [ISO Year Week Day] |
|
|
Year in YYYY |
2018 |
|
|
Combination of year and ISO week number |
2018-W39 |
|
|
Combination of year, ISO week number and ISO Day of Week |
2018-W39-1 |