In this tutorial, you will be introduced with how to use SharePoint Portal Server 2013 for Business Intelligence purposes. I have already uploaded the snapshots of steps. I will add comments shortly.
Friday, March 29, 2013
Reporting Results Using SQL Server Reporting Services
In our previous tutorial, we generated TPC-H Query 1 results with near to zero response time using SQL Server Analysis Services. In all our previous tutorials related with TPC-H Query 1, we only attempted to process the query to get the required results. Each query result is of importance for end-user. If your end-user is a business user and your query results are required for decision making. We should present our result using an appropriate reporting tool. In this tutorial, we will focus on SQL Server Reporting Services. For generating reports using SQL Server Reporting Services, we will be using SQL Server Business Intelligence Development Studio. For reports, we have a dedicated project type, i.e. Report Server Project. Create a new project for Report Server Project as shown in dialog below:
As the project is created, you will have to add report to your project.
As the report is added, you will end-up on Report Wizard dialog. This Report Wizard make it easy for developers to complete the most of report generation work.
As you move next, the first step as in any report generation process is to select the appropariate data source for your report. You data source could reside on any supported database or data services. In this tutorial, we will be connecting with SQL Serve Analysis Services as shown in figure below.
Once we are done with creating the connection, the next step is to write an appropriate query to extract the required data from data source to make it available on our report. For this purpose, we have a query designer, which facilitate us to create a query using GUI.
However, if you are comfortable with MDX query, which you should be after working with our tutorial on OLAP Query Languages then you can also write an MDX query by yourself as shown in figure below.
After completing the query part, on the next screen Report Wizard will ask you to select the report type. If you want to report a multi-dimensional cube data then Matrix (also know as cross-tab) is the best suitable report type. However, Tabular report type can also be used to report multi-dimensional cube data.
For Matrix report type, wizard will ask you to specify, what content will be displayed at rows and columns.
There are many different styles available for your report appearance. You can select one appropriate for your report audience and content.
On the next screen, you are done with your report creating task. Give your report an appropriate name.
After completing the wizard, you can view the report in design window.
To preview the report, you can make use of preview tab.
In report designer, at bottom you will find Row Groups and Column Groups sections. You can alter the row groups and column group settings from their. For example, in figures below, we are changing the group properties for Calendar_Year group.
We change the sort order of Calendar_Year.
Subscribe to:
Posts (Atom)