Technical References

1-27
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Advanced Reporting Module
CalendarClosedDate
The CalendarClosedDate dimension provides a hierarchy for structuring queries about the date a
requisition or task was closed. Using query items in this dimension provides an easier way to filter or
group by dates, rather than having to choose a complete date and use an expression to extract, for
example, just the month or week you are interested in.
CalendarDueDate
The CalendarDueDate dimension provides a hierarchy for structuring queries about the date a requisition
or task was due. The same date formats are available as for the CalendarClosedDate dimension.
CalendarScheduledDate
The CalendarScheduledDate dimension provides a hierarchy for structuring queries about the date on
which a task which was allowed a scheduled start date was actually scheduled to start. If no explicit
scheduled start date was specified, the scheduled date is the same as the start date.
The same date formats are available as for the CalendarClosedDate dimension.
CalendarStartedDate
The CalendarStartedDate dimension provides a hierarchy for structuring queries about the date a
requisition or task was started. This is the actual start date.
The same date formats are available as for the CalendarClosedDate dimension.
Query Item Description
ClosedDateID Date a task or requisition was closed, in the format YYYYMMDD; for
example, 20081225
Full Date Complete date in the format dd-Mon-yyyy; for example, 25-Dec-2008
Day Month Name The month and day of the month; for example, Dec-25
Week of Year Week of the year, in the format Weekn-yy; for example Week1-08
Calendar Year Month Month of the calendar year in yyyy-nn format, where yyyy is a four-digit
year and nn is a number between 1 and 12; for example, 2008-12
Calendar Year Quarter Quarter of the calendar year in yyyy-Qn format, where yyyy is a
four-digit year and n is a number between 1 and 4; for example, 2008-Q4
ClosedWeekDay Day of the week on which the item was closed, where 1=Sunday and
7=Saturday
Day of Week Name Day of the week (Sunday-Saturday) on which the item was closed
ClosedDateWeekStartDate Starting date (Sunday) of the week in which the item was closed
ClosedDateWeekEndDate Ending date (Sunday) of the week in which the item was closed
ClosedDateMonth Month in which the item was closed
ClosedDateMonthName Name of the month in which the item was closed
ClosedDateQuarter Calendar quarter in which the item was closed
ClosedDateYear Calendar year (YYYY) in which the item was closed