Fwd: [CONF] OFBiz Project Open Wiki > Business Intelligence

[Michael Brohl-3]

Wouldn't it be better to first discuss/decide if these changes are going
into the codebase and *then* document them here?

Regards,

Michael Brohl

ecomify GmbH - www.ecomify.de



-------- Weitergeleitete Nachricht --------
Betreff: [CONF] OFBiz Project Open Wiki > Business Intelligence
Datum: Fri, 24 May 2019 09:50:00 +0000 (UTC)
Von: Pierre Smits (Confluence) <[hidden email]>
An: [hidden email]



Message Title
There's *1 new edit* on this page
page icon
<https://cwiki.apache.org/confluence/display/OFBIZ/Business+Intelligence?src=mail&src.mail.product=confluence-server&src.mail.timestamp=1558691400731&src.mail.notification=com.atlassian.confluence.plugins.confluence-notifications-batch-plugin%3Abatching-notification&src.mail.recipient=8aa980874e36a1eb014e36a287620290&src.mail.action=view>


        Business Intelligence
<https://cwiki.apache.org/confluence/display/OFBIZ/Business+Intelligence?src=mail&src.mail.product=confluence-server&src.mail.timestamp=1558691400731&src.mail.notification=com.atlassian.confluence.plugins.confluence-notifications-batch-plugin%3Abatching-notification&src.mail.recipient=8aa980874e36a1eb014e36a287620290&src.mail.action=view>


       
Pierre Smits edited this page


       

Here's the version comment


       
Pierre Smits edited at 09:49 AM
<https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=115511393>



       
Adding the TimeEntryFact to the Project domain


       

Here's what 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 its implementation through the BI component are
based on the book 'Data Warehouse Toolkit
</confluence/pages/viewpage.action?pageId=7766038>' by Ralph Kimball and
Margy Ross.


       
Table of Contents


    Facts and Dimensions

Fact tables (aka facts
</confluence/pages/viewpage.action?pageId=115511402>) stores the
performance measurements resulting from the organisation's business
process events. Dimension tables (aka dimensions
</confluence/pages/viewpage.action?pageId=115511399>) 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 </confluence/pages/viewpage.action?pageId=115511402>/

       

/Dimension </confluence/pages/viewpage.action?pageId=115511399>/

       

Fact-field

       

Fact-alias

       

SalesInvoiceFact </confluence/pages/viewpage.action?pageId=115511646>

       

SalesOrderFact </confluence/pages/viewpage.action?pageId=115511644>

Account </confluence/pages/viewpage.action?pageId=115511663>

       

accountDimId

       

account

       

Y

       

Y

Brand </confluence/pages/viewpage.action?pageId=115511586>

       

brandDimId

       

brand

       

Y

       

Y

Carrier </confluence/pages/viewpage.action?pageId=115511596>

       

carrierDimId

       

carrier

       
       

Catalog </confluence/pages/viewpage.action?pageId=115511609>

       

catalogDimId

       

catalog

       
       

Customer </confluence/pages/viewpage.action?pageId=115511598>

       

customerDimId

       

customer

       

Y

       

Y

Country </confluence/pages/viewpage.action?pageId=115511607>

       

countryDimId

       

country

       
       

Currency </confluence/pages/viewpage.action?pageId=115511605>

       

currencyDimId

       

currency

       

Y

       

Y

Date </confluence/pages/viewpage.action?pageId=115511603>

       

dateDimId

       

date

       

Y

       

Y

Employee </confluence/pages/viewpage.action?pageId=115511601>

       

employeeDimId

       

employee

       
       

Facility </confluence/pages/viewpage.action?pageId=115511611>

       

facilityDimId

       

facility

       
       

Manager

       

managerDimId

       

manager

       
       

Organisation </confluence/pages/viewpage.action?pageId=115511676>

       

organisationDimId

       

organisation

       

Y

       

Y

PaymentMethod

       

paymentMethodDimId

       

payMethod

       
       

Product </confluence/pages/viewpage.action?pageId=115511674>

       

productDimId

       

product

       

Y

       

Y

ProductCategory </confluence/pages/viewpage.action?pageId=115511618>

       

productCategoryDimId

       

category

       
       

Project

       

