2006

UNIVERSITAS BINA NUSANTARA Jurusan Teknik Informatika Skripsi Sarjana Komputer Semester Ganjil tahun 2005/2006

ANALISIS DAN PERANCANGAN DATA WAREHOUSE TRANSAKSI KONTRAK BERJANGKA PADA PT. BURSA BERJANGKA JAKARTA

Marjanti 0600614845 Feisanita 0600616850 Anastasia 0600650996 Kelas/Kelompok : 07PQT/ 03 Abstrak Tujuan penelitian ialah menganalisa dan merancang data warehouse sehingga diperoleh informasi yang berharga dari data-data yang ada dalam perusahaan, juga dari hasil pengolahan data ini dapat digunakan sebagai sumber yang dapat membantu pimpinan perusahaan untuk mengambil keputusan secara cepat dan akurat. Metode penelitian yang digunakan adalah metode analisis dan perancangan. Metode analisis dilakukan dengan teknik survei langsung terhadap sistem yang sedang berjalan pada perusahaan dan studi kepustakaan. Metode perancangan dilakukan dengan cara merancang tabel, skema bintang, rancangan layar dan output laporan. Hasil dari penelitian yang penulis lakukan adalah data-data dari transaksi kontrak jual beli mempunyai granularity yang rendah atau dengan kata lain datanya masih terlalu rinci. Jadi, diperlukan data yang lebih terintegrasi untuk mendukung pengambilan keputusan dari pihak manajerial PT. Bursa Berjangka Jakarta. Simpulan yang dapat diambil adalah perancangan data warehouse dapat menjawab segala kebutuhan perusahaan dalam penyajian laporan dengan data yang lebih terintegrasi dan ringkas.

Kata kunci : analisis, perancangan, data, warehouse, data warehouse, glanularity

vii

PRAKATA

Puji dan syukur penulis panjatkan kepada Tuhan Yang Maha Esa atas berkat dan karuniaNya sehingga penulis dapat menyelesaikan karya ilmiah ini. Adapun karya ilmiah ini berjudul “Analisis dan Perancangan Data Warehouse Transaksi Kontrak Berjangka pada PT. Bursa Berjangka Jakarta”. Tujuan dari penulisan karya ilmiah ini adalah sebagai salah satu syarat yang harus dipenuhi untuk mencapai gelar kesarjanaan pada jurusan Teknik Informatika jenjang pendidikan strata-1 pada Universitas Bina Nusantara. Pada kesempatan ini penulis ingin mengucapkan rasa terima kasih yang sebesarbesarnya kepada : -

Prof. Dr. Gerardus Polla, M.App.Sc., selaku Rektor Universitas Bina Nusantara.

-

H. Mohammad Subekti, BE. M.Sc., selaku Ketua Jurusan Teknik Informatika Universitas Bina Nusantara.

-

Fredy Purnomo, S.Kom. M.Kom., selaku Sekretaris Jurusan Teknik Informatika Universitas Bina Nusantara.

-

Agus Prahono Drs. M.Eng.Sc., selaku dosen pembimbing yang telah banyak membantu dan memberikan saran juga masukan dalam mengarahkan penulisan karya ilmiah ini.

-

J.W. Sudomo, selaku Direktur utama PT. Bursa Berjangka Jakarta

-

Ali Jaya dan Nur Ikhwanuddin, selaku staff divisi teknologi informasi dan perdagangan PT. Bursa Berjangka Jakarta yang membimbing dan memberi masukan selama dilakukannya penelitian. viii

-

Seluruh staff dan karyawan PT. Bursa Berjangka Jakarta yang telah memberikan kesempatan pada penulis untuk melakukan penelitian dan memberikan informasi yang berguna bagi penyusunan karya ilmiah ini.

-

Seluruh staff dan dosen jajaran jurusan Teknik Informatika yang telah memberikan ilmu di Universitas Bina Nusantara.

-

Teman-teman yang telah memberikan semangat serta masukan yang berarti selama penyusunan karya ilmiah ini.

-

Orang tua dan keluarga yang telah memberikan dukungan baik secara material maupun moral.

-

Juga pihak-pihak yang tidak dapat penulis sebutkan satu per satu yang telah membantu penulis dalam penulisan karya ilmiah ini.

