Reporting Services
It may seem counterintuitive to mention SSRS in a BI context, given how prevalent use of SSRS is for operational reporting against transactional, relational databases. But SSRS is a bona fide BI tool, too, due to several lesser known features that it supports.
First among those features is the native ability in SSRS to issue MDX queries against SSAS cubes, bringing back the multidimensional results in the form of “flattened” tabular result sets. The MDX queries can be supplied by the report developer, but they can also be defined visually. This means SSRS can be used as an SSAS client, and one which requires no MDX knowledge, but still allows that knowledge to be applied, if desired. Furthermore, this functionality works against ...
Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
