METHOD FOR MAINTAINING DATABASES INFORMATION ABOUT MULTIPLE INSTANCES OF AN ACTIVITY GENERATING, UPDATING VIRTUAL OLAP CUBE BASED ON MODIFIED STAR-SCHEMA

Challenges associated with maintaining information about multiple instances of an activity are addressed. Separate database tables are maintained for data corresponding to active instances of an organization's activities and for data corresponding to inactive instances of an organization's activities. Multiple database tables can be maintained for data corresponding to inactive instances of an activity. In another aspect, data from the active instances table and one or more inactive instances tables are processed to generate combined analysis data.