Penulis berusaha untuk menyelesaikan karya ilmiah ini dengan sebaik-baiknya namun penulis menyadari keterbatasan yang ada maka dari itu tidaklah luput dari kesalahan. Untuk itu penulis harapkan rekan-rekan dapat menyempurnakannya agar menjadi karya ilmiah yang lebih baik lagi pada masa berikutnya. Akhir kata penulis juga berharap agar karya ilmiah ini dapat bermanfaat dan berguna bagi para pembaca di masa depan.

Jakarta, Januari 2006

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 .............................................................................................................. xvii Daftar Gambar........................................................................................................... xix Daftar Lampiran........................................................................................................ xxiii

BAB 1 PENDAHULUAN ...................................................................................... 1 1.1

Latar Belakang ...................................................................... 1

1.2

Ruang Lingkup...................................................................... 2

1.3

Tujuan dan Manfaat .............................................................. 2

1.4

Metodologi ............................................................................ 3

1.5

Sistematika Penulisan ........................................................... 5

BAB 2 LANDASAN TEORI ................................................................................. 7 2.1

Pengertian Sistem Informasi ................................................. 7

2.2

Pengertian Teknologi Informasi............................................ 8

2.3

Konsep Dasar Data Warehouse............................................. 9 x

2.4

2.3.1

Pengertian Data ......................................................... 9

2.3.2

Pengertian Database.................................................. 9

2.3.3

Pengertian Data Warehouse ...................................... 10

Aspek Penting dalam Data Warehouse................................. 12 2.4.1

2.4.2 2.5

2.6

Karakteristik Data Warehouse .................................. 12 2.4.1.1

Subject Oriented......................................... 13

2.4.1.2

Integrated ................................................... 13

2.4.1.3

Nonvolatile................................................. 14

2.4.1.4

Time Variant .............................................. 15

Granularity ................................................................ 16

Struktur Data Warehouse ...................................................... 17 2.5.1

Current Detail Data ................................................... 18

2.5.2

Older Detail Data ...................................................... 18

2.5.3

Lightly Summarized Data ......................................... 19

2.5.4

Highly Summarized Data.......................................... 19

2.5.5

Metadata.................................................................... 19

Anatomi Data Warehouse ..................................................... 20 2.6.1

Data Warehouse Fungsional ..................................... 21

2.6.2

Data Warehouse Terpusat ......................................... 21

2.6.3

Data Warehouse Terdistribusi................................... 22

2.7

Kegunaan Data Warehouse................................................... 23

2.8

Arsitektur Data Warehouse................................................... 25

2.9

Perancangan Data Warehouse dengan Skema Bintang......... 28 2.9.1

Keuntungan menggunakan Skema Bintang .............. 29 xi

2.9.2

Perancangan Skema Bintang..................................... 30

2.9.3

Skema Bintang Sederhana ........................................ 31

2.9.4

Skema Bintang dengan Banyak Tabel Fakta ............ 32

2.9.5

Skema Bintang Majemuk.......................................... 32

2.9.6

Skema Snowflake...................................................... 33

2.9.7

Agregasi .................................................................... 34

2.9.8

Denormalisasi ........................................................... 35

2.10

SWOT ................................................................................... 35

2.11

Critical Success Factor.......................................................... 36

2.12

Perdagangan Berjangka ........................................................ 37 2.12.1 Definisi Perdagangan Berjangka............................... 37 2.12.2 Fungsi dan Manfaat Ekonomi Perdagangan Berjangka .................................................................. 38 2.12.3 Institusi dalam Perdagangan Berjangka.................... 41 2.12.4 Definisi Bursa Berjangka .......................................... 42 2.12.5 Definisi Kontrak Berjangka ...................................... 43 2.12.6 Spesifikasi Dasar Kontrak Berjangka ....................... 43 2.12.7 Jenis Kontrak yang diperdagangkan ......................... 45 2.12.8 Penyelesaian Transaksi dalam Kontrak Berjangka... 45 2.12.9 Definisi Posisi Beli dan Posisi Jual........................... 46 2.12.9 Definisi Open Position.............................................. 46 2.12.10 Mekanisme Transaksi .............................................. 47

xii

BAB 3 ANALISIS KEBUTUHAN DATA WAREHOUSE ................................ 50 3.1

