Data warehousing in sql server 2008
- by 3bd
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