is it possible to create a start schema in SQL server 2005????.....

plz reply....

Thanks

You can create star schema on ANY rdbms. But you would be using rolap, not molap.

search the internet and learn what a "fact table" is and a "dimension table".

When you create one fact table, at least two dimension tables and load them with data and link them with inner joins only, you have created a basic star schema.