Metode Analisis dan Perancangan ........................................ 50

3.2

Latar Belakang Organisasi .................................................... 51 3.2.1 Tahun Berdiri Perusahaan, Notaris, Nomor Akta, Alamat, Bidang Usaha .............................................. 54

3.3

Struktur Organisasi ............................................................... 55 3.3.1

3.4

3.5

3.6

Tugas dan Wewenang ............................................... 56

Visi dan Misi Perusahaan...................................................... 68 3.4.1

Visi ............................................................................ 68

3.4.2

Misi ........................................................................... 68

Subjek Data dan Fungsi Bisnis ............................................. 69 3.5.1

Subjek Data ............................................................... 69

3.5.2

Fungsi Bisnis............................................................. 70

Analisis Matriks .................................................................... 71 3.6.1 Organisasi vs Subjek Data ........................................ 72 3.6.2

Organisasi vs Fungsi Bisnis ...................................... 73

3.6.3

Fungsi Bisnis vs Subjek Data ................................... 75

3.7

Analisis SWOT ..................................................................... 77

3.8

Analisis Critical Success Factor............................................ 79

3.9

Teknologi Informasi PT.Bursa Berjangka Jakarta................ 81 3.9.1

Perangkat Keras ........................................................ 81

3.9.2

Piranti Lunak............................................................. 82

3.9.3

Matriks Fungsi Bisnis vs Aplikasi ............................ 83

3.9.4

Matriks Subjek Data vs Aplikasi .............................. 86 xiii

3.10

Analisis Kebutuhan Data dan Informasi ............................... 88

3.11

Masalah yang dihadapi ......................................................... 89

3.12

Pemecahan Masalah.............................................................. 89

BAB 4 DATA WAREHOUSE YANG DIUSULKAN......................................... 91 4.1

Arsitektur Data Warehouse................................................... 91

4.2

Rancangan Data Warehouse ................................................. 98 4.2.1

Transformasi Data..................................................... 98

4.2.2

Metadata.................................................................... 100

4.2.3

Prototipe Aplikasi Data Warehouse.......................... 114 4.2.3.1 Form Awal Aplikasi...................................... 114 4.2.3.2 Form Login ................................................... 115 4.2.3.3 Menu Utama Aplikasi ................................... 116 4.2.3.4 Menu File ...................................................... 118 4.2.3.5 Form Add User ............................................. 119 4.2.3.6 Form Change Password ................................ 122 4.2.3.7 Form Delete User .......................................... 124 4.2.3.8 Jendela Log Out ............................................ 126 4.2.3.9 Menu View.................................................... 127 4.2.3.10 Form Graph Trade....................................... 128 4.2.3.11 Form Graph Market .................................... 136 4.2.3.12 Anak dari Submenu Pivot Table ................. 140 4.2.3.13 Form Pivot Table Fact Trade in Dynamic Cube 3.0 ...................................................... 140 xiv

4.2.3.14 Form Pivot Table Fact Market in Dynamic Cube 3.0 ...................................................... 143 4.2.3.15 Form Pivot Table in Cube Browser Analysis Manager ...................................................... 146 4.2.3.16 Form Query Trade....................................... 149 4.2.3.17 Form Query Market .................................... 152 4.2.3.18 Form Star Schema....................................... 154 4.2.3.19 Menu Search ............................................... 155 4.2.3.20 Form Search ................................................ 156 4.2.3.21 Menu Print .................................................. 158 4.2.3.22 Form Report Trade...................................... 158 4.2.3.23 Form Report Market ................................... 161 4.2.3.24 Menu About ................................................ 163 4.2.3.25 Form About Application ............................. 163 4.2.3.26 Form About Us ........................................... 164 4.3

4.4

Rancangan Implementasi ...................................................... 165 4.3.1

Dukungan Perangkat Keras....................................... 165

4.3.2

Dukungan Piranti Lunak ........................................... 166

Rancangan Skema Bintang ................................................... 167 4.4.1 Rancangan Skema Bintang Fact Trade ..................... 167 4.4.2 Rancangan Skema Bintang Fact Market................... 168 4.4.3 Rancangan Skema Bintang Gabungan...................... 168

4.5

Analisis Kapasitas Media Penyimpanan ............................... 169 4.5.1

