Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhushan.juare
Starting Member
7 Posts |
 Posted - 2011-08-01 : 02:44:00
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-01 : 04:23:43
|
| 1, what do you mean by customised? obviously, you design databse only as per your requirement by including only facts to hold your measures and dimensions based on which you want to do the analysis2, You can. But designing database specifically for cubes ensure they'll be optimised for cube access/analysis3,you need to. what all to be chosen as facts and dimensions depends on your requirement4, you dont need to create the hierarchy in databse. you can bring data flattened out from database by keeping it to lowest level (grain) possible and build required hierarchies inside cube definition------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Do I need to Create Customized Database to design