Can i create a cube without using new cube wizard?

Question

Can i create a cube without using new cube wizard?

mqmendozza

SSC Veteran

Points: 264
More actions
June 26, 2014 at 12:45 am

#295906

I am just confuse because many advance tutorials says build first the dimension before the cube.
please help.
many thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lempster SSCoach Points: 15651 More actions · Answer 1

You can build an empty cube and then add dimensions later, but usually, yes, you would create your cube from an existing Data Source View (DSV) and use existing dimensions tables for your cube dimensions. If all your dimensions are going to be linked dimensions, i.e. dimensions belonging to another cube, that is where building an empty cube would come into play.

Regards

Lempster

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 2

If I'm not mistaken, you can also let the cube wizard build dimensions for you.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

mqmendozza SSC Veteran Points: 264 More actions · Answer 3

thanks for the idea, what i did was i created all dimensions first (3 to 4 dimensions) and right click on cubes go create wizard and select one fact table and add all dimensions that i created.

am i doing it right? well im thinking that the way is other than this one like not using the create cube wizard.

thanks for the help.

JAO

Lempster SSCoach Points: 15651 More actions · Answer 4

Koen Verbeeck (6/26/2014)
If I'm not mistaken, you can also let the cube wizard build dimensions for you.

You are not mistaken Koen, but you don't get that option if you choose 'Empty Cube' on the 'Select Creation Method' window.

Regards

Lempster