Analisis Tabel Fakta ................................................. 169 xv

4.5.2

Analisis Tabel Dimensi............................................. 170

4.6

Analisis Pertumbuhan Data................................................... 171

4.7

Analisis Manfaat ................................................................... 172

4.8

Evaluasi Hasil Implementasi................................................. 173

BAB 5 SIMPULAN DAN SARAN........................................................................ 175 5.1

Simpulan ............................................................................... 175

5.2

Saran ..................................................................................... 176

DAFTAR PUSTAKA ............................................................................................... 177 RIWAYAT HIDUP .................................................................................................. 179 LAMPIRAN-LAMPIRAN ....................................................................................... L1 FOTOCOPY SURAT SURVEI ................................................................................ L30

xvi

DAFTAR TABEL

Tabel 2.1 Perbedaan data operasional dan data warehouse .......................................12 Tabel 2.2 Contoh selling hedging ..............................................................................39 Tabel 2.3 Contoh buying hedging..............................................................................40 Tabel 2.4 Open interest (i) .........................................................................................47 Tabel 2.5 Open interest (ii) ........................................................................................47 Tabel 3.1 Tabel subjek data .......................................................................................69 Tabel 3.2 Tabel fungsi bisnis .....................................................................................70 Tabel 3.3 Matriks organisasi vs subjek data ..............................................................72 Tabel 3.4 Matriks organisasi vs fungsi bisnis ........................................................... 73 Tabel 3.5 Matriks fungsi bisnis vs subjek data ..........................................................75 Tabel 3.6 Matriks SWOT...........................................................................................79 Tabel 3.7 Perangkat keras PT. Bursa Berjangka Jakarta ...........................................81 Tabel 3.8 Aplikasi PT. Bursa Berjangka Jakarta .......................................................83 Tabel 3.9 Matriks fungsi bisnis vs aplikasi............................................................... 85 Tabel 3.10 Matriks subjek data vs aplikasi ............................................................... 87 Tabel 4.1 Tabel MsTradingMembers.........................................................................92 Tabel 4.2 Tabel MsCustomer.....................................................................................93 Tabel 4.3 Tabel MsContract ......................................................................................93 Tabel 4.4 Tabel TrHistTrade......................................................................................94 Tabel 4.5 Tabel TrHistMarketSummary....................................................................95 Tabel 4.6 Tabel Time .................................................................................................96 Tabel 4.7 Subjek data dan nama tabel hasil tranformasi............................................100 xvii

Tabel 4.8 Tabel FactTrade .........................................................................................101 Tabel 4.9 Sumber data Tabel FactTrade ....................................................................102 Tabel 4.10 Tabel TempFactTrade..............................................................................103 Tabel 4.11 Sumber data Tabel TempFactTrade.........................................................104 Tabel 4.12 Tabel FactMarket .....................................................................................105 Tabel 4.13 Sumber data Tabel FactMarket................................................................106 Tabel 4.14 Tabel DimTime........................................................................................106 Tabel 4.15 Sumber data Tabel DimTime...................................................................107 Tabel 4.16 Tabel DimBuyerMember .........................................................................108 Tabel 4.17 Sumber data Tabel DimBuyerMember....................................................108 Tabel 4.18 Tabel DimBuyerCustomer .......................................................................109 Tabel 4.19 Sumber data Tabel DimBuyerCustomer..................................................110 Tabel 4.20 Tabel DimSellerMember .........................................................................110 Tabel 4.21 Sumber data Tabel DimSellerMember ....................................................111 Tabel 4.22 Tabel DimSellerCustomer .......................................................................112 Tabel 4.23 Sumber data Tabel DimSellerCustomer ..................................................112 Tabel 4.24 Tabel DimContract...................................................................................113 Tabel 4.25 Sumber data Tabel DimContract .............................................................113 Tabel 4.26 Tabel Analisis Pertumbuhan Data ...........................................................172

xviii

DAFTAR GAMBAR

