We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “Denali”.
In this post, let’s create a simple no frills, no fancy excel report.
Down the series, I shall introduce you to Perspectives, Roles and many associated features for an elegant Self Service BI experience.
This should help you kick start on Tabular Models.
Again, I am using the AdventureWorksDWDenali as my database to create tabular models.
Let’s create few measures in our existing tabular model, which was created for our earlier posts.
So, let’s create measures on our FactInternetSales, FactResellerSales
For FactResellerSales: Reseller_Sales, Reseller_Tax, Reseller_Freight.
For FactInternetSales: Internet_Sales, Internet _Tax, Internet _Freight
Also, please note to change the data type of the calculated measures to decimal and change the value of Show Thousand Separator to TRUE. These properties can be set in the properties window.
Now, if you are wondering that while developing measures in SSAS the developer had the luxury to group measures in folders. Well, in Tabular Project, this is no longer required. You can see the new groupings created either in SSMS or in Excel.
Now the usual chore, Build the project and Deploy the changes.
Once the task is complete, click on Model and now click on Analyze in Excel
(I am using the credentials of the current windows user. No Roles. No Perspective.)
Let us now create a pivot report analysis and a pivot chart for data visualization
In the next post we shall see how to create such charts and tables directly from MS-Excel interface.
That’s all. Happy Learning!