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 |
|
toGauravKumar
Starting Member
1 Post |
 Posted - 2008-06-23 : 11:40:01
|
| Hi, We wish to create cube in SQL Server 2005, where we can create a cube using query. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-23 : 12:29:19
|
| You need to first design your schema for warehouse, after determining what will be the included dimensions and facts,populate the tables with source data using ETL tool like SSIS and then use Analysis Services to build the cube out of the created dimensions and facts. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-23 : 22:31:45
|
| There is no query to create cube, and you need MDX to query cubes if don't use gui. |
|
|
|
|
|
|
Regarding creating Cube in SQL Server 2005