SSRS Interview Questions 3

SSRS [General] Questions: Notes: What is the Report Server? Report Server is a web application that acts as a gateway to your underlying Report Server database.   This way you can read the metadata of the reports.   The URL is:  http://localhost/ReportServer What is the Report Manager? Report Manager is a web interface which allows […]

Read More

SSRS Interview Questions 2

SSRS [General] Questions: Notes: What are Ad Hoc Reports? Ad Hoc Reports are reports that use queries that are made on the fly via drag and drop functionalities.   They can be used by non-technical people who do not know how the data is structured or how to query. They are mostly GUI based.   […]

Read More

SSRS Interview Questions 1

SSRS [General] Questions: Notes: What is SSRS? SSRS stands for SQL Server Report Services. It is the component of Microsoft SQL Server 2008 that provides an enterprise-ready and extensible presentation layer for the Microsoft business intelligence platform to develop, manage and deliver reports.   What are the stages of the Report Life Cycle? The stages […]

Read More

SSAS Cube Processing and Implementing Security

SSAS Cube processing options. 1. Process Default. Performs the minimum number of tasks required to fully initialize the object. The server converts this option to one of the other options based on the object state. 2. Process full Drops the object stores and rebuilds the object. Metadata changes, such as adding a new attributes to […]

Read More