A data warehouse solution system comprises a metadata model, a user
interface and an engine. The metadata model has an information needs
model including metadata regarding information needs for building reports
by users, and a data information model including metadata describing data
that is available for building reports. The user interface has a customer
user interface for presenting the information needs model to the users
for report generation, and a modeling user interface for presenting the
data information model to the users for manipulating data warehouse
objects. The engine has a report management service unit for providing
report management service using the information needs model, and a data
management service unit for providing data management service including
generation of a data warehouse using the data information model.