In view of the problem that current business-oriented water information management sys-tem obtain difficultly hidden information problem，the hydraulic engineering information management system was design based on data warehouse and OLAP technology. The Java served as the development language，SQL Server 2005 as back-end database，and the SQL Server data warehouse tools was used to build the data warehouse. According to requirements analysis the access channels，departments and funds were confirmed as the three implicit information which were implemented through the fact table and dimension table design with the efficient star query model as a conceptual model.