UNIVERSITAS BINA NUSANTARA __________________________________________________________________ Jurusan Teknik Informatika Skripsi Sarjana Komputer Semester Ganjil Tahun 2007/2008
ANALISIS DAN PERANCANGAN DATA WAREHOUSE UNTUK PENGELOLAAN PENJUALAN PADA PT. LIPPO KARAWACI, TBK. Franky Kamajaya 0800759955 Irene Samantha 0800760162 Steven Lim 0800777693 Kelas / Kelompok : 07PCT / 09
Abstrak Tujuan dari penelitian ini adalah merancang data warehouse yang sesuai dengan kebutuhan perusahaan PT. Lippo Karawaci, Tbk. Perusahaan ini bergerak pada bidang properti mulai dari pengadaan tanah sampai dengan pembangunan serta maintenance-nya. Perancangan data warehouse ini dibatasi pada bagian penjualan. Penggunaan data warehouse ini diharapkan dapat menunjang kebutuhan informasi bagi para eksekutif dalam mengambil keputusan bisnis dengan cepat. Metode penelitian yang digunakan yaitu metode analisis dan perancangan. Metode analisis dilakukan melalui studi kepustakaan dan wawancara dengan pihak terkait. Metode perancangan dilakukan dengan menentukan proses, grain, dimensi, fakta, measure, serta melakukan pemetaan OLTP ke data warehouse, yang dilanjutkan dengan perancangan physical. Hasil penelitian ini adalah sistem aplikasi data warehouse yang mencakup data warehouse, OLAP cube dan sebuah sistem aplikasi yang digunakan untuk mengakses data warehouse. Implementasi dari data warehouse ini telah dievaluasi dengan hasil evaluasi yang berkaitan dengan tampilan, manfaat dan keakuratan data aplikasi. Masih dibutuhkan pengembangan selanjutnya dari program aplikasi yang dibuat.
Kata Kunci : data warehouse, cube, measure, dimensi
vii
PRAKATA
Puji dan syukur kami ucapkan kepada Tuhan Yang Maha Esa karena berkat rahmat dan karunia-Nya, penulis dapat menyelesaikan skripsi yang berjudul “Analisis dan Perancangan Data Warehouse untuk Pengelolaan Penjualan pada PT. Lippo Karawaci, Tbk.” dengan baik dan tepat waktu. Tujuan dari penulisan skripsi ini adalah sebagai salah satu syarat untuk menyelesaikan program studi Strata 1 (S-1) dengan jurusan Teknik Informatika dan mendapatkan gelar kesarjanaan pada Universitas Bina Nusantara. Pada kesempatan ini perkenankan penulis untuk mengucapkan terima kasih yang sebesar-besarnya pada : •
Prof. Dr. Gerardus Polla, M.App.Sc. selaku Rektor Universitas Bina Nusantara, yang telah memberi kesempatan kepada penulis untuk menyusun skripsi ini.
•
Freddy Purnomo, S.Kom., M.Com., selaku Ketua Jurusan Teknik Informatika.
•
M. Tassim Billah, Ir., M.Sc. selaku dosen pembimbing yang telah banyak memberi masukan kepada kami sehingga penulisan skripsi dapat selesai dengan baik dan tepat waktu.
•
Bapak Freddy Theodorus selaku Division Head MIS PT. Lippo Karawaci, Tbk.
•
Bapak Benny Saputro selaku Departement Head MIS PT. Lippo Karawaci, Tbk.
•
Bapak Eric selaku Section Head MIS PT. Lippo Karawaci, Tbk.
•
Bapak Felix selaku pihak PT. Lippo Karawaci, Tbk. yang juga sebagai pembimbing penulis ketika penulis melakukan survei dan dalam penyusunan skripsi.
viii
•
Bapak Albert, Ibu Linda, Ibu Lia, Ibu Maria, Bapak Donny IW, Bapak Ronald, Bapak Donny, Bapak Hengky selaku karyawan MIS PT. Lippo Karawaci, Tbk.
•
Seluruh dosen Universitas Bina Nusantara yang telah memberikan bekal dan tuntunan kepada penulis dengan berbagai pengetahuan selama ini.
•
Orang tua tercinta dan teman-teman yang telah banyak memberikan dukungan, bantuan, dan doa dalam penyusunan skripsi.
•
Serta semua pihak yang telah membantu penulis untuk menyelesaikan penulisan skripsi ini.
Penulis menyadari adanya kemungkinan kekurangan dalam skripsi ini karena keterbatasan penulis dalam hal kemampuan, pengetahuan serta pengalaman. Karena itu penulis mengharapkan adanya saran dan kritik yang berguna untuk menyempurnakan skripsi ini. Akhir kata penulis berharap agar skripsi ini berguna dan bermanfaat bagi semua pihak yang membaca atau memerlukan terutama PT. Lippo Karawaci, Tbk.
Jakarta, Januari 2008
Penulis
ix
DAFTAR ISI
Halaman Judul Luar ............................................................................................................ i Halaman Judul Dalam ........................................................................................................ ii Halaman Persetujuan hardcover ........................................................................................ iii Halaman pernyataan dewan penguji .................................................................................. iv Abstrak ............................................................................................................................. vii Prakata ............................................................................................................................. viii Daftar Isi ............................................................................................................................ x Daftar Tabel .................................................................................................................... xvi Daftar Gambar ............................................................................................................... xviii Daftar Lampiran ............................................................................................................. xxii BAB 1 PENDAHULUAN 1.1
Latar Belakang ........................................................................................... 1
1.2
Ruang Lingkup ........................................................................................... 2
1.3
Tujuan dan Manfaat Penulisan ................................................................... 2
1.4
Metodologi Penelitian ................................................................................ 3
1.5
Sistematika Penulisan ................................................................................ 4
BAB 2 LANDASAN TEORI 2.1
Pendekatan Data Warehouse ..................................................................... 6 2.1.1
Pengertian Data .............................................................................. 6
2.1.2
Pengertian Database ...................................................................... 6
2.1.3
Pengetian OLTP (On-Line Transaction Processing) ..................... 7
2.1.4
Pengertian Data Warehouse .......................................................... 7 x
2.1.5
Data Mart ....................................................................................... 8
2.1.6
Perbandingan Database dan Data Warehouse ............................... 9
2.1.7
Karakteristik Data Warehouse ..................................................... 10
2.1.8
2.1.7.1
Subject Oriented ............................................................ 10
2.1.7.2
Integrated ...................................................................... 10
2.1.7.3
Time Variant ................................................................. 10
2.1.7.4
Nonvolatile .................................................................... 10
Struktur Data Warehouse ............................................................ 11 2.1.8.1
Current Detail Data (Detil Data Saat Ini) .................... 11
2.1.8.2
Old Detail Data (Detil Data Historis)............................ 12
2.1.8.3
Lightly Summarized Data (Ringkasan Data Level Menengah) .................................................................... 12
2.1.8.4
Highly Summarized Data (Ringkasan Data Level Tinggi)...................................... 13
2.1.9
Arsirektur Data Warehouse ......................................................... 13
2.1.10 Data Flow dalam Data Warehouse .............................................. 16 2.1.11 Skema Data Warehouse ............................................................... 18 2.1.11.1 Tabel Fakta .................................................................... 18 2.1.11.2 Tabel Dimensi ............................................................... 18 2.1.11.3 Permodelan Dimensional .............................................. 19 2.1.11.4 Skema Bintang .............................................................. 19 2.1.11.5 Skema Snowflake .......................................................... 22 2.1.11.6 Keuntungan dari Penggunaan Permodelan Dimensional .................................................................. 24 xi
2.1.12 Metadata ...................................................................................... 24 2.1.13 Granularity .................................................................................. 25 2.1.14 Agregasi ....................................................................................... 25 2.1.15 Denormalisasi .............................................................................. 25 2.1.16 DTS (Data Transformation Service) ........................................... 26 2.1.17 Metodologi Perancangan Data Warehouse ................................. 27 2.1.18 Keuntungan Penggunaan Data Warehouse ................................. 29 2.1.19 OLAP (On-line Analytical Processing) ....................................... 30 2.1.20 Analysis Services .......................................................................... 31 2.1.21 Analisis Matriks ........................................................................... 31 2.1.22 Analisis Critical Success Factor .................................................. 32 2.2
Terminologi dalam Bidang Penjualan ..................................................... 33 2.2.1
Pengertian Penjualan .................................................................... 33
2.2.2
Fungsi Penjualan .......................................................................... 33
2.2.3
Prosedur Penjualan ....................................................................... 34
2.2.4
Dokumen Penjualan ..................................................................... 35
2.2.5
Sistem Informasi Penjualan ......................................................... 39
BAB 3 ANALISIS SISTEM YANG SEDANG BERJALAN 3.1
Tentang PT. Lippo Karawaci, Tbk. ......................................................... 40 3.1.1
Sejarah PT. Lippo Karawaci, Tbk. ............................................... 40
3.1.2
Tujuan PT. Lippo Karawaci, Tbk.. .............................................. 42
3.1.3
Kegiatan Bisnis Utama PT. Lippo Karawaci, Tbk. ..................... 43
3.1.4
Struktur Organisasi PT. Lippo Karawaci, Tbk. ........................... 44
3.1.5
Tugas dan Wewenang .................................................................. 44 xii
3.2
3.3
Sistem yang Sedang Berjalan ................................................................... 47 3.2.1
Konteks ........................................................................................ 47
3.2.2
Prosedur ....................................................................................... 48
Analisis Sistem yang Sedang Berjalan .................................................... 50 3.3.1
Subyek Data ................................................................................. 50
3.3.2
Fungsi Bisnis ................................................................................ 50
3.3.3
Analisis Matriks ........................................................................... 52 3.3.3.1
Matriks Unit Organisasi vs Lokasi ............................... 52
3.3.3.2
Matriks Unit Organisasi vs Subyek Data ...................... 53
3.3.3.3
Matriks Fungsi Bisnis vs Unit Organisasi .................... 54
3.3.3.4
Matriks Fungsi Bisnis vs Subyek Data ......................... 57
3.3.4
Analisis Citical Success Factor ................................................... 60
3.3.5
Teknologi Informasi pada PT. Lippo Karawaci, Tbk. ................. 60 3.3.5.1
Perangkat Keras ............................................................ 60
3.3.5.2
Perangkat Lunak ........................................................... 62
3.4
Analisis Kebutuhan Data dan Informasi .................................................. 62
3.5
Masalah yang Dihadapi ............................................................................ 63
3.6
Solusi Pemecahan Masalah ...................................................................... 64
BAB 4 PERANCANGAN DAN IMPLEMENTASI SISTEM YANG DIUSULKAN 4.1
Perancangan Data Warehouse ................................................................. 65 4.1.1
Arsitektur Data Warehouse ......................................................... 65
4.1.2
Rancangan Data Warehouse ........................................................ 66
4.1.3
Skema Bintang ............................................................................. 79 xiii
4.1.3.1
Skema Bintang FactAgingCustomersReceivable ......... 79
4.1.3.2
Skema Bintang FactCancellation .................................. 80
4.1.3.3
Skema Bintang FactCollection ..................................... 81
4.1.3.4
Skema Bintang FactKavlingHighlights ........................ 81
4.1.3.5
Skema Bintang FactPPJBdanAJBStatus ....................... 82
4.1.3.6
Skema Bintang FactSales .............................................. 82
4.1.3.7
Skema Bintang FactSalesAndCollectionStatus ............ 83
4.1.3.8
Skema Bintang FactSalesCollectionPercentage ........... 83
4.1.3.9
Skema Bintang Data Warehouse .................................. 84
4.1.4
Metadata ...................................................................................... 85
4.1.5
Analisis Kapasitas Penyimpanan Data dan pertumbuhan Data . 104
4.1.6
Rancangan DTS (Data Transformation Service)........................ 138
4.2
Rancangan Aplikasi ............................................................................... 144
4.3
Implementasi Sistem .............................................................................. 157 4.3.1
Spesifikasi Perangkat Keras ....................................................... 157
4.3.2
Spesifikasi Perangkat Lunak ...................................................... 158
4.3.3
Jadwal Implementasi .................................................................. 158
4.3.4
Kebutuhan Personil .................................................................... 159
4.3.5
Evaluasi ...................................................................................... 159
4.3.6
Petunjuk Operasional ................................................................. 160
BAB 5 SIMPULAN DAN SARAN 5.1
Simpulan ................................................................................................ 171
5.2
Saran ...................................................................................................... 171
DAFTAR PUSTAKA .................................................................................................... 173 xiv
RIWAYAT HIDUP ....................................................................................................... 175 LAMPIRAN-LAMPIRAN FOTOCOPY SURAT SURVEI
xv
DAFTAR TABEL
Tabel 2.1
Perbandingan database dan Data Warehouse .............................................. 9
Tabel 2.2
Analisis Matriks Unit Organisasi vs Lokasi ............................................... 32
Tabel 3.1
Matriks Unit Organisasi vs Lokasi ............................................................. 52
Tabel 3.2
Matriks Unit Organisasi vs Subyek Data .................................................... 53
Table 3.3
Matriks Fungsi Bisnis vs Unit Oganisasi .................................................... 54
Tabel 3.4
Matriks Fungsi Bisnis vs Subyek Data ....................................................... 57
Tabel 4.1
Tabel Hubungan Fakta dan Measure .......................................................... 68
Tabel 4.2
DimBuyer .................................................................................................... 86
Tabel 4.3
DimCluster .................................................................................................. 87
Tabel 4.4
DimCompany .............................................................................................. 87
Tabel 4.5
DimProject .................................................................................................. 88
Tabel 4.6
DimSeller .................................................................................................... 89
Tabel 4.7
DimTime ..................................................................................................... 90
Tabel 4.8
DimUnit ...................................................................................................... 91
Tabel 4.9
FactAgingCustomersReceivable ................................................................. 92
Tabel 4.10 FactCancellation ......................................................................................... 94 Tabel 4.11 FactCollection ............................................................................................. 95 Tabel 4.12 FactKavlingHighlights ................................................................................ 96 Tabel 4.13 FactPPJBandAJBStatus .............................................................................. 97 Tabel 4.14 FactSales ..................................................................................................... 99 Tabel 4.15 FactSalesAndCollectionStatus .................................................................. 101 xvi
Tabel 4.16 FactSalesCollectionPercentage ................................................................. 103 Tabel 4.17 Tabel Perhitungan Penyimpanan untuk 3 tahun ke depan ........................ 137 Tabel 4.18 Jadwal Implementasi ................................................................................. 158
xvii
DAFTAR GAMBAR
Gambar 2.1
Struktur Data Warehouse .......................................................................... 11
Gambar 2.2
Arsitektur Data Warehouse ...................................................................... 13
Gambar 2.3
Data Flow dalam Data Warehouse .......................................................... 16
Gambar 2.4
Skema Bintang Sederhana ........................................................................ 20
Gambar 2.5
Skema Bintang dengan Beberapa Tabel Fakta .......................................... 21
Gambar 2.6
Skema Bintang dengan Tabel Dimensi Tambahan ................................... 22
Gambar 2.7
Skema Snowflake ..................................................................................... .23
Gambar 3.1
Struktur Organisasi ................................................................................... 44
Gambar 3.2
Konteks Diagram Sistem Informasi Penjualan ......................................... 48
Gambar 3.3
Prosedur Sistem Penjualan ........................................................................ 49
Gambar 4.1 Arsitektur Data Warehouse pada PT.Lippo Karawaci, Tbk. .................... 65 Gambar 4.2
Skema Bintang FactAgingCustomersReceivable ..................................... 79
Gambar 4.3
Skema Bintang FactCancellation .............................................................. 80
Gambar 4.4
Skema Bintang FactCollection .................................................................. 81
Gambar 4.5
Skema Bintang FactKavlingHighlights ..................................................... 81
Gambar 4.6
Skema Bintang FactPPJBAndAJBStatus .................................................. 82
Gambar 4.7
Skema Bintang FactSales .......................................................................... 82
Gambar 4.8
Skema Bintang FactSalesAndCollectionStatus ........................................ 83
Gambar 4.9
Skema Bintang FactSalesCollectionPercentage ........................................ 83
Gambar 4.10 Skema Bintang Data Warehouse .............................................................. 84 Gambar 4.11 Rancangan Transformasi Data ................................................................ 138 xviii
Gambar 4.12 Gambar Package DimBuyer ................................................................... 139 Gambar 4.13 Gambar Package DimCluster ................................................................. 139 Gambar 4.14 Gambar Package DimCompany ............................................................. 139 Gambar 4.15 Gambar Package DimProject .................................................................. 140 Gambar 4.16 Gambar Package DimSeller .................................................................... 140 Gambar 4.17 Gambar Package DimTime ..................................................................... 140 Gambar 4.18 Gambar Package DimUnit ...................................................................... 141 Gambar 4.19 Gambar Package FactAgingCustomersReceivable ................................ 141 Gambar 4.20 Gambar Package FactCancellation ......................................................... 141 Gambar 4.21 Gambar Package FactCollection ............................................................. 142 Gambar 4.22 Gambar Package FactKavlingHighlights ............................................... 142 Gambar 4.23 Gambar Package FactPPJBAndAJBStatus ............................................. 142 Gambar 4.24 Gambar Package FactSales ..................................................................... 143 Gambar 4.25 Gambar Package FactSalesAndCollectionStatus ................................... 143 Gambar 4.26 Gambar Package FactSalesCollectionPercentage ................................... 143 Gambar 4.27 Tampilan layar Utama ............................................................................. 144 Gambar 4.28 Tampilan Form Log In ............................................................................ 144 Gambar 4.29 Tampilan Pesan Log In Sukses ............................................................... 144 Gambar 4.30 Tampilan Pesan Log In Gagal ................................................................. 145 Gambar 4.31 Tampilan Menu System ........................................................................... 145 Gambar 4.32 Tampilan Menu DTS ............................................................................... 146 Gambar 4.33 Tampilan Menu Report ........................................................................... 146 Gambar 4.34 Tampilan Loading DTS .......................................................................... 147 Gambar 4.35 Tampilan Pivot dan Chart Aging Customers Receivable ....................... 148 xix
Gambar 4.36 Tampilan Pivot dan Chart Cancellation .................................................. 149 Gambar 4.37 Tampilan Pivot dan Chart Collection ..................................................... 150 Gambar 4.38 Tampilan Pivot dan Chart Kavling Highlights ....................................... 151 Gambar 4.39 Tampilan Pivot dan Chart PPJB And AJB Status .................................. 152 Gambar 4.40 Tampilan Pivot dan Chart Sales ............................................................. 153 Gambar 4.41 Tampilan Pivot dan Chart Sales And Collection Status ......................... 154 Gambar 4.42 Tampilan Pivot dan Chart Sales Collection Percentage ......................... 155 Gambar 4.43 Tampilan Pesan Konfirmasi Log Out ...................................................... 155 Gambar 4.44 Tampilan About Us ................................................................................. 156 Gambar 4.45 Tampilan Form Add User ....................................................................... 156 Gambar 4.46 Tampilan Pesan Konfirmasi Add User .................................................... 156 Gambar 4.47 Tampilan Form Change Password ......................................................... 157 Gambar 4.48 Tampilan Pesan Konfirmasi Change Password ...................................... 157 Gambar 4.49 Layar Utama ............................................................................................ 160 Gambar 4.50 Form Log In ............................................................................................ 160 Gambar 4.51 Pesan Log In Sukses ................................................................................ 161 Gambar 4.52 Pesan Log In Gagal ................................................................................. 161 Gambar 4.53 Menu System ........................................................................................... 162 Gambar 4.54 Form Add User ........................................................................................ 162 Gambar 4.55 Pesan Konfirmasi Add User .................................................................... 163 Gambar 4.56 Form Change Password .......................................................................... 163 Gambar 4.57 Pesan Konfirmasi Change Password ...................................................... 163 Gambar 4.58 Pesan Konfirmasi Log Out ...................................................................... 164 Gambar 4.59 Menu DTS ............................................................................................... 164 xx
Gambar 4.60 Loading DTS FactCollection .................................................................. 165 Gambar 4.61 Report Collection .................................................................................... 166 Gambar 4.62 Print Pivot Collection ............................................................................. 167 Gambar 4.63 Print Collection Chart ............................................................................. 167 Gambar 4.64 Pesan Export Pivot to Excel .................................................................... 168 Gambar 4.65 Export Pivot to Excel .............................................................................. 168 Gambar 4.66 Pesan Export Chart to Excel ................................................................... 169 Gambar 4.67 Export Chart to Excel ............................................................................. 169 Gambar 4.68 About Us .................................................................................................. 170
xxi
DAFTAR LAMPIRAN
Lampiran A
Database Code
A.1
Tabel DimBuyer .................................................................................... L1
A.2
Tabel DimCluster .................................................................................. L1
A.3
Tabel DimCompany .............................................................................. L2
A.4
Tabel DimProject .................................................................................. L2
A.5
Tabel DimSeller .................................................................................... L2
A.6
Tabel DimTime ..................................................................................... L3
A.7
Tabel DimUnit ...................................................................................... L3
A.8
Tabel FactAgingCustomersReceivable ................................................. L4
A.9
Tabel FactCancellation ......................................................................... L5
A.10
Tabel FactCollection ............................................................................. L5
A.11
Tabel FactKavlingHighlights ................................................................ L5
A.12
Tabel FactPPJBAndAJBStatus ............................................................. L6
A.13
Tabel FactSales ..................................................................................... L6
A.14
Tabel FactSalesAndCollectionStatus .................................................... L7
A.15
Tabel FactSalesCollectionPercentage ................................................... L7
A.16
Tabel Ms_User ...................................................................................... L8
A.17
Tabel FilterTimeStamp ......................................................................... L8
A.18
Stored Procedure Update_FilterTimeStamp ...................................... L8
A.19
Stored Procedure SP_DTSDimBuyer ................................................ L9
A.20
Stored Procedure SP_DTSDimCluster ............................................... L9
A.21
Stored Procedure SP_DTSDimCompany ......................................... L10 xxii
A.22
Stored Procedure SP_DTSDimProject ............................................. L11
A.23
Stored Procedure SP_DTSDimSeller ............................................... L12
A.24
Stored Procedure SP_DTSDimTime ................................................ L13
A.25
Stored Procedure SP_DTSDimUnit ................................................. L15
A.26
Stored Procedure SP_DTSFactAgingCustomersReceivable ............ L16
A.27
Stored Procedure SP_DTSFactCancellation ..................................... L32
A.28
Stored Procedure SP_DTSFactCollection ........................................ L36
A.29
Stored Procedure SP_DTSFactKavlingHighlights ........................... L40
A.30
Stored Procedure SP_DTSFactPPJBAndAJBStatus ........................ L44
A.31
Stored Procedure SP_DTSFactSales ................................................ L52
A.32
Stored Procedure SP_DTSFactSalesAndCollectionStatus ............... L56
A.33
Stored Procedure SP_DTSFactSalesCollectionPercentage .............. L69
xxiii
Lampiran B
Data Transformation Service (DTS)
B.1
DimBuyer ............................................................................................ L73
B.2
DimCluster .......................................................................................... L73
B.3
DimCompany ...................................................................................... L73
B.4
DimProject .......................................................................................... L74
B.5
DimSeller ............................................................................................ L74
B.6
DimTime ............................................................................................. L74
B.7
DimUnit .............................................................................................. L75
B.8
FactAgingCustomersReceivable ......................................................... L75
B.9
FactCancellation ................................................................................. L75
B.10
FactCollection ..................................................................................... L76
B.11
FactKavlingHighlights ........................................................................ L76
B.12
FactPPJBAndAJBStatus ..................................................................... L76
B.13
FactSales ............................................................................................. L77
B.14
FactSalesAndCollectionStatus ............................................................ L77
B.15
FactSalesCollectionPercentage ........................................................... L77
xxiv
Lampiran C
Perancangan Layar Aplikasi Data Warehouse
C.1
Layar Utama ........................................................................................ L78
C.2
Menu DTS ........................................................................................... L79
C.3
Menu Reports ...................................................................................... L80
C.4
Form Login ......................................................................................... L80
C.5
Pesan Log In Sukses ............................................................................ L80
C.6
Pesan Log In Gagal ............................................................................. L81
C.7
Form Add User ................................................................................... L81
C.8
Pesan Konfirmasi Add User ................................................................ L81
C.9
Form Change Password ..................................................................... L81
C.10
Pesan Konfirmasi Change Password .................................................. L81
C.11
Pesan Konfirmasi Log Out .................................................................. L82
C.12
DTS FactAgingCustomersReceiveble ................................................. L82
C.13
DTS FactCancellation ......................................................................... L82
C.14
DTS FactCollection ............................................................................ L82
C.15
DTS FactKavlingHighlights ............................................................... L83
C.16
DTS FactPPJBAndAJBStatus ............................................................. L83
C.17
DTS FactSales...................................................................................... L83
C.18
DTS FactSalesAndCollectionStatus ................................................... L84
C.19
DTS FactSalesCollectionPercentage.................................................... L84
C.20
Report Aging Customers Receiveble................................................... L85
C.21
Print Pivot Aging Customers Receiveble ........................................... L85
C.22
Print Aging Customers Receiveble Chart ........................................... L86
C.23
Export Pivot Aging Customers Receiveble to Excel .......................... L86 xxv
C.24
Export Aging Customers Receiveble Chart to Excel .......................... L87
C.25
Report Cancellation ............................................................................ L87
C.26
Print Pivot Cancellation ...................................................................... L88
C.27
Print Cancellation Chart...................................................................... L88
C.28
Export Pivot Cancellation to Excel ..................................................... L89
C.29
Export Cancellation Chart to Excel .................................................... L89
C.30
Report Collection ................................................................................ L90
C.31
Print Pivot Collection ......................................................................... L90
C.32
Print Collection Chart ......................................................................... L91
C.33
Export Pivot Collection to Excel ......................................................... L91
C.34
Export Collection Chart to Excel ........................................................ L92
C.35
Report Kavling Highlights .................................................................. L92
C.36
Print Pivot Kavling Highlights ........................................................... L93
C.37
Print Kavling Highlights Chart ........................................................... L93
C.38
Export Pivot Kavling Highlights to Excel ........................................... L94
C.39
Export Kavling Highlights Chart to Excel .......................................... L94
C.40
Report PPJB And AJB Status ............................................................. L95
C.41
Print Pivot PPJB And AJB Status ...................................................... L95
C.42
Print PPJB And AJB Status Chart....................................................... L96
C.43
Export Pivot PPJB And AJB Status to Excel ...................................... L96
C.44
Export PPJB And AJB Status Chart to Excel ..................................... L97
C.45
Report Sales ........................................................................................ L97
C.46
Print Pivot Sales ................................................................................. L98
C.47
Print Sales Chart.................................................................................. L98 xxvi
C.48
Export Pivot Sales to Excel ................................................................ L99
C.49
Export Sales Chart to Excel ................................................................ L99
C.50
Report Sales And Collection Status .................................................. L100
C.51
Print Pivot Sales And Collection Status ........................................... L100
C.52
Print Sales And Collection Status Chart ........................................... L101
C.53
Export Pivot Sales And Collection Status to Excel ......................... L101
C.54
Export Sales And Collection Status Chart to Excel .......................... L102
C.55
Report Sales Collection Percentage .................................................. L102
C.56
Print Pivot Sales Collection Percentage ........................................... L103
C.57
Print Sales Collection Percentage Chart ........................................... L103
C.58
Export Pivot Sales Collection Percentage to Excel ........................... L104
C.59
Export Sales Collection Percentage Chart to Excel .......................... L104
C.60
About Us ........................................................................................... L105
xxvii
Lampiran D
Spesifikasi Proses Aplikasi Data Warehouse
D.1
Modul Layar Utama .......................................................................... L106
D.2
Modul System ................................................................................... L106
D.3
Modul Log in .................................................................................... L106
D.4
Modul Add User ............................................................................... L107
D.5
Modul Change Password .................................................................. L107
D.6
Modul Log out .................................................................................. L108
D.7
Modul Exit ........................................................................................ L108
D.8
Modul DTS ....................................................................................... L108
D.9
Modul Fact ........................................................................................ L108
D.10
Modul Sales ...................................................................................... L108
D.11
Modul Cancellation ........................................................................... L109
D.12
Modul Collection .............................................................................. L109
D.13
Modul Sales And Collection Status .................................................. L109
D.14
Modul Kavling Highlights ................................................................ L110
D.15
Modul PPJB And AJB Status ........................................................... L110
D.16
Modul Aging Customers Receivable ................................................ L111
D.17
Modul Sales And Collection Percentage .......................................... L111
D.18
Modul Report .................................................................................... L111
D.19
Modul Pivot Sales ............................................................................. L112
D.20
Modul Pivot Cancellation ................................................................. L112
D.21
Modul Pivot Collection ..................................................................... L112
D.22
Modul Pivot Kavling Highlights ....................................................... L113
D.23
Modul Pivot Sales And Collection Percentage ................................. L113 xxviii
D.24
Modul Pivot PPJB And AJB Status .................................................. L113
D.25
Modul Pivot Sales And Collection Status ......................................... L114
D.26
Modul Pivot Aging Customers Receivable ....................................... L114
D.27
Modul Windows ................................................................................ L115
D.28
Modul About Us ............................................................................... L115
D.29
Modul Class DTS............................................................................... L115
xxix
Lampiran E
Pertanyaan ....................................................................................... L116
xxx
