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

浙公网安备 33010602011771号