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!!