|
SSRS |
|
|
[General] |
|
|
Questions: |
Notes: |
|
What are Drill Through Reports? |
Drill Through Reports are reports which link objects to specific actions.
This makes the report more interactive because the user can click on an object such as a table field and open another report which elaborates on that specific value. |
|
What are Sub Reports? |
Sub Reports are reports that are embedded in another report.
The parent report pulls the sub report and inputs any parameters if needed. |
|
What are Map Reports? |
Map Reports take spatial data and formats it into a visual map.
For example, if we have data for sales based on state. We can make a map report which visualizes the sales by state on a US map and colors the states based on sales amount. |
|
What are Cube Reports? |
Cube Reports are reports where the data source is a SQL Server Analysis Services Cube.
The source connection is made to the Analysis Engine and the data set is taken from a MDX query on the cube. |
|
What are KPI Reports? |
KPI Reports are reports that use KPIs (Key Performance Indicators) in order to give the user a visual representation of the progress of the business. |
|
What are Report Models? |
Report Models are the base structure of Ad Hoc reports. With report models you just choose a data source and a data source view (similar to the SSAS GUI).
From this model the end users can create their own custom reports by using the Report Builder. |
|
What can you do with RM’s DSVs? |
The Data Source Views in Report Models work the same way as the DSVs in SSAS projects.
With them, you can create derived columns based on stored columns. Create entirely new derived tables.
All of these tables and columns can be referred to by the end user when using the model in Report Builder. |
