Page History

Introduction

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

BI technologies can handle large amounts of structured and sometimes unstructured data to help identify, develop and otherwise create new strategic business opportunities. They aim to allow for the easy interpretation of these big data. Identifying new opportunities and implementing an effective strategy based on insights can provide businesses with a competitive market advantage and long-term stability.

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

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

For more information on Business Intelligence have a look at: https://en.wikipedia.org/wiki/Business_intelligence

Table of Content

Table of Contents

Children

Sorted Children

Facts and Dimensions

Fact tables (aka facts)

stores

store the performance measurements resulting from the organisation's business process events. Dimension tables (aka dimensions) contain the textual

contacts

context 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

	AssetUtilisation
Asset	assetDimId	asset			Y
Account	accountDimId	account	Y	Y	Y
Brand	brandDimId	brand	Y	Y

JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkey

OFBIZ-10995


Carrier	carrierDimId	carrier

JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-11034


Catalog	catalogDimId	catalog

JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10987


Customer	customerDimId	customer	Y	Y

JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10944

Y
Country	countryDimId	country

JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10954


Currency	currencyDimId	currency	Y	Y

JiraserverASF JIRAserverId

5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10953


Date	dateDimId	date	Y	Y

JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10947

Y
Employee	employeeDimId	employee

JiraserverASF JIRAserverId

5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10997


Facility	facilityDimId	facility

JiraserverASF JIRAserverId

5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10989


Manager	managerDimId	manager
Organisation	organisationDimId	organisation	Y	Y	Y
PaymentMethod	paymentMethodDimId	payMethod
PosTerminal	posTerminalDimId	posTerminal
Product	productDimId	product	Y	Y
ProductCategory	productCategoryDimId	category

JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10988


Project	projectDimId	project
SalesChannel	channelDimId	channel	Y	Y

JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10991


SalesPromo	promoDimId	promo	Y	Y
SalesRep	salesrepDimId	rep	Y	Y
Store	storeDimId	store	Y	Y

JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10986


Supplier	supplierDimId	supplier

JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkey

OFBIZ-10996


Time	timeDimId	time	Y

Jira

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

TimeEntrytimeEntryDimIdtimeEntry

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	Y	Y
Time	timeDimId	time	Y

TimeEntrytimeEntryDimIdtimeEntry

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

TimeEntrytimeEntryDimIdtimeEntryY

Inventory/Warehousing Domain

			Facts
Dimension	Fact-field	Fact-alias	InventoryItemFact

JIRA ticket


Account	accountDimId	account
Brand	brandDimId	brand
Carrier	carrierDimId	carrier	Y
Catalog	catalogDimId	catalog
Customer	customerDimId	customer
Country	countryDimId	country
Currency	currencyDimId	currency	Y
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	Y
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

TimeEntrytimeEntryDimIdtimeEntry

Project Domain

			Facts
Dimension	Fact-field	Fact-alias

tbd

TimeEntry

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
ProjectTask	taskDimId	task	Y
SalesChannel	channelDimId	channel
SalesPromo	promoDimId	promo
SalesRep	salesrepDimId	rep
Store	storeDimId	store
Supplier	supplierDimId	supplier
Time	timeDimId	time

TimeEntrytimeEntryDimIdtimeEntryY

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

TimeEntrytimeEntryDimIdtimeEntry

Manufacturing Domain

			Facts
Dimension	Fact-field	Fact-alias	AssetUtilisation
Asset	assetDimId	asset

Related tickets

Open

Jira

server	ASF JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
maximumIssues	20
jqlQuery	project = OFBIZ AND component in (bi, birt) AND status not in (closed, done) ORDER BY status DESC, key DESC
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b

Closed

Jira

server	ASF JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
maximumIssues	20
jqlQuery	project = OFBIZ AND component in (bi, birt) AND status in (closed, done) ORDER BY status DESC, key DESC
serverId	5aa69414-a9e9-3523-82ec-879b028fb15b

Space shortcuts

Child pages

Versions Compared

Old Version 4

New Version Current

Key

Introduction

Facts and Dimensions

Sales Domain

Procurement/Purchase Domain

Human Resources Domain

Inventory/Warehousing Domain

Project Domain

Accounting Domain

Manufacturing Domain

Related tickets

Open

Closed