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.

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

Analysis Services - Data Source Views | Data Source View

ssas1 Analysis Services   Data Source Views SSAS Data Source View


With our data source created we can now focus on the Data Source View.

What is a Data Source View ?

A Data Source View allows the developer to create a logic view of the data to be placed in to the cube. This logical view should be contructed in a denomalized fashion; meening that this information should already be in a structure of dimensions and fact tables. Easier said than done, there is always going to be a table missing or a field calculation missed during the ETL stage.

So this video will not only explain what a Data Source View is but also show you have you can add calculation and even new views based on only the data sources at your disposal. This video is a MUST see if you want to control your masterfully control your data!

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

The Data Source View example files

To obtain the sample files please click here:

Related Posts

8 Comments

  1. Kris Maly says
    13 Apr 15 at 10:44am

    I have VS2012
    I followed your steps
    When I try to Drag Tables on to the Diagram I don’t see them, Why?
    Any ideas?

  2. Kris Maly says
    13 Apr 15 at 10:40am

    I enjoyed watching this Data Source View 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

  3. NeverForget1776 says
    13 Nov 14 at 12:00pm

    @spshaw
    “I don’t get the pivot table, chart, or pivot chart options. This is on SQL
    2012.”

    FYI (In case you never got an answer elsewhere)…Those were based on the
    office web controls which were deprecated in SQL Server 2012 and that’s why
    you don’t see those tabs (nor I). Kind of suck because the reported work
    around (per Microsoft) is to launch Excel from within Data Tools and use
    Excel. Only problem is that its limited to less rows then what you could
    have gotten with the Office web components. sound’s to me like this was
    another MS Back Step action

  4. tomdagoy says
    24 Jun 13 at 12:30pm

    5.30 roleplayinng

  5. Kalpana Ganesan says
    13 Sep 12 at 10:40pm

    Informatics Outsourcing is an Offshore Clinical Research Company providing best Pharma and Biotechnology services like Bioinformatics Services, Chemical Informatics Services, Bio Information Technology, Data Analysis Services, Scientific Data Management Systems, Drug Discovery Services Worldwide with affordable price.

  6. Safwan says
    04 Aug 12 at 6:39pm

    Dear Pcteach.me,

    you are doing a great thing by providing detailed videos in such a neat and professional manner.
    i have learnt lot from you. Lots of thanks…

  7. spshaw says
    25 Jun 12 at 8:50pm

    Great videos btw. One question – when I explore tables after selecting a named query I don’t get the pivot table, chart, or pivot chart options. This is on SQL 2012. Suggestions?

  8. spshaw says
    25 Jun 12 at 8:50pm

    [..YouTube..] Great videos btw. One question – when I explore tables after selecting a named query I don’t get the pivot table, chart, or pivot chart options. This is on SQL 2012. Suggestions?

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security