Gambar 2.1 Data yang berorientasi subyek ...............................................................12 Gambar 2.2 Masalah mengenai integrasi...................................................................14 Gambar 2.3 Masalah mengenai nonvolatility ............................................................15 Gambar 2.4 Masalah mengenai time variancy...........................................................16 Gambar 2.5 Granularity .............................................................................................17 Gambar 2.6 Struktur dari data warehouse..................................................................18 Gambar 2.7 Bentuk data warehouse fungsional ........................................................21 Gambar 2.8 Bentuk data warehouse terpusat.............................................................22 Gambar 2.9 Bentuk data warehouse terdistribusi ......................................................23 Gambar 2.10 Arsitektur data warehouse....................................................................28 Gambar 2.11 Skema Bintang Sederhana ...................................................................31 Gambar 2.12 Skema Bintang dengan banyak Tabel Fakta ........................................32 Gambar 2.13 Skema Bintang majemuk .....................................................................33 Gambar 2.14 Skema Snowflake.................................................................................34 Gambar 3.1 Struktur Organisasi PT. Bursa Berjangka Jakarta..................................55 Gambar 4.1 Arsitektur data warehouse terpusat ........................................................91 Gambar 4.2 Form Awal Aplikasi...............................................................................114 Gambar 4.3 Form Login ............................................................................................115 Gambar 4.4 Pesan kesalahan Form Login jika ada yang tidak diisi ..........................115 Gambar 4.5 Pesan kesalahan Form Login jika salah mengisi....................................116 Gambar 4.6 Pesan saat Login berhasil .......................................................................116 Gambar 4.7 Menu Utama Aplikasi ............................................................................116 xix

Gambar 4.8 Pesan Exit...............................................................................................117 Gambar 4.9 Submenu dari menu File bila Position adalah “Employee” ...................118 Gambar 4.10 Submenu dari menu File bila Position adalah “Manager” ...................119 Gambar 4.11 Form Add User.....................................................................................119 Gambar 4.12 Pesan kesalahan Form Add User bila ada yang tidak diisi ..................120 Gambar 4.13 Pesan kesalahan jika Password dan Re-type Password tidak sama .....120 Gambar 4.14 Pesan kesalahan jika Password dan Re-type Password tidak 6 karakter ...............................................................................................................................120 Gambar 4.15 Konfirmasi Form Add User .................................................................121 Gambar 4.16 Pesan penambahan pengguna telah berhasil ........................................121 Gambar 4.17 Pesan kesalahan Form Add User bila UserName sudah dipakai orang lain..............................................................................................................................121 Gambar 4.18 Form Change Password .......................................................................122 Gambar 4.19 Pesan kesalahan jika Password dan Re-type Password tidak diisi.......123 Gambar 4.20 Konfirmasi penggantian Password.......................................................123 Gambar 4.21 Pesan penggantian password telah berhasil .........................................123 Gambar 4.22 Form Delete User .................................................................................124 Gambar 4.23 Pesan kesalahan Form Delete User jika UserName tidak dipilih ........125 Gambar 4.24 Pesan kesalahan Form Delete User jika UserName sedang dipakai ....125 Gambar 4.25 Konfirmasi Form Delete User..............................................................125 Gambar 4.26 Pesan penghapusan pengguna telah berhasil........................................126 Gambar 4.27 Pesan jendela Log Out .........................................................................126 Gambar 4.28 Submenu dari menu File setelah Log Out............................................127 Gambar 4.29 Submenu dari Menu View ...................................................................128 xx

Gambar 4.30 Pesan kesalahan bila field tidak dipilih................................................129 Gambar 4.31 Pesan kesalahan jika Contract Name tidak dipilih...............................131 Gambar 4.32 Form Graph Trade (Contract) sebelum field dipilih ............................132 Gambar 4.33 Form Graph Trade (Customer) sebelum ketiga field dipilih................133 Gambar 4.34 Form Graph Trade (Member) sebelum kedua field dipilih..................134 Gambar 4.35 Form Graph Trade (Price) sebelum contract name dipilih...................135 Gambar 4.36 Form Graph Market (Total Daily Open Interest).................................137 Gambar 4.37 Form Graph Market (PrevSettPrice) ....................................................139 Gambar 4.38 Anak dari Submenu Pivot Table ..........................................................140 Gambar 4.39 Form Pivot Table Fact Trade in Dynamic Cube 3.0 (Total Transaction) ............................................................................................................................141 Gambar 4.40 Form Pivot Table Fact Market in Dynamic Cube 3.0 (Total Daily Open Interest).............................................................................................................145 Gambar 4.41 Form Pivot Table in Cube Browser Analysis Manager (Trade) ..........147 Gambar 4.42 Form Pivot Table in Cube Browser Analysis Manager (Market) ........148 Gambar 4.43 Pesan kesalahan jika checkbox tidak dipilih........................................149 Gambar 4.44 Pesan bahwa query berhasil .................................................................150 Gambar 4.45 Form Query Trade................................................................................151 Gambar 4.46 Form Query Market .............................................................................153 Gambar 4.47 Form Star Schema (Trade) ...................................................................154 Gambar 4.48 Form Star Schema (Market).................................................................155 Gambar 4.49 Form Search .........................................................................................156 Gambar 4.50 Pesan kesalahan jika search key tidak diisi..........................................156 Gambar 4.51 Pesan kesalahan jika table tidak dipilih ...............................................157 xxi

