- Business process lifecycle consists of four stages: process specification, process implementation, process execution and monitoring, and process analysis. Usually, the relationships among the stages are loosely defined. Due to the frequent changes in today's market, business processes are also changing constantly, thus the need for synchronized the various business process stages is increased. In this paper, we proposed a method for constructing data warehouse schemata from business process specification in order to allow the off-line analysis of the business process execution. We define the relationship among the business process specification stage and its monitoring and analysis stages, in order to facilitate querying the business process performance to identify potential improvements. The semi-automated transformation process also adheres with the need to address frequent changes as changing the business process specification will result in change within its monitoring requirements as well as its analysis infrastructure (i.e., the data warehouse schemata).