SQL Server Performance

Do I need to Create Customized Database to design?

Discussion in 'SQL Server 2005 Analysis Services' started by bhushan_juare, Jul 31, 2011.

  1. bhushan_juare New Member

    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?
  2. satya Moderator

    1) yes
    2) Yes
    3) Not necessarily
    4) Better to download updated books online for SQL 2005 and read on

Share This Page