Build a Data Cube?

[pranjal1985]

Hi,
I am a new comers in the fieled of SQL server 2000. I have to buid a data cube having the dimensions year,applicatio n number and student details.Please give me the suggestion with the query. I have create just one table with the attributes year,applicatio n number and studen details(name, address,marks ). I request you all please help me.

Pranjal,
Gauhati University

[BHARATH RS]

Hey u have analysis services in sql server 2000 which helps u to build data cubes over the table(s). Please check that if u have analysis service installed in ur machine.