Skip to main content

Posts

Showing posts from 2011

WMI Script to retrieve SSRS Configurations

For retrieving the SQL Server Reporting Services configurations using custom program in C# or .NET we need to use WMI (Windows Management Instrumentation) script. The process involves the following steps. RETRIEVING WMI NAMESPACE FOR SSRS For retrieving the WMI namespace we write the following function.   public static string GetNamespace( string machineName)  {    string rSroot = @"root\Microsoft\SqlServer\ReportServer" ;    string strNamespace = "" ;    System.Management. ManagementClass mc = new ManagementClass ( new     ManagementScope ( @"root\Microsoft\SqlServer\ReportServer" ), new ManagementPath ( "__namespace" ), null );             foreach ( ManagementObject ns in mc.GetInstances())             {                 if (ns[ "Nam...

Reporting Service Architecture

The Reporting Service Architecture Components  Report Manager :- It is a web application which stores and manages report,report models,report parts, folders, subscriptions, security and schedules. Report Server :- This is a web service which exposes all the methods for report management to Report Manager/Custom applications which can consume it and can create UI for report management. Report Server DB/Temp DB :-  The report server database keeps all the report paths, schedule info and other utility information like schedule,subscription details in DB tables. The report Server temp db keeps the session related information like SessionData, Snapshot, temp catalog and temp datasource etc. Report Designer :-  This is the tool used to design the report. For SSRS we have Report Builder and Business Intelligence Development Studio tools used to design reports. Data Source :-  Data Source is used to connect to the source from where data need...

SSAS 2008R2 Storage Modes

In SQL Server Analysis Services 2008, we have three storage mode options available to us: Relational Online Analytical Processing (ROLAP), Multidimensional Online Analytical Processing (MOLAP) and Hybrid Online Analytical Processing (HOLAP).  Relational Online Analytical Processing (ROLAP) The ROLAP storage mode allows the detail data and aggregations to be stored in the relational database. We have to be very careful on the Database design if we are using the ROLAP as the cube queries data directly from the Database and may cause performance issue if the Database design is not proper. Benifits Since the data is kept in the relational database instead of on the OLAP server, we can view the data in almost real time. Also, since the data is kept in the relational database, it allows for much larger amounts of data, which can mean better scalability. Low latency. Problems - Poor query performance as all the data stays in the Database. - We need to have per...

MS BI Syllabus

Microsoft Business Intelligence Course Syllabus SSRS – SQL Server Reporting Services  Getting Started 1. Understanding Reporting (Authoring,Management,Delivery) 2. Installing Reporting (Native Mode, SharePoint Integration mode) 3. Building your first report  Authoring Reports 1. Developing Basic Reports (RDL,wizard,designer,datasource,dataset,formatting) 2. Working with expressions (expression to calculate value, Agg functions, exp for objects) 3. Organizing Data (Data Regions, Table, Matrix, Chart, List) 4. Advance Report (Parameter, drill down, drill through, links, 5. Report Model (Data Source, Data Source View, Model , Report Builder 3.0)  Managing Report ( Report Manager) 1. Managing Content (deploying report, folders, linked reports, datasources, value etc) 2. Managing Security (Item Level , Site navigation, localhost – sql) 3. Managing Server Config (Config Manager, Report Manager, Report Server DB)  Delivering Report 1. Accessing Report (Viewing...