Gambar 4.52 Pesan kesalahan jika fields tidak dipilih ..............................................157 Gambar 4.53 Pesan apabila data yang dicari tidak ada..............................................157 Gambar 4.54 Submenu dari menu Print.....................................................................158 Gambar 4.55 Form Report Trade...............................................................................158 Gambar 4.56 Pesan kesalahan jika bulan tidak dipilih ..............................................159 Gambar 4.57 Pesan kesalahan jika tahun tidak dipilih ..............................................159 Gambar 4.58 Trade Report.........................................................................................160 Gambar 4.59 Form Report Market.............................................................................161 Gambar 4.60 Market Report ......................................................................................162 Gambar 4.61 Submenu dari menu About ..................................................................163 Gambar 4.62 Form About Application ......................................................................164 Gambar 4.63 Form About Us.....................................................................................164 Gambar 4.64 Skema Bintang Fact Trade PT. Bursa Berjangka Jakarta ....................167 Gambar 4.65 Skema Bintang Fact Market PT. Bursa Berjangka Jakarta ..................168 Gambar 4.66 Skema Bintang Gabungan PT. Bursa Berjangka Jakarta .....................168

xxii

DAFTAR LAMPIRAN

Gambar L.1 Form Awal Aplikasi ..............................................................................L1 Gambar L.2 Form Login ............................................................................................L1 Gambar L.3 Pesan kesalahan Form Login jika ada yang tidak diisi..........................L2 Gambar L.4 Pesan kesalahan Form Login jika salah mengisi ...................................L2 Gambar L.5 Pesan saat Login berhasil ......................................................................L2 Gambar L.6 Pesan Exit ..............................................................................................L2 Gambar L.7 Menu Utama Aplikasi............................................................................L3 Gambar L.8 Submenu dari menu File bila Position adalah “Employee”...................L3 Gambar L.9 Submenu dari menu File bila Position adalah “Manager”.....................L4 Gambar L.10 Form Add User ....................................................................................L4 Gambar L.11 Pesan kesalahan Form Add User bila ada yang tidak diisi..................L5 Gambar L.12 Pesan kesalahan jika Password dan Re-type Password tidak sama.....L5 Gambar L.13 Pesan kesalahan jika Password dan Re-type Password tidak 6 karakter ..........................................................................................................................L5 Gambar L.14 Konfirmasi Form Add User .................................................................L5 Gambar L.15 Pesan penambahan pengguna telah berhasil........................................L6 Gambar L.16 Pesan kesalahan Form Add User bila UserName sudah dipakai orang lain..............................................................................................................................L6 Gambar L.17 Form Change Password .......................................................................L6 Gambar L.18 Pesan kesalahan jika Password dan Re-type Password tidak diisi ......L6 Gambar L.19 Konfirmasi penggantian password ......................................................L7 Gambar L.20 Pesan penggantian password telah berhasil.........................................L7 xxiii

