Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
DimensionFact-fieldFact-aliasSalesInvoiceFactSalesOrderFact
JIRA ticket
AccountaccountDimIdaccountYY
BrandbrandDimIdbrandYY
JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10995
CarriercarrierDimIdcarrier
JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-11034


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


CustomercustomerDimIdcustomerYY
JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10944
CountrycountryDimIdcountry
JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkey
OFBIZ-10954


CurrencycurrencyDimIdcurrencyYY
JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkey
OFBIZ-10953
DatedateDimIddateYY
JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15b
keyOFBIZ-10947
EmployeeemployeeDimIdemployee
JiraserverASF JIRAserverId
5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10997


FacilityfacilityDimIdfacility
JiraserverASF JIRAserverId
5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10989


ManagermanagerDimIdmanager

OrganisationorganisationDimIdorganisationYY
PaymentMethodpaymentMethodDimIdpayMethod

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


ProjectprojectDimIdproject

SalesChannelchannelDimIdchannelYY
JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10991
SalesPromopromoDimIdpromo
Y
SalesRepsalesrepDimIdrepYY
StorestoreDimIdstoreYY
JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10986
SuppliersupplierDimIdsupplier
JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10996


TimetimeDimIdtimeY
JiraserverASF JIRAserverId5aa69414-a9e9-3523-82ec-879b028fb15bkeyOFBIZ-10998

TimeEntrytimeEntryDimIdtimeEntry


Procurement/Purchase Domain




Facts
DimensionFact-fieldFact-aliasPurchaseInvoiceFactPurchaseOrderFact
JIRA ticket
AccountaccountDimIdaccount

BrandbrandDimIdbrand

CarriercarrierDimIdcarrier

CatalogcatalogDimIdcatalog

CustomercustomerDimIdcustomer

CountrycountryDimIdcountry

CurrencycurrencyDimIdcurrencyYY
DatedateDimIddateYY
EmployeeemployeeDimIdemployee

FacilityfacilityDimIdfacility

ManagermanagerDimIdmanager

OrganisationorganisationDimIdorganisationYY
PaymentMethodpaymentMethodDimIdpayMethod

ProductproductDimIdproductYY
ProductCategoryproductCategoryDimIdcategory

ProjectprojectDimIdprojectYY
SalesChannelchannelDimIdchannelYY
SalesPromopromoDimIdpromo
Y
SalesRepsalesrepDimIdrepYY
StorestoreDimIdstoreYY
SuppliersupplierDimIdsupplier

TimetimeDimIdtimeY
TimeEntrytimeEntryDimIdtimeEntry


Human Resources Domain




Facts
DimensionFact-fieldFact-aliastbd
JIRA ticket
AccountaccountDimIdaccount
BrandbrandDimIdbrand
CarriercarrierDimIdcarrier
CatalogcatalogDimIdcatalog
CustomercustomerDimIdcustomer
CountrycountryDimIdcountry
CurrencycurrencyDimIdcurrency
DatedateDimIddateY
EmployeeemployeeDimIdemployeeY
FacilityfacilityDimIdfacility
ManagermanagerDimIdmanager
OrganisationorganisationDimIdorganisationY
PaymentMethodpaymentMethodDimIdpayMethod
ProductproductDimIdproduct
ProductCategoryproductCategoryDimIdcategory
ProjectprojectDimIdproject
SalesChannelchannelDimIdchannel
SalesPromopromoDimIdpromo
SalesRepsalesrepDimIdrepY
StorestoreDimIdstoreY
SuppliersupplierDimIdsupplier
TimetimeDimIdtime
TimeEntrytimeEntryDimIdtimeEntryY


Inventory/Warehousing Domain




Facts
DimensionFact-fieldFact-aliasInventoryItemFact
JIRA ticket
AccountaccountDimIdaccount
BrandbrandDimIdbrand
CarriercarrierDimIdcarrier
CatalogcatalogDimIdcatalog
CustomercustomerDimIdcustomer
CountrycountryDimIdcountry
CurrencycurrencyDimIdcurrency
DatedateDimIddateY
EmployeeemployeeDimIdemployeeY
FacilityfacilityDimIdfacilityY
ManagermanagerDimIdmanager
OrganisationorganisationDimIdorganisationY
PaymentMethodpaymentMethodDimIdpayMethod
ProductproductDimIdproduct
ProductCategoryproductCategoryDimIdcategory
ProjectprojectDimIdproject
SalesChannelchannelDimIdchannel
SalesPromopromoDimIdpromo
SalesRepsalesrepDimIdrepY
StorestoreDimIdstoreY
SuppliersupplierDimIdsupplier
TimetimeDimIdtimeY
TimeEntrytimeEntryDimIdtimeEntry


Project




Facts
DimensionFact-fieldFact-aliastbd
JIRA ticket
AccountaccountDimIdaccount
BrandbrandDimIdbrand
CarriercarrierDimIdcarrier
CatalogcatalogDimIdcatalog
CustomercustomerDimIdcustomerY
CountrycountryDimIdcountry
CurrencycurrencyDimIdcurrency
DatedateDimIddateY
EmployeeemployeeDimIdemployeeY
FacilityfacilityDimIdfacility
ManagermanagerDimIdmanagerY
OrganisationorganisationDimIdorganisationY
PaymentMethodpaymentMethodDimIdpayMethod
ProductproductDimIdproduct
ProductCategoryproductCategoryDimIdcategory
ProjectprojectDimIdprojectY
SalesChannelchannelDimIdchannel
SalesPromopromoDimIdpromo
SalesRepsalesrepDimIdrep
StorestoreDimIdstore
SuppliersupplierDimIdsupplier
TimetimeDimIdtime
TimeEntrytimeEntryDimIdtimeEntryY


Accounting Domain




Facts
DimensionFact-fieldFact-aliastbd
JIRA ticket
AccountaccountDimIdaccount
BrandbrandDimIdbrand
CarriercarrierDimIdcarrier
CatalogcatalogDimIdcatalog
CustomercustomerDimIdcustomer
CountrycountryDimIdcountry
CurrencycurrencyDimIdcurrency
DatedateDimIddateY
EmployeeemployeeDimIdemployee
FacilityfacilityDimIdfacility
ManagermanagerDimIdmanager
OrganisationorganisationDimIdorganisationY
PaymentMethodpaymentMethodDimIdpayMethodY
ProductproductDimIdproduct
ProductCategoryproductCategoryDimIdcategory
ProjectprojectDimIdproject
SalesChannelchannelDimIdchannel
SalesPromopromoDimIdpromo
SalesRepsalesrepDimIdrep
StorestoreDimIdstore
SuppliersupplierDimIdsupplier
TimetimeDimIdtime
TimeEntrytimeEntryDimIdtimeEntry