O'Reilly logo

Data Warehousing: Architecture and Implementation by Michelle C. Dy, Michael W. Hawkins, Mark Humphries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix B. Warehouse Designer® User's Manual

Welcome to Warehouse Designer!

WAREHOUSE DESIGNER is a dimensional data warehouse modeling tool that enables users to define data warehouse objects through a graphical user interface. It generates the necessary Structured Query Language Data Definition Language (SQL DDL) scripts for creating a data warehouse or data mart based on definitions specified by the user.

WAREHOUSE DESIGNER is fully compatible with R/OLAPXL®, a Relational Online Analytical Processing tool (also provided with this book) which runs on top of Microsoft Excel for Windows 95. WAREHOUSE DESIGNER automatically creates the warehouse metadata that R/OLAPXL needs to access the data warehouse or data mart.

This Demo Installation is provided ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required