how to make cubes

  • hello,

    i am building a data warehouse using sql server 2000. can someone let me know how to make data cube using the enterprise manager of sql server 2000

     

    thank you

  • Hi Pooja

    You can't make cube from EM. Use Analysis server for create cube and diamensions.

    Rakesh

     

  • What is a data cube?

  • Hi,

    You can use Cube wizard of Analysis Server 2000, a companion of SQL2K or Cube editor for creating cubes.

  • hi guys,

    thanks for the support. also, i want to know...do we need separate data storage memory for cubes and aggregations? and how many cubes is it appropraite to build

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply