Page History

Introduction

Business Intelligence (BI) comprises the strategies and technologies used by enterprises for the data analysis of business information.

OFBiz collects vast amounts of data from transactions in the various domains. This page (and child pages) intend to explain how OFBiz supports BI.

The OFBiz BI concept (and associated entities) are based on the book 'Data Warehouse Toolkit' by Ralph Kimball and Margy Ross

Facts and Dimensions

Fact tables (aka facts) stores the performance measurements resulting from the organisation's business process events. Dimension tables (aka dimensions) contain the textual contacts associated with a business process measurement event (captured in a fact) and describe the 'who, what, where, when, how and why'.

In the sections below we describe how the facts and dimension per business domain

Sales Domain

Facts

Dimension

Fact-field

Fact-alias

SalesInvoiceFact

SalesOrderFact

JIRA ticket

Account

accountDimId

account

Y

Brand

brandDimId

brand

Y

Jira

server	ASF JIRA
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b
key	OFBIZ-10995

Carrier

carrierDimId

carrier

Jira

server	ASF JIRA
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b
key	OFBIZ-11034

Catalog

catalogDimId

catalog

Jira

server	ASF JIRA
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b
key	OFBIZ-10987

Customer

customerDimId

customer

Y

Jira

server	ASF JIRA
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b
key	OFBIZ-10944

Country

countryDimId

country

Jira

server	ASF JIRA
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b
key	OFBIZ-10954

Currency

currencyDimId

currency

Y

Jira

server	ASF JIRA
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b
key	OFBIZ-10953

Date

dateDimId

date

Y

Jira

server	ASF JIRA
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b
key	OFBIZ-10947

Employee

employeeDimId

employee

Jira

server	ASF JIRA
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b
key	OFBIZ-10997

Facility

facilityDimId

facility

Jira

server	ASF JIRA
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b
key	OFBIZ-10989

Manager

managerDimId

manager

Organisation

organisationDimId

organisation

Y

PaymentMethod

paymentMethodDimId

payMethod

Product

productDimId

product

Y

ProductCategory

productCategoryDimId

Procurement/Purchase Domain

			Facts
Dimension	Fact-field	Fact-alias	PurchaseInvoiceFact	PurchaseOrderFact	JIRA ticket
Account	accountDimId	account
Brand	brandDimId	brand
Carrier	carrierDimId	carrier
Catalog	catalogDimId	catalog
Customer	customerDimId	customer
Country	countryDimId	country
Currency	currencyDimId	currency	Y	Y
Date	dateDimId	date	Y	Y
Employee	employeeDimId	employee
Facility	facilityDimId	facility
Manager	managerDimId	manager
Organisation	organisationDimId	organisation	Y	Y
PaymentMethod	paymentMethodDimId	payMethod
Product	productDimId	product	Y	Y
ProductCategory	productCategoryDimId	category
Project	projectDimId	project	Y	Y
SalesChannel	channelDimId	channel	Y	Y
SalesPromo	promoDimId	promo		Y
SalesRep	salesrepDimId	rep	Y	Y
Store	storeDimId	store	Y	Y
Supplier	supplierDimId	supplier
Time	timeDimId	time	Y
TimeEntry	timeEntryDimId	timeEntry

Human Resources Domain

			Facts
Dimension	Fact-field	Fact-alias	tbd	JIRA ticket
Account	accountDimId	account
Brand	brandDimId	brand
Carrier	carrierDimId	carrier
Catalog	catalogDimId	catalog
Customer	customerDimId	customer
Country	countryDimId	country
Currency	currencyDimId	currency
Date	dateDimId	date	Y
Employee	employeeDimId	employee	Y
Facility	facilityDimId	facility
Manager	managerDimId	manager
Organisation	organisationDimId	organisation	Y
PaymentMethod	paymentMethodDimId	payMethod
Product	productDimId	product
ProductCategory	productCategoryDimId	category
Project	projectDimId	project
SalesChannel	channelDimId	channel
SalesPromo	promoDimId	promo
SalesRep	salesrepDimId	rep	Y
Store	storeDimId	store	Y
Supplier	supplierDimId	supplier
Time	timeDimId	time
TimeEntry	timeEntryDimId	timeEntry	Y

Inventory/Warehousing Domain

			Facts
Dimension	Fact-field	Fact-alias	InventoryItemFact	JIRA ticket
Account	accountDimId	account
Brand	brandDimId	brand
Carrier	carrierDimId	carrier
Catalog	catalogDimId	catalog
Customer	customerDimId	customer
Country	countryDimId	country
Currency	currencyDimId	currency
Date	dateDimId	date	Y
Employee	employeeDimId	employee	Y
Facility	facilityDimId	facility	Y
Manager	managerDimId	manager
Organisation	organisationDimId	organisation	Y
PaymentMethod	paymentMethodDimId	payMethod
Product	productDimId	product
ProductCategory	productCategoryDimId	category
Project	projectDimId	project
SalesChannel	channelDimId	channel
SalesPromo	promoDimId	promo
SalesRep	salesrepDimId	rep	Y
Store	storeDimId	store	Y
Supplier	supplierDimId	supplier
Time	timeDimId	time	Y
TimeEntry	timeEntryDimId	timeEntry

Project

			Facts
Dimension	Fact-field	Fact-alias	tbd	JIRA ticket
Account	accountDimId	account
Brand	brandDimId	brand
Carrier	carrierDimId	carrier
Catalog	catalogDimId	catalog
Customer	customerDimId	customer	Y
Country	countryDimId	country
Currency	currencyDimId	currency
Date	dateDimId	date	Y
Employee	employeeDimId	employee	Y
Facility	facilityDimId	facility
Manager	managerDimId	manager	Y
Organisation	organisationDimId	organisation	Y
PaymentMethod	paymentMethodDimId	payMethod
Product	productDimId	product
ProductCategory	productCategoryDimId	category
Project	projectDimId	project	Y
SalesChannel	channelDimId	channel
SalesPromo	promoDimId	promo
SalesRep	salesrepDimId	rep
Store	storeDimId	store
Supplier	supplierDimId	supplier
Time	timeDimId	time
TimeEntry	timeEntryDimId	timeEntry	Y

Accounting Domain

			Facts
Dimension	Fact-field	Fact-alias	tbd	JIRA ticket
Account	accountDimId	account
Brand	brandDimId	brand
Carrier	carrierDimId	carrier
Catalog	catalogDimId	catalog
Customer	customerDimId	customer
Country	countryDimId	country
Currency	currencyDimId	currency
Date	dateDimId	date	Y
Employee	employeeDimId	employee
Facility	facilityDimId	facility
Manager	managerDimId	manager
Organisation	organisationDimId	organisation	Y
PaymentMethod	paymentMethodDimId	payMethod	Y
Product	productDimId	product
ProductCategory	productCategoryDimId	category
Project	projectDimId	project
SalesChannel	channelDimId	channel
SalesPromo	promoDimId	promo
SalesRep	salesrepDimId	rep
Store	storeDimId	store
Supplier	supplierDimId	supplier
Time	timeDimId	time
TimeEntry	timeEntryDimId	timeEntry

Space shortcuts

Child pages

Versions Compared

Old Version 3

New Version 4

Key

Introduction

Sales Domain

Procurement/Purchase Domain

Human Resources Domain

Inventory/Warehousing Domain

Project