Tip: You can combine codes. For example, use YYYY MM DD to show dates in the
format 2007 Jan 01 and use YY "Q"Q to show dates in the format 07 Q1. For lunar
years, quarters are labeled Q1-4, months are labeled 1-12 or 1-13, and days are
labeled 1-28.
Date Functions
The following table describes the categories created by each supported date
function setting.
Date function setting Description
None
Use the value in the Source column.
Calendar year of 365 (or 366)
days
Based on the standard calendar in the format YYYY or YY.
Lunar year of 52 weeks Based on a lunar year, which contains exactly 52 weeks.
Calendar Quarter Based on the standard calendar in the form YYYY Q or YY
Q, where Q is the Quarter number 1-4.
Lunar Quarter Based on lunar quarters, which contain exactly 13 weeks.
Calendar month Based on the standard calendar, in the format
YYYY/MMM or YY/MMM.
4-week (lunar) month Based on a lunar month, which contains exactly four
weeks.
4-4-5 week pattern Based on repeating 3-month patterns containing four
weeks, four weeks, and five weeks.
4-5-4 week pattern Based on repeating 3-month patterns containing four
weeks, five weeks, and four weeks.
5-4-4 week pattern Based on repeating 3-month patterns containing five
weeks, four weeks, and four weeks.
Week Based on weeks, in the format YYYY/MMM/DD or YY/MMM/DD.
When using this function, you must specify how the
weeks split over month boundaries, and the day that
marks the start of each week, using the Time tab of the
Drill Category property sheet.
Day Use format YYYY/MMM/DD or YY/MMM/DD.
Tip: Because lunar years are one or two days shorter than calendar years, periods
that use the Lunar year of 52 weeks, Lunar Quarter, Lunar Month, 4-4-5 week
pattern, 4-5-4 week pattern,or5-4-4 week pattern date functions leave unassigned
days that, over several years, comprise entire weeks. You can manage these
unassigned days by selecting one of the available Add an extra week settings on
the Drill Category property sheet for the appropriate drill-down path.
Default File Locations
The following tables list the default file locations used in Cognos Transformer on
Windows 2000 and Windows XP, Windows Vista, and UNIX and Linux.
Object Default file location (Windows 2000/ Windows XP)
Model My Documents\Transformer\Models
Data Source Data files location as specified in IBM Cognos Configuration
Appendix D. Reference 325
To Next Page
Loading...
Need help?
General