projectDimId

       

project

       
       

SalesChannel </confluence/pages/viewpage.action?pageId=115511625>

       

channelDimId

       

channel

       

Y

       

Y

SalesPromo

       

promoDimId

       

promo

       
       

Y

SalesRep

       

salesrepDimId

       

rep

       

Y

       

Y

Store </confluence/pages/viewpage.action?pageId=115511627>

       

storeDimId

       

store

       

Y

       

Y

Supplier </confluence/pages/viewpage.action?pageId=115511629>

       

supplierDimId

       

supplier

       
       

Time

       

timeDimId

       

time

       

Y

       

TimeEntry

       

timeEntryDimId

       

timeEntry

       
       


      Procurement/Purchase Domain



       
       
       

/Facts/

       

/Dimension/

       

Fact-field

       

Fact-alias

       

PurchaseInvoiceFact

       

PurchaseOrderFact

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
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 </confluence/pages/viewpage.action?pageId=115511402>/
/Dimension </confluence/pages/viewpage.action?pageId=115511399>/
Fact-field Fact-alias InventoryItemFact
</confluence/pages/viewpage.action?pageId=115511648>
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
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
Store storeDimId store
Supplier supplierDimId supplier
Time timeDimId time Y
TimeEntry timeEntryDimId timeEntry


      Project Domain



       
       
       

/Facts/

/Dimension/

       

Fact-field

       

Fact-alias

       

tbdTimeEntryFact

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

       
ProjectTask taskDimId task Y

Time

       

timeDimId

       

time

       

TimeEntry

       

timeEntryDimId

       

timeEntry

       

Y


      Accounting Domain



       
       
        /Facts/
/Dimension/ Fact-field Fact-alias tbd
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


    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


Go to page history
<https://cwiki.apache.org/confluence/pages/viewpreviousversions.action?pageId=115511393&src=mail&src.mail.product=confluence-server&src.mail.timestamp=1558691400731&src.mail.notification=com.atlassian.confluence.plugins.confluence-notifications-batch-plugin%3Abatching-notification&src.mail.recipient=8aa980874e36a1eb014e36a287620290>



View page
<https://cwiki.apache.org/confluence/display/OFBIZ/Business+Intelligence?src=mail&src.mail.product=confluence-server&src.mail.timestamp=1558691400731&src.mail.notification=com.atlassian.confluence.plugins.confluence-notifications-batch-plugin%3Abatching-notification&src.mail.recipient=8aa980874e36a1eb014e36a287620290&src.mail.action=view>


Stop watching space
<https://cwiki.apache.org/confluence/users/removespacenotification.action?spaceKey=OFBIZ&src=mail&src.mail.product=confluence-server&src.mail.timestamp=1558691400731&src.mail.notification=com.atlassian.confluence.plugins.confluence-notifications-batch-plugin%3Abatching-notification&src.mail.recipient=8aa980874e36a1eb014e36a287620290&src.mail.action=stop-watching&jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOiJ4c3JmOjhhYTk4MDg3NGUzNmExZWIwMTRlMzZhMjg3NjIwMjkwIiwicXNoIjoiODQ5ZjExNGQ1YTUxZjJhMDU3NGJiMzU5NjE3Y2M3YzFiOTAzODVmMzc5YjM3ZDM5MDM4NzgyZTdhZTZjOGNiNCIsImlzcyI6ImNvbmZsdWVuY2Vfbm90aWZpY2F0aW9uc0FSRUgtWFVEMS1QT1FHLUNTQU8iLCJleHAiOjE1NTkyOTYyMDAsImlhdCI6MTU1ODY5MTQwMH0.Hynmj-UrrQKKNEUlw1EEN1Ir5mQuwG_QZcZ6tOZ3glI>
        •

Manage notifications
<https://cwiki.apache.org/confluence/users/editmyemailsettings.action?src=mail&src.mail.product=confluence-server&src.mail.timestamp=1558691400731&src.mail.notification=com.atlassian.confluence.plugins.confluence-notifications-batch-plugin%3Abatching-notification&src.mail.recipient=8aa980874e36a1eb014e36a287620290&src.mail.action=manage>


       
Confluence logo big

This message was sent by Atlassian Confluence 6.15.2