Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can i create a cube without using new cube wizard? Expand / Collapse
Author
Message
Posted Thursday, June 26, 2014 12:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 4:13 AM
Points: 2, Visits: 17

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

please help.

many thanks.
Post #1586244
Posted Thursday, June 26, 2014 2:16 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 22, 2014 4:18 AM
Points: 2,048, Visits: 1,403
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
Post #1586280
Posted Thursday, June 26, 2014 2:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 13,639, Visits: 10,534
If I'm not mistaken, you can also let the cube wizard build dimensions for you.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1586289
Posted Thursday, June 26, 2014 2:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 4:13 AM
Points: 2, Visits: 17
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


Post #1586297
Posted Thursday, June 26, 2014 2:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 22, 2014 4:18 AM
Points: 2,048, Visits: 1,403
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
Post #1586298
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse