Data warehousing in sql server 2008

Question

Hi All:
I am new to data warehousing and I am a little confused
plz provide some simple steps to create a cube and fill it and make querey on it
to know :
I have a database with the original data
and I have designed the star schema and made appropriate tables
I have created an analysis service project in VS 2008
and then I have made the data source -data source view-dimensions - and the cube
all that based on the star schema i have created previously

now: what should I do to:

• fill this cube
• make query on this cube

Answer 1

Microsoft has a pretty good tutorial here, and for MDX see here.

In SSAS, filling-in data into a cube is called processing cube, measure, dimension... See details here.

Tutorials are fairly long, so I do not think that a generic answer would fit here, I would suggest that you work you way through tutorials and then return with more focused, specific questions.