Gambar L.21 Form Delete User.................................................................................L7 Gambar L.22 Pesan kesalahan Form Delete User jika UserName tidak dipilih ........L7 Gambar L.23 Pesan kesalahan Form Delete User jika UserName sedang dipakai....L8 Gambar L.24 Konfirmasi Form Delete User .............................................................L8 Gambar L.25 Pesan penghapusan pengguna telah berhasil .......................................L8 Gambar L.26 Pesan jendela Log Out .........................................................................L8 Gambar L.27 Submenu dari menu File setelah Log Out ...........................................L9 Gambar L.28 Submenu dari Menu View ...................................................................L9 Gambar L.29 Form Graph Trade (Contract) setelah field dipilih dengan tipe bar ....L10 Gambar L.30 Form Graph Trade (Contract) setelah field dipilih dengan tipe pie.....L10 Gambar L.31 Form Graph Trade (Contract) setelah field dipilih dengan tipe step ...L11 Gambar L.32 Form Graph Trade (Customer) setelah ketiga field dipilih dengan tipe bar .......................................................................................................................L11 Gambar L.33 Form Graph Trade (Customer) setelah ketiga field dipilih dengan tipe 2dLine .................................................................................................................L12 Gambar L.34 Form Graph Trade (Customer) setelah ketiga field dipilih dengan tipe 3dLine .................................................................................................................L12 Gambar L.35 Form Graph Trade (Member) setelah kedua field dipilih dengan tipe bar ..............................................................................................................................L13 Gambar L.36 Form Graph Trade (Member) setelah kedua field dipilih dengan tipe line..............................................................................................................................L13 Gambar L.37 Form Graph Trade (Member) setelah kedua field dipilih dengan tipe 3dBar..........................................................................................................................L14 Gambar L.38 Form Graph Trade (Price) setelah contract name dipilih dengan tipe xxiv

bar ..............................................................................................................................L14 Gambar L.39 Form Graph Trade (Price) setelah contract name dipilih dengan tipe line..............................................................................................................................L15 Gambar L.40 Pesan kesalahan bila field tidak dipilih ...............................................L15 Gambar L.41 Pesan kesalahan jika contract name tidak dipilih ................................L15 Gambar L.42 Form Graph Market (Total Daily Open Interest) dengan tipe bar.......L16 Gambar L.43 Form Graph Market (Total Daily Open Interest) dengan tipe pie .......L16 Gambar L.44 Form Graph Market (Total Daily Open Interest) dengan tipe step .....L17 Gambar L.45 Form Graph Market (Prev Sett Price) setelah contract name dipilih dengan tipe bar ...........................................................................................................L17 Gambar L.46 Form Graph Market (Prev Sett Price) setelah contract name dipilih dengan tipe line ..........................................................................................................L18 Gambar L.47 Anak dari Submenu Pivot Table..........................................................L18 Gambar L.48 Form Pivot Table Fact Trade in Dynamic Cube 3.0 (Total Transaction) ............................................................................................................................L19 Gambar L.49 Form Pivot Table Fact Market in Dynamic Cube 3.0 (Total Daily Open Interest).............................................................................................................L19 Gambar L.50 Form Pivot Table in Cube Browser Analysis Manager (Trade)..........L20 Gambar L.51 Form Pivot Table in Cube Browser Analysis Manager (Market)........L20 Gambar L.52 Form Query Trade ...............................................................................L21 Gambar L.53 Pesan kesalahan jika checkbox tidak dipilih .......................................L21 Gambar L.54 Pesan bahwa query berhasil.................................................................L21 Gambar L.55 Form Query Market .............................................................................L22 Gambar L.56 Form Star Schema (Trade)...................................................................L22 xxv

Gambar L.57 Form Star Schema (Market) ................................................................L23 Gambar L.58 Form Search.........................................................................................L23 Gambar L.59 Pesan kesalahan jika search key tidak diisi .........................................L24 Gambar L.60 Pesan kesalahan jika table tidak dipilih ...............................................L24 Gambar L.61 Pesan kesalahan jika fields tidak dipilih..............................................L24 Gambar L.62 Pesan apabila data yang dicari tidak ada .............................................L24 Gambar L.63 Submenu dari menu Print ....................................................................L25 Gambar L.64 Form Report Trade ..............................................................................L25 Gambar L.65 Pesan kesalahan jika bulan tidak dipilih..............................................L25 Gambar L.66 Pesan kesalahan jika tahun tidak dipilih..............................................L26 Gambar L.67 Trade Report ........................................................................................L26 Gambar L.68 Form Report Market ............................................................................L27 Gambar L.69 Market Report......................................................................................L27 Gambar L.70 Submenu dari menu About ..................................................................L28 Gambar L.71 Form About Application......................................................................L28 Gambar L.72 Form About Us ....................................................................................L29

xxvi