|
SSRS |
|
|
[General] |
|
|
Questions: |
Notes: |
|
Can you create Report Models from Cubes in BIDS? |
You cannot generate a model from your OLAP systems in BIDS.
But if you have to use your Cube as a source to your Ad Hoc reports you can use your Report Manager to generate a SMDL file that you will feed to the report builder to create Ad Hoc reports. |
|
What is the difference between Report Server and Report Manager? |
Report Server is the web service application that functions as your programmatic gateway to the SQL Reporting Services engine. When browsing to the Report Server, you will be shown the contents of your individual Reports directory.
Report Manager is a convenient web user interface to the Report Server that enables you to view and administer your reports, data sources, and report resources. |
|
What are Roles? |
Roles provide Report Item Level security.
With roles, you can grant or deny access to specific functionalities of SSRS, Report Server, and Report Manager. |
|
What are the different purposes of Roles? |
We can assign roles to users with different levels of access.
Such as:
|
|
What are the different Security levels? |
The different server/system security levels include:
|
|
What are Linked Reports? |
Linked reports are just shortcuts to a stored report.
They allow a user to view the report without accessing the underlying folder or files. |
