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
