Assignment:
Guidelines for Reporting to an IT Department
These are suggested guidelines for IT department reporting.
Would you please help make this standard by putting your thoughts and opinion. It assists in grammar/sentence construction and flow as well as organization of material.
Please feel free to add anything in order to make this corporate standard.
Key technical terms.
Cognos : name of software
SQL_ODS : Database Name
Report Developer : Report Authors.
Guidelines for Cognos REPORTING (Cognos):
New Reports/ Report Enhancement Request:
Users opened a helpdesk ticket through Altiris and attached the Report Request Document usually assigned as Cognos. Data Management Manager's will need to check Altiris ticket time to time to make sure if there is any new ticket has been assigned.
DM Manager's will need to re-assign this ticket to Cognos Report Developers.
DM Manager's will ask LOE for assigned ticket and update Project dashboard based on provided LOE from report developer.
Report Developer:
Responsibilities include supporting end user reporting requirements by developing reporting solutions on the Cognos 8.3 BI platform. This role will work within the Corporate IT department and support day to day reporting needs for multiple business users.
Report Developers will get notify ticket through via email.
Report Developers will review and report request documentation and may contact
Report requestor and DM team if necessary. Please contact the users if you have any questions regarding Report Request Document or need more information.
Report Developers responsibility to provide LOE for assigned ticket within 24 hours to DM Manager's.
After reviewing Report Request template it is a report Developers responsibility to set up meeting with users and introduce available function in Cognos tools.
(Also introduce Ad hoc query studio and its functionality)
Reports Developers are responsible for prioritize their works and try to respond to all new issues immediately. (You may want to consult with report requestor and DM Manager's for prioritization).
It is report developer responsibility to contact DM team if you configure any technical or Data issue.
Report Developer's must look data first in Frame Work Manager Packages if data is not available on Frame work manager package then please notify DM Managers.
All reports must build through SQL_ODS if you did not find the data in SQL_ODS then notify DM team for possible solution.
If you have to pull data from other then the SQL_ODS please notify DM Manager's.
Our first priority is build report through SQL_ODS.
If Data is not available on Frame Work Manager Package then we may need to create new packages.
Any new report development must meet Corporate report standard/criteria.
Must including following.
Must include Report Name
Must include Report Header
Must include Footer if necessary (Such as page #, run date time).
Report lay out should be in business standard.
Must include company logo on top left if report out put displays on HTML and PDF
Must use appropriate font
Must use Data format tool to clean up all unnecessary character.
After report is complete it is report developer's responsibility to notify Cognos admin to move report to QA folder in production.
After report moved to QA folder in production report developer will get notified from Cognos Admin and then report developer's will need to notify report owner for ready for test.
After UAT is complete it is report developer responsibility to notify Cognos Admin move report to specific folder by providing path. Also notify Admin if new folder needs to be created.
Report Developer's responsibility to notify Admin if reports require scheduling by providing detail information through email.
Report Developer's will get notify after report has been successfully moved to production.
It is a Report Developr's responsibility to notify report owner after report had been placed in production.
It is a Report Developer responsibility to notify project complete.