SSRS 2012 Report Models

reporting-services sql-server-2012 ssrs-2008-r2
Daniele Di Punzio picture Daniele Di Punzio · Oct 8, 2012 · Viewed 9.9k times · Source

I am preparing a SSRS 2008 R2 commercial demo for my company, using Report Model to produce a kind of "BO Universe" data model to use with Report Builder, to show how users can produce their own reports by using a data model already created by a developer. I found out that Report Models are deprecated in SSRS 2012, is there any new tool to create a data model to deploy on report server, usable by users to produce reports?

Thanks in advance, Daniele

Answer

Diego picture Diego · Oct 8, 2012

Semantic modeling language (SMDL) report models are deprecated. Although you can you continue to use existing report models as data sources in SQL Server 2012 Reporting Services reports you should consider updating your reports to remove their dependency on report models.

SQL Server 2012 Reporting Services does not include tools for creating or updating report models.

SQL Server Data Tools (SSDT) no longer supports report model projects. The Report Model designer is not available in SQL Server 2012 Reporting Services (SSRS). You cannot create new Report Model projects or open existing projects in SQL Server Data Tools (SSDT) and you cannot create or update report models. To update report models, you can use SQL Server 2008 R2 Reporting Services or earlier tools. You can continue to use report models as data sources in reports authored in SQL Server 2012 Reporting Services (SSRS) tools such as Report Builder and Report Designer. The query designer that you use to create queries to extract report data from report models continues to be available in SQL Server 2012 Reporting Services.

Sources: here and (mainly) here

Related questions

SQL Server LCK_M_S only happens in production

I have a stored procedure that is called by a SQL Server 2012 report that is taking an age to run in production compared to development because of a blocking session lck_m_s The stored procedure runs instantaneously when executed …

Read More
How to add oracle data source in ssrs

I've installed SQL Server 2012, after I've installed all features including report services. I go to Report Manager link and wanted to add New Data Source, but in Data Source Types there is only Microsoft SQL Server and I want to …

Read More
The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More