Display Alternate Calendars in OfficeConnect Reports
- Import alternate calendars in Time administration.
- Enable OfficeConnect for your instance.
- Security:Access OfficeConnect
Add multiple time elements from different calendars in a single Excel report. View how data
rolls up differently for the different time granularities.
Example: Your business plan requires reporting for these calendars:
- Labor Period Year. Structure: Week> Pay Period > Pay Year.
- Fiscal Year. Structure: Week> Fiscal Month > Fiscal Quarter > Fiscal Year.
- Open an existing report or create one.
- In theElementstab, expandTimeand expose the default and alternate calendars.
- Expand each calendar to expose the time elements in that calendar.
- From each calendar, add time elements to the report columns or rows.
- (Optional) Add account elements to the report.
- (Optional) Add Time label types so you can tell the different time granularities for which you’re viewing reporting data.Example: Add these label types:
- Labor Periods
- Calendar Year
- Fiscal Year
- Refresh report to see the data and the labels.