Although most reporting solutions are designed for handling OLTP solutions, reports play a major role in Business Intelligence (BI) solutions as well. Generally, Production Reports or Formal Reports (sometimes called Paginated Reports) are the ones we create for OLTP solutions, whereas Analytical Reports, Dashboard Reports, and Mashup Reports are created for Business Intelligence solutions.
Reporting Services 2016 is an enterprise reporting platform that is rich enough to address requirements related to both OLTP and BI solutions. Its capabilities allow us to make reports suitable for BI solutions. It also enhances the user experience with its features providing both ad-hoc reporting and self-service reporting.
In this chapter, you will learn how to integrate Reporting Services with BI solutions and its components, such as OLAP databases. This chapter covers the following recipes:
Making Reporting Services as a part of BI solution
Creating...