Hi Guys, I am refering AdventureWorks2008 Database for Cubes design and I have noticed database is organised as per Cubes requirnment. I want to know, 1) Is it essential that cube database is customised? 2) Can I use any database to design Cube? 3) Do I need to design fact tables, dim tables looking towards Cube? 4) If so, how to create heirarchy between fact & dimension tables physically in database?