Post reply

SSAS 2012 - Tabular Model

  • August 5, 2012 at 11:38 pm

    #279235

    Dear Experts –

    I have recently installed SQL Server 2012 on my machine. I am now asked to develop a cube in SQL 2012 tabular model. As a matter of fact, I am not an expert in SSAS but I am good.

    Can anyone of you please provide me some insight on Tabular Model and can provide any example or tutorial on the same? I am also trying to get some idea by going thru MSDN Blogs etc.

    Any help would be greatly appreciated.

    Thanks in advance !!

    Srini

  • September 14, 2012 at 2:51 pm

    #1538169

    Hello,

    My team at work had done this tutorial to get an understanding of tabular modeling... Its fairly basic, but if you haven't worked with it much it is a good starting point.

    http://msdn.microsoft.com/en-us/library/hh231691.aspx

    Another thing to note is that the role-playing dimensions that we are used to are handled much differently in Tabular Modeling. Since tabular modeling only allows one active relationship between two tables, you will need to create different tables for each key (example: order date, ship date, etc).

    I have also discovered one other annoyance with Tabular modeling... the lack of folders to organize measures. I am not sure if you will run into this problem but I found one basic solution here (although I do not know if this would be practical as a long term solution)...

    http://cathydumas.com/2012/02/09/pasted-tablesa-poor-womans-display-folder/

  • September 14, 2012 at 6:19 pm

    #1538236

    Thanks much for the information !!

    I have already done the tutorial from MSDN, it was really helpful. Got a basic idea about Tabular Model, now I have been able to develope two cubes out of tabular model 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

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