How to create cube in sql2005?

Hi experts,

I want to create a cube using sql2005. I have read some articles which told me to create it through Visual Studio and still i cannot find where i should do that. I cannot find an "Analysis Manager" UI in sql2005 or Visual Studio. If any body could help i will really appreciate. Thanks

Hi paul_sh,

Which version of visual studio are you using now?

The "analysis manager" UI only exists in sql2000 and has migrated to Visual Studio since sql2005. Now if you want to create cubes , first open visual studio (the version should be 2003 and above), and click NewProjects. Choose project type as Bussiness Intelligence Projects and select the template of " Analysis Service Project" then click ok. After that you can edit your cube freely(note there are lots of pre-defined templates which you are make use of)

Hope my suggestion helps