How to create a cube

I think I have forgot most of my knowledge about SSAS.

Now I just want to remind me about how to create a cube:

Cube is on the basic of dimension, now I have three dimensions:time,product,employee.

First

 Then select related fact tables we will use in cube:

Then we will select the meric that we need next page:

Then SSAS will list all the dimensions we have created,and we can select which one can be used:

Then we can select some new dimensions and we can chose some or not:

Then click next,we will finish the wizard.

we can see the new cube we created:

Here we have 4 date dimensions:

We can go to next tab:

We can edit the relationship between dimension and metric:

 

Then we can deploy it:

Then go to 'browser' tab to browse the cube by the dimensions:

For example:

We can also set the format of metric:

 

then set it:

Of course we can add dimension and metric:

 Or go to caculation tab and make a user-defined measure:

 

Tomorrow,basketball!!

 

posted @ 2012-08-14 21:54  answerlkh  阅读(108)  评论(0编辑  收藏  举报