Nick,
We had developed an MIS reporting tool using Business Objects(Crystal Reports 11 Developer).The base data is taken
from Clarity. We have not used Data mart as it degraded the application performance. We have
identified the Key master tables and replicated the data daily from clarity during the Non Peak hours using an
Materialized View.Then based on the business logic (SOL Procedures)will insert the data in to custom report tables.
The reports will fetch the data from the Temp Tables.
Now coming to your question on Status Reporting:-
we have an Monthly Time lines where for Project status Report the Project RAG status must be updated by 4th working day
of every month where PM need to do the monthly status update e.g. achievements to date, progress over last month, next month’s focus etc
to be updated every month.Project managers need to key in this information through the Status Sub Page.(project object)
Overall Project RAG is determined by considering Project Time,Cost and Benefits/Scope while Milestone status is just
determined by Time. Project managers can key in this information through the Status link.Overall Project RAG is determined
by considering Project Time,Cost and Benefits/Scope while Milestone status is just determined by Time.
So every month on the cut off date the scheduled DB procedure will run and populate the data to the temp tables.we will fetch
the data From those tables and show in Reports.so PM's can view the project status for previous months.
Hope this helps :smile
Cheers,
sundar