Versions Compared

Key

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

Introduction

Star schema tables bring the entities combine the data from the fact dimension tables (aka facts dimensions) and dimension fact tables (aka dimensions) together. facts) to provide the parties in the various domains within the company with information and data to make informed decisions regarding the future of the company, such as:

  • Sales - SalesInvoiceItemSarSchema and SalesOrderItemStarSchema
  • Producement - PurchaseInvoiceItemStarSchema and PurchaseOrderItemStarSchema
  • Manufacturing - AssetUtilisationStarSchema
  • ProjectManagement - ResourceUtilisationStarSchema
  • etc.

In the OFBiz BI components fact star schema tables are structured as view-entities.

See sections below and child pages

Table of Content

Table of Contents

Children

Sorted Children

Related tickets

Jira
serverASF JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
maximumIssues20
jqlQueryproject = OFBIZ AND component in ('bi','birt') AND labels =StarSchema ORDER BY status DESC, key DESC
serverId5aa69414-a9e9-3523-82ec-879b028fb15b