Creating Your First Tabular Model (part 1)

Who is online?  0 guests and 0 members
Home  »  Blogs  »  DustinRyan  »  Creating Your First Tabular Model (part 1)
 
0
/5
Avg: 0/5: (0 votes)

Comments (6)

Daniel
Daniel said:
Not knowing PowerPivot, some of the reasoning is not really clear to me. What are you using as your knowledge base (books, books online,etc.) to work through these issues and blog about them? This seems like a good intro but I would like to know more of why and wherefore? Thanks,
3/22/2012
 · 
 
by
DustinRyan
DustinRyan said:
I spent a lot of time on MSDN in the past couple days reading and I also just spent a lot of time playing with the features. http://msdn.microsoft.com/en-us/library/hh212945(v=sql.110).aspx If you're looking for some other great material, James Serra has a great blog here: http://www.jamesserra.com/archive/2012/03/sql-server-2012-denali-tabular-models-vs-powerpivot-models/
3/22/2012
 · 
 
by
user492336
user492336 said:
There are lots of resources out there. Microsoft Virtual Academy has a couple of good videos on tabular model and DAX: https://www.microsoftvirtualacademy.com/tracks/breakthrough-insights-using-microsoft-sql-server-2012-analysis-services There is codeplex sample for Adventureworks: http://msftdbprodsamples.codeplex.com/releases/view/55330 There is MSDN tutorial: http://msdn.microsoft.com/en-us/library/hh231691(v=sql.110).aspx And there are lots of good blogs out there. Not just mine (http://cathydumas.com), but people like Chris Webb (http://cwebbbi.wordpress.com/) and Marco Russo (http://sqlblog.com/blogs/marco_russo/) as well.
3/22/2012
 · 
 
by
sneha19.m
sneha19.m said:
Hi, I have a tabular cube created with relationships defined in the cube only.Source is Sql Server. Cube contains a fact and some dimensions. When I process, build and deploy the cube to create a powerview report, and when I drag drop a field from dimension table; to see corresponding field from dimension, the relationship which is created, is not established and I cant view the data as I would normally would see in a Multidimensional Cube. Any idea what am I missing? Appreciate responses. Thanks, Sneha.
6/22/2012
 · 
 
by
DustinRyan
DustinRyan said:
Hi sneha19. Thanks for checking out my blog! Please post your comment in the BIDN Analysis Services forums (http://www.bidn.com/forums/microsoft-business-intelligence/2/analysis-services) so others can learn from your question and have an opportunity to respond. Thanks!
6/22/2012
 · 
 
by
MitchellPearson
Good Stuff, thanks Dustin.
9/1/2013
 · 
 
by
DustinRyan
DustinRyan said:
Word. Glad it was helpful!
9/3/2013
 · 
 
by
Deepak323
Deepak323 said:
Hi I am using Tabular model for our reporting for quite a while now and prefer defining my measures in Dax queries itself. just want to know if i define my measures in the .bim file will it cause a delay in the cube process time? Thanks Deepak
7/8/2014
 · 
 
by
DustinRyan
DustinRyan said:
Adding DAX calculations to your Tabular project will add time to processing. Whether its a significant amount of time would depend on many factors, but the good news is that your queries will be faster because the answers to the DAX calculations are materialized. So by defining your measures in the bim file you could see better query performance than if you were calculating your measures at query time. I hope this helps.
7/8/2014
 · 
 
by
Blogs RSS Feed

DustinRyan's latest blog posts

Blogs RSS Feed

Latest community blog posts