Home
Data warehousingIn addition to designing and implementing HCL OneDB™ dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries.
Dimensional databasesThe HCL OneDB™ Data Warehouse Guide provides information to help you design, implement, and manage dimensional databases, and describes the tools that you can use to create data warehouses and optimize your data warehouse queries.
Design a dimensional data modelTo build a dimensional database, you start by designing a dimensional data model for your business.
Building a dimensional data model
A business process A business process is an important operation in your organization that some legacy system supports. You collect data from this system to use in your dimensional database.

A business process

A business process is an important operation in your organization that some legacy system supports. You collect data from this system to use in your dimensional database.

The business process identifies what end users are doing with their data, where the data comes from, and how to transform that data to make it meaningful. The information can come from many sources, including finance, sales analysis, market analysis, customer profiles. The following list shows different business processes you might use to determine what data to include in your dimensional database:

Sales
Shipments
Inventory
Orders
Invoices

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.