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.

25021 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. Irina Max says
    29 Jul 15 at 2:05am

    What tools I can use on MacBook?

  2. Oremo Ochillo says
    12 Jul 15 at 7:02pm

    I must say that I applaud you for trying to taking on a subject that so
    many people struggle to explain to others. Keep up the good work.

  3. Netanel says
    20 May 15 at 8:40am

    I Join the other comments – You are the best!
    I dont think there is existence of better videos than yours!

    Thank you So much!
    Netanel.

  4. Taufiq Makhani says
    07 May 15 at 1:58am

    Loved this! Other beginner cube videos were no where near as detailed as
    yours.

  5. Gao Lili says
    02 May 15 at 1:57am

    This is the best SSAS tutorial I have ever seen by now, please keep on
    publishing more. Thanks a lot.

  6. Kris Maly says
    13 Apr 15 at 2:30pm

    I enjoyed watching this Cube Creation video and recommend others to watch.
    Thanks for educating the community and appreciate your volunteer-ship.

    Narrator of this video know the topic very well and he is a nice teacher.

    Please keep publishing some videos on SSAS SQL Server 2012 or 2014

    Thanks a bunch

  7. Nick Holt says
    09 Mar 15 at 7:31am

    This is such a great series of tutorials. thanks for taking the time to
    share your knowledge.

  8. Lenz Faraday says
    07 Dec 14 at 4:17am

    You’re a big aldout.pls play data cube

  9. NeverForget1776 says
    13 Nov 14 at 4:46pm

    FYI – If like me you get an error that localhost could not be
    accessed/opened or something along the lines of the service not running you
    may need to change the details of the destination SSAS instance you are
    deploying the cube to. I’ve watched this series from 01 and while it’s
    been a good series he did assume that you would have a local setup of SSAS
    accessible as localhost. If you have an error like this then right-click
    on the project (within solution explorer) and select properties. On the
    properties window select Deployment and change localhost to the name of
    your SSAS instance you will deploy your cube to.

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security