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

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.