Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25426 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

Analysis Services - Cube Creation

ssas1 Analysis Services   Cube Creation  SSAS Cube Creation


So we have created our logical view of our data it’s now time to create our cube…or is it?

Can I create a Cube So Soon?

The Microsoft textbook response is you can tackle Cube creation head on once you have established your Data Source and Data Source View. Yet there is something quite vital we are missing from our current developments which are dimensions. Dimensions (which we will get to shortly via several videos) are the text-based values you are going to want to place next to your Cube aggregations. E.g. If you have total sales in your Cube you probably will want to present that with perhaps a region or customer?

Well the Cube Wizard handles creating these dimensions for you. Albeit not to the degree you will wish.  You will soon find that the wizard is a good starting point but will lack the finesse you will be needing to apply to make a fully functional cube.  But for the newbie coming to SSAS for the first time this is quite a sense of achievement and rightly so, you have traversed OLTP to OLAP using ETL in SSIS to reach SSAS.  Boy I have just reliased how much I.T. relies on acronyms simple smile Analysis Services   Cube Creation

This video is one of many SSAS tutorials on this site click here for more.

The Cube example files

To obtain the sample files please click here:

Related Posts

29 Comments

  1. AdItYa KuMaR says
    09 Jul 14 at 12:05pm

    Please correct me :- As I understood , data cube does not captures any
    spaces in database , it just uses the measures & dim table data present in
    DWH & It does not create any other tables (summary tables) .??

    But somewhere I read that cube is collection of summary tables in which
    measures are added acorss different dims?

  2. Stuart Lunn says
    05 Jul 14 at 1:32pm

    Yes, v useful – thanks

  3. Charles Smithers says
    16 Mar 14 at 9:05pm

    Great training videos. Thanks heaps for sharing!

  4. Vikrant Raj Behal says
    21 Oct 13 at 11:27pm

    Is it necessary to create Datawarehouse as you are mentioning in each video? Can’t we proceed and directly choose database and define dimensions and fact during cube creation?

  5. Snowy Durban says
    12 Sep 13 at 10:01pm

    Great Tutorials! Thoroughly enjoy your clear and concise explanations. I’ve been a DBA in the past and never tackled Analysis Services before now. I’m thoroughly enjoying learning more about it now though. :)

  6. Krzysztof Wojcik says
    22 Aug 13 at 7:21am

    Perfect! finally someone with great voice. Everything clean and clear. Keep it on!

  7. temporarymusician says
    02 Jul 13 at 5:53am

    ….finally! a fab tutorial, in clear language…. Also appreciate your humour.

  8. tomdagoy says
    24 Jun 13 at 1:24pm

    19.10 wizard sucks

  9. tomdagoy says
    24 Jun 13 at 1:21pm

    16.10 3 date dimensions

  10. ValessaHero says
    26 Apr 13 at 6:04am

    Analysis is completed.Commencing planetary analysis of Azeroth. It is in the universe’s best interest to re-originate this planet should my analysis find systemic corruption. Do not interfere.

  11. simo12390 says
    08 Apr 13 at 2:07pm

    tks :)

  12. simo12390 says
    08 Apr 13 at 2:07pm

    me too 😉

  13. pepeShadowdancer kali says
    26 Feb 13 at 8:49am

    wow! Well done! You have explained in 21 minutes what my teacher couldnt do it 6 hours!!!

  14. hungryofknowlege21 says
    22 Nov 12 at 2:14pm

    This is really good!!!!!!!!!!!!!!!! Thanks a lot for taking the time to help us with this info

  15. amyle2012 says
    20 Mar 12 at 12:37pm

    Thanks for all your excellent and valuable videos.

  16. PCTeachME says
    01 Mar 12 at 11:04am

    Hi, they are up now :o)

  17. PCTeachME says
    01 Mar 12 at 11:04am

    [..YouTube..] Hi, they are up now :o)

  18. PCTeachME says
    01 Mar 12 at 11:04am

    [..YouTube..] @ProudMoroccan82 Hi, they are up now :o)

  19. ProudMoroccan82 says
    29 Feb 12 at 10:29pm

    Excellent Trainings.
    when are you going to upload the video for Dimensions?

  20. 29 Feb 12 at 10:29pm

    [..YouTube..] Excellent Trainings.
    when are you going to upload the video for Dimensions?

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security