Soal No. 8 (OLAP)

Tabel Analisis (OLAP) :

MEASURE :

--------------

Penerimaan Barang :

- Jumlah Penerimaan = sum(qty)
 - Total Penerimaan = sum(qty*BiayaPenerimaan)

Pengiriman Barang :

- Jumlah Pengiriman = sum(qty)

- Total Pengiriman = sum (qty *BiayaKirim)

DIMENSI

--------------

DimensiWaktu =
- WaktuID,
- Tgl,
- hari,
- bulan,
- tahun

DimensiEmployee =
- EmployeeID,
- EmployeeName,
- EmployeeAddress,
- EmployeePhone,
- Branch,
- Position

DimensiBranch =
- BranchID,
- BranchAddress,
- BranchPhone,
- City

DimensiReciever =
- RecieverID,
- RecieverName,
- RecieverAddress,
- ZipCode,
- RecieverPhone, City

DimensiGoods =
- GoodsID,
- GoodsType,
- Weight

DimensiShipper =
- ShipperID,
- ShipperName,
- ShipperAddress,
- ShipperPhone,
- ZipCode

DimensiShipping =
- ShippingID,
- Price,
- Reciever,
- Shipper,
- Goods,
- ShippingType

DimensiCity =
- CityID,
- CityName,
- Province,
- Country

DimensiReport =
- ReportID,
- Status

FAKTA

-----------

FaktaPenerimaan =
- PenerimaanID,
- EmployeeID,
- ShippingID,
- ReportID,
- BranchID,                             
- JumlahPenerimaan,
- TotalPenerimaan

FaktaPengiriman =
- PengirimanID,
- EmployeeID,
- ShippingID,
- BranchID,
- JumlahPengiriman,
- TotalPengiriman