if “Tabular semantic model” can be used same way as Report Models.

Question

if “Tabular semantic model” can be used same way as Report Models.

mcfarlandparkway

SSCertifiable

Points: 7699
More actions
July 12, 2016 at 6:14 am

#328195

I am Researching if “Tabular semantic model” can be used same way as Report Models.
I am trying to Build a POC using new mechanism.(SSAS)
Any ideas please?

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

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

Brian Carlson SSCarpal Tunnel Points: 4170 More actions · Answer 1

It's a different mechanism, but the concept of users making their own reports is the same. Excel Pivot Tables is a common tool that most users will have that can connect to it.

mcfarlandparkway SSCertifiable Points: 7699 More actions · Answer 2

Thank you for the response..

But didn't understood this point "Excel Pivot Tables is a common tool that most users will have that can connect to it. "

Can you please briefly explain it? from where they will connect? which point to which point?

Brian Carlson SSCarpal Tunnel Points: 4170 More actions · Answer 3

When you create a Tabular model you deploy it to an instance of Tabular SSAS on a server. Then the users will open Excel, Data tab, "From Other Sources", "From Analysis Services". At this point, they'll provide a connection string to the Tabular SSAS instance and select a database/cube. Once this has been done, there will be a list of columns - both measures & attributes - that the user can choose from.

That's the short of it. It's a large topic and there's a lot on the Internet about it. Report Models are simpler but Tabular models are more powerful.

mcfarlandparkway SSCertifiable Points: 7699 More actions · Answer 4

I am trying to Create a Adhoc POC using Tabular Semantic models ( SSAS)

POC is nothing but proof of concept am I right? I mean what are the steps should I take place?

patrick.w.wheeler SSCommitted Points: 1796 More actions · Answer 5

I'll just share what I ended up doing for my first model.

I wrote my SQL to pull in my Fact table and then joined my dimension table in the SSAS designed in Visual Studio. Once that was created I started to build my calculated fields in the fact table which gave me facts to analyze against the dimensions.

Once that was set I then began to create measures that were calculated off of the fact table.

The Excel pivot table in SSAS is a feature in tabular that allows you to on the fly review how the data is reporting in a classic pivot table format. Extremely useful.

Querying Microsoft SQL Server 2012/2014 - Certified

mcfarlandparkway SSCertifiable Points: 7699 More actions · Answer 6

Yeah,TY but what am I looking here is..

We have a report model when we upgrade this newer version as background research we decided that its deprecated no longer supported in SSDT.

We are trying alternate options to see how tabular semantic model works? They are looking to be very simple.right now all the tables are presented to the end user where they can drag and drop and can create their own reports on the fly same thing they are expecting to be with tabular semantic model.

Right now we have 2 components one is report builder and another backend report model data source where this is deprecated some people end up in using datasets.

I am trying to take one table in the report model and try to create a tabular semantic model and see how it works?

I am very new to SSAS can I get any links how to create this TSM?

imani_technology SSCrazy Eights Points: 8200 More actions · Answer 7

I'm confused. What is deprecated? Are you saying SSRS is deprecated or that your organization wants to stop using them? What is the goal? Do you want to use SSAS instead of SSRS? They serve two different purposes, in my opinion.

mcfarlandparkway (7/12/2016)
Yeah,TY but what am I looking here is..
We have a report model when we upgrade this newer version as background research we decided that its deprecated no longer supported in SSDT.
We are trying alternate options to see how tabular semantic model works? They are looking to be very simple.right now all the tables are presented to the end user where they can drag and drop and can create their own reports on the fly same thing they are expecting to be with tabular semantic model.
Right now we have 2 components one is report builder and another backend report model data source where this is deprecated some people end up in using datasets.
I am trying to take one table in the report model and try to create a tabular semantic model and see how it works?
I am very new to SSAS can I get any links how to create this TSM?