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

Michael Brohl Fri, 24 May 2019 02:56:29 -0700

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) <[email protected]>
An:     [email protected]



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

smime.p7s
Description: S/MIME Cryptographic Signature

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

Reply via email to