# PRANAS: A Process Analytics System Based on Process Warehouse and Cube for Supply Chain Management
## 3 PRANAS: A Process Analytics System
### Process Warehouse  
A process warehouse is constructed for process operation analysis that will be used to design process cubes. Figure 2 shows a star schema of the constructed process warehouse as an example in the manufacturing industry. The star schema in Figure 2 has four fact tables for finance, customer, process, and growth to make extensibility and maintenance as easy as possible in changing business process. Moreover, the four fact tables contain performance measures of cKPIs for each perspective. On the other hand, three-dimensional tables in the star schema for time, event class, and case type contain the attributes that can be used for the criteria of analyzing the cKPIs. In the fact tables, the columns are categorized into three categories: Measures for SCOR-based cKPI, measures for manufacturing operations, and the composite measures combining the cKPI and manufacturing measures.  
\begin{table}
\begin{tabular}{c c c} \hline \hline
**Perspectives** & **cCSF** & **SCOR-Based cKPI** \\ \hline \multirow{6}{*}{Finance} & Collaboration value increase & output sales, yield \\ \cline{2-3}  & & design change cost, order \\  & Collaboration cost cutting & processing cost, logistical cost, \\  & & service cost \\ \cline{2-3}  & & Collaboration profitability \\  & improvement & sales profit, return rate \\ \cline{2-3}  & & Collaboration maturity \\  & & improvement & procedure compliance rate \\ \hline \multirow{6}{*}{Partnership/Customer} & Satisfaction improvement & deadline compliance rate, average \\  & & production & time of task processing \\ \cline{2-3}  & & Satisfaction improvement & \\  & & of output & return rate, change rate \\ \cline{2-3}  & & New partner secure & number of annual new partners \\ \cline{2-3}  & & Market share increase & obtain order rate \\ \cline{2-3}  & & Good communication & email response time, number \\  & & of meetings \\ \hline \multirow{6}{*}{Collaboration Process} & Collaboration schedule & \multirow{2}{*}{schedule compliance or violation} \\  & & compliance & \\ \cline{2-3}  & & Collaboration risk minimization & persistency rate of optimal stocks \\ \cline{2-3}  & & & \\ \cline{2-3}  & & Product quality increase & number of defective products, \\ \cline{2-3}  & & & defective product rate \\ \cline{2-3}  & & Product variability minimization & purchase prediction accuracy, \\  & & number of schedule changes \\ \cline{2-3}  & & Productivity improvement of & processing time, operation rate \\  & & collaboration process & of facilities \\ \hline \multirow{6}{*}{Growth/Coevolution} & Satisfaction improvement of & collaboration satisfaction, \\  & & collaboration manager & collaboration task \\ \cline{2-3}  & & & understanding degree \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & Productivity improvement of & task ability and skill rate \\ \cline{2-3}  & & collaboration manager & \\ \hline \hline \end{tabular}
\end{table}
Table 1: Collaborative Balanced Scorecard (cBSC) with collaborative critical success factors (cCSFs) and SCOR-based collaborative key performance indicators (cKPI) from four new perspectives.