Design and Build OLAP Business Intelligence for Village Sustainable Development Planning

The Indonesian government-year period 2014–2019, endorsed the National Medium Term Development Plan (RPJMN) with the concept of building Indonesia from the rural area. One of the RPJMN focus is the development of rural and border areas brings a new paradigm for the village development. This village development paradigm change requires the support of village information system. Village Information System and Rural Areas (SIDeKa) has developed and implemented in dozens of villages in the some district as a pilot project. The transaction data and information in the village have captured accurately using SIDeKa. These data and information becoming crucial sources for development planning in the next phase. This paper describe design and build OLAP Business Intelligence for development planning at village and supra village (district) that integrates SIDeKa’s data from all villages and aligns the development planning with the vision, mission, and objectives of rural development. This paper presents model/architecture for ETL, star schema, and new measures that capture spatial and temporal dimensions. OLAP Business Intelligence will be useful for Village Sustainable Development Planning