OLAP

Measure
=======

Jumlah Penjualan = sum(Qty)
Total biaya penjualan = sum(Qty*HargaJual)

Jumlah Pembelian = sum(Qty)
Total biaya pembelian = sum(Qty*HargaBeli)

Jumlah Penyewaan = sum(Qty)
Total biaya penyewaan= sum(Qty*HargaSewa)

Jumlah Reparasi = sum(Qty)
Total biaya Reparasi = sum(Qty*HargaReparasi)

Fakta
=====

Fakta Penjualan
---------------
PenjualanID
WaktuID
BranchID
EmployeeID
CustomerID
ElectronicID
ElectronicTypeID
SalesQuantity
SalesTotal


Fakta Pembelian
---------------
PembelianID
WaktuID
BranchID
PositionID
SupplierID
ElectronicID
ElectronicTypeID
PurchaseQuantity
PurchaseTotal

Fakta Penyewaan
---------------
PenyewaanID
WaktuID
BranchID
EmployeeID
CustomerID
ElectronicID
RentQuantity
RentTotal

Fakta Reparasi
---------------
ReparasiID
WaktuID
BranchID
SparepartID
CustomerID
ReparationQuantity
ReparationTotal


Dimensi
=======

Dimensi Waktu
-------------
WaktuID
Tgl
Hari
Bulan
Kuartal
Tahun

Dimensi Employee
----------------
EmployeeID
EmployeeCode
Gender
Position

Dimensi Position
----------------
PositionID
PositionCode
Position

Dimensi Electronic
------------------
ElectronicID
ElectronicCode
ElectronicType
ElectronicName
SalesPrice
PurchasePrice
RentPrice
ReparationPrice

Dimensi ElectronicType
----------------
ElectronicTypeID
ElectronicCode
ElectronicTypeName

Dimensi Supplier
----------------
SupplierID
SupplierCode
SupplierName
SupplierPhone

Dimensi Sparepart
-----------------
SparepartID
SparepartCode
SparepartName
SparepartPrice

Dimensi Customer
----------------
CustomerID
CustomerCode
CustomerGender
CustomerPhone

Dimensi Branch
--------------
BranchID
BranchCode
BranchName
BranchPhone