現今的企業資料倉儲，提供許多面向的績效評估指標供管理者使用。而企業資料倉儲是被企業用來做分析應用的商業智慧的核心。在本研究中，將利現存的公式結構應用到SAP企業資源規劃系統中的交易資料以去產生績效評估指標，提供更多的績效評估指標以補充現有有限數量績效評估指標。 在本研究中主要有幾個問題需要探討：我們要如正確得從企業資源規劃系統中萃取用來產生績效評估指標的資料；現行萃取出的資料要利用何種方式將其作有效的歸納以及分類；如何分析現行的績效評估公式的結構，且結合原始資料以產績效評估指標。 本研究主要以模組化的流程角度分析，利用企業資源規劃系統中所提供的資料做為研究基礎。資料來源為SAP企業資源規劃系統中的屬性(attributes)資料以及SAP BI中的InfoCubes和Queries。利用thesaurus的方法進行資料分類及呈現。再將資料利用二元表示樹的方式分析公式結構，將其中的運算子進行分類，並將公式結構應用於所萃取的企業規劃系統中的資料，以產生更多的績效評估指標。 本研究藉由利用thesaurus分析所萃取的資料，將資料進行分類歸納，以此為基礎之下，再將資料應用於公式結構中，產生關於SAP 企業資源規劃系統中的企業績效評估指標，再以SAP BI所產生的績效評估指標做比較。 Business Information Warehouse (BW) provides many aspects of KPIs for managers to use. BW is the core of business intelligence and then provides many data of business content to be analyzed into analytical applications. First BW constructs the data model by OLAP and provides much information that is related to the ERP. In our research, we want to discover more KPIs from existing formulas and apply the methodology to the data of SAP ERP system that is stored in SAP R/3 repository. As we can see, the existing indexes are finite and the main question that we want to solve is how to generate these more KPIs with these data that is stored in SAP BI and SAP R/3. Therefore we have three sub-problems to should be solved. The first is how we extract the proper data from SAP BI and SAP R/3. The second is how we analyze these data systematically. And the last one is how we apply these formulas that exist in SA P BI to generate more indexes that we need. Here we extract data from attribute of SAP R/3, InfoCubes and Queries in SAP BI to be the raw data that we want to use. We use binary expression tree to construct formula structures and from formula structures, we try to find out operator class that can also apply to the data in ERP system. With operator class and data of ERP system, we generate possible KPI candidates. We compare the efficiency from KPI generation between SAP R/3 and SAP BI. We mainly generate indexes from the data types of quantity and currency. Here we can’t just generate the original indexes but also more indexes that can be used by the managerial meaning.
