Three tier data warehouse contains three tier such as bottom tier,middle tier and top tier. Bottom tier deals with retrieving related datas or information from various information repositories by using SQL. Middle tier contains two types of servers. 1.ROLAP server 2.MOLAP server Top tier deals with presentation or visualization of the results .
The 3 tiers are: 1. Data tier - bottom tier - consists of the database 2. Application tier - middle tier - consists of the analytical server 3. Presentation tier - tier that interacts with the end-user
a three tier DWH means top level, middle level,bottom level. it's right. but i think, it 's combination of respectivetool's cliet,respective tool's server & server manager.
