tabular model cube

Question

Post reply

tabular model cube

psingla

Hall of Fame

Points: 3840
More actions
July 1, 2014 at 5:52 am

#396983

Is it OK to call tabular model database as tabular cube?
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

Viewing 7 posts - 1 through 6 (of 6 total)

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

psingla (7/1/2014)
Is it OK to call tabular model database as tabular cube?

Euhm. A tabular model is not a cube, if that is what you are going at.

A tabular model are just a bunch of tables where measures can reside in any table.

In a cube, you have the explicit distinction between measures and dimensions.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

psingla Hall of Fame Points: 3840 More actions · Answer 2

Koen,I second that tabular model database is not a cube..

But I am seeing some Microsoft guys using word "tabular cube"

http://blogs.msdn.com/b/andreasderuiter/archive/2012/12/10/should-you-use-a-data-warehouse-with-a-tabular-cube.aspx?CommentPosted=true#commentmessage

Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

psingla (7/1/2014)

Koen,I second that tabular model database is not a cube..

But I am seeing some Microsoft guys using word "tabular cube"

http://blogs.msdn.com/b/andreasderuiter/archive/2012/12/10/should-you-use-a-data-warehouse-with-a-tabular-cube.aspx?CommentPosted=true#commentmessage%5B/quote%5D

In my opinion, it's incorrect usage of the term.

It's a tabular model and a multidimensional cube.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

psingla Hall of Fame Points: 3840 More actions · Answer 4

Thanks a lot Koen

Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

psingla Hall of Fame Points: 3840 More actions · Answer 5

I see Other place where Microsoft is referring tabular database as cube.

in SSDT,right click your tabular project>Properties>Under Deployment server

I see "model" as cube name..

Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

psingla (7/3/2014)
I see Other place where Microsoft is referring tabular database as cube.
in SSDT,right click your tabular project>Properties>Under Deployment server
I see "model" as cube name..

It's possible. There is a compatibility between Tabular and Multidimensional in the sense that client tools should be able to work with both.

For example, SSMS, Excel and the SSRS query designer. However, some of those were not brought up-to-date so they refer to the model